Microsoft Virtualization Discussions

Outputs different betwenn PowerShell toolkit and command line for snapshot name and created date

hieraklion
4,214 Views

Bonjour from Paris, France.

The name and the created field seems to not mismatch between the output into the powershell and the command line. The command line is accurate. The Toolkit output is wrong.

Test case :

I created a script that list snapshots for a specific volume.

Below is the partial code :

>>get-nasnapshot vol_nav_db_data01 | select created, name

Created                                                                                                     Name                                                                                                    
-------                                                                                                     ----                                                                                                    
18/04/2013 14:41:30                                                                                         sqlsnap__e0530006__recent                                                                               
16/04/2013 11:20:27                                                                                         sqlsnap__e0530006_04-16-2013_13.17.38__daily                                                            
16/04/2013 12:16:05                                                                                         sqlsnap__e0530006_04-16-2013_14.13.04__daily                                                            
16/04/2013 13:21:50                                                                                         sqlsnap__e0530006_04-16-2013_15.18.53__daily                                                            
16/04/2013 15:20:55                                                                                         sqlsnap__e0530006_04-16-2013_17.17.53__daily                                                            
16/04/2013 18:20:58                                                                                         sqlsnap__e0530006_04-16-2013_20.17.47__daily                                                            
16/04/2013 19:20:31                                                                                         sqlsnap__e0530006_04-16-2013_21.17.31__daily                                                            
16/04/2013 20:20:24                                                                                         sqlsnap__e0530006_04-16-2013_22.17.26__daily                                                            
16/04/2013 21:20:49                                                                                         sqlsnap__e0530006_04-16-2013_23.17.47__daily                                                            
16/04/2013 22:20:42                                                                                         sqlsnap__e0530006_04-17-2013_00.17.40__daily                                                            
16/04/2013 23:20:32                                                                                         sqlsnap__e0530006_04-17-2013_01.17.39__daily                                                            
17/04/2013 00:20:38                                                                                         sqlsnap__e0530006_04-17-2013_02.17.48__daily                                                            
17/04/2013 01:20:30                                                                                         sqlsnap__e0530006_04-17-2013_03.17.34__daily                                                            
17/04/2013 02:20:37                                                                                         sqlsnap__e0530006_04-17-2013_04.17.45__daily                                                            
17/04/2013 03:20:49                                                                                         sqlsnap__e0530006_04-17-2013_05.17.49__daily                                                            
17/04/2013 04:20:55                                                                                         sqlsnap__e0530006_04-17-2013_06.17.47__daily                                                            
17/04/2013 05:20:27                                                                                         sqlsnap__e0530006_04-17-2013_07.17.23__daily                                                            
17/04/2013 06:20:50                                                                                         sqlsnap__e0530006_04-17-2013_08.17.48__daily                                                            
17/04/2013 07:20:41                                                                                         sqlsnap__e0530006_04-17-2013_09.17.45__daily                                                            
17/04/2013 09:20:38                                                                                         sqlsnap__e0530006_04-17-2013_11.17.35__daily                                                            
17/04/2013 10:21:54                                                                                         sqlsnap__e0530006_04-17-2013_12.16.12__daily                                                            
17/04/2013 11:20:46                                                                                         sqlsnap__e0530006_04-17-2013_13.17.52__daily                                                            
17/04/2013 12:20:24                                                                                         sqlsnap__e0530006_04-17-2013_14.17.42__daily                                                            
17/04/2013 16:20:31                                                                                         sqlsnap__e0530006_04-17-2013_18.17.28__daily                                                            
17/04/2013 17:20:37                                                                                         sqlsnap__e0530006_04-17-2013_19.17.37__daily                                                            
17/04/2013 18:20:46                                                                                         sqlsnap__e0530006_04-17-2013_20.17.38__daily                                                            
17/04/2013 19:20:47                                                                                         sqlsnap__e0530006_04-17-2013_21.17.45__daily                                                            
17/04/2013 20:20:26                                                                                         sqlsnap__e0530006_04-17-2013_22.17.25__daily                                                            
17/04/2013 21:20:31                                                                                         sqlsnap__e0530006_04-17-2013_23.17.28__daily                                                            
17/04/2013 22:20:28                                                                                         sqlsnap__e0530006_04-18-2013_00.17.27__daily                                                            
17/04/2013 23:20:45                                                                                         sqlsnap__e0530006_04-18-2013_01.17.44__daily                                                            
18/04/2013 00:20:11                                                                                         sqlsnap__e0530006_04-18-2013_02.17.19__daily                                                            
18/04/2013 01:20:23                                                                                         sqlsnap__e0530006_04-18-2013_03.17.21__daily                                                            
18/04/2013 02:20:49                                                                                         sqlsnap__e0530006_04-18-2013_04.17.46__daily                                                            
18/04/2013 03:20:41                                                                                         sqlsnap__e0530006_04-18-2013_05.17.39__daily                                                            
18/04/2013 04:20:41                                                                                         sqlsnap__e0530006_04-18-2013_06.17.40__daily                                                            
18/04/2013 05:20:41                                                                                         sqlsnap__e0530006_04-18-2013_07.17.36__daily                                                            
18/04/2013 06:20:48                                                                                         sqlsnap__e0530006_04-18-2013_08.17.42__daily                                                            
18/04/2013 07:20:33                                                                                         sqlsnap__e0530006_04-18-2013_09.17.34__daily                                                            
18/04/2013 08:20:32                                                                                         sqlsnap__e0530006_04-18-2013_10.17.39__daily                                                            
18/04/2013 09:20:35                                                                                         sqlsnap__e0530006_04-18-2013_11.17.37__daily                                                            
18/04/2013 10:21:02                                                                                         sqlsnap__e0530006_04-18-2013_12.18.17__daily                                                            
18/04/2013 11:41:48                                                                                         sqlsnap__e0530006_04-18-2013_13.40.19                                                                   
18/04/2013 13:38:16                                                                                         sqlsnap__e0530006_04-18-2013_15.35.33__daily                                                            
18/04/2013 14:05:46    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!                                                                                     sqlsnap__e0530006_04-18-2013_16.02.54__daily  

but in the command line, I received

> snap list  vol_nav_db_data01

Volume vol_nav_db_data01

working...

  %/used       %/total  date          name

----------  ----------  ------------  --------

  0% ( 0%)    0% ( 0%)  Apr 18 16:41  sqlsnap__e0530006__recent (busy,vclone)

  0% ( 0%)    0% ( 0%)  Apr 18 16:05  sqlsnap__e0530006_04-18-2013_16.02.54__daily

  0% ( 0%)    0% ( 0%)  Apr 18 15:38  sqlsnap__e0530006_04-18-2013_15.35.33__daily

  0% ( 0%)    0% ( 0%)  Apr 18 13:41  sqlsnap__e0530006_04-18-2013_13.40.19 (busy,vclone)

  0% ( 0%)    0% ( 0%)  Apr 18 12:21  sqlsnap__e0530006_04-18-2013_12.18.17__daily

  0% ( 0%)    0% ( 0%)  Apr 18 11:20  sqlsnap__e0530006_04-18-2013_11.17.37__daily

  0% ( 0%)    0% ( 0%)  Apr 18 10:20  sqlsnap__e0530006_04-18-2013_10.17.39__daily

  0% ( 0%)    0% ( 0%)  Apr 18 09:20  sqlsnap__e0530006_04-18-2013_09.17.34__daily

  0% ( 0%)    0% ( 0%)  Apr 18 08:20  sqlsnap__e0530006_04-18-2013_08.17.42__daily

  0% ( 0%)    0% ( 0%)  Apr 18 07:20  sqlsnap__e0530006_04-18-2013_07.17.36__daily

  0% ( 0%)    0% ( 0%)  Apr 18 06:20  sqlsnap__e0530006_04-18-2013_06.17.40__daily

  0% ( 0%)    0% ( 0%)  Apr 18 05:20  sqlsnap__e0530006_04-18-2013_05.17.39__daily

  0% ( 0%)    0% ( 0%)  Apr 18 04:20  sqlsnap__e0530006_04-18-2013_04.17.46__daily

  0% ( 0%)    0% ( 0%)  Apr 18 03:20  sqlsnap__e0530006_04-18-2013_03.17.21__daily

  0% ( 0%)    0% ( 0%)  Apr 18 02:20  sqlsnap__e0530006_04-18-2013_02.17.19__daily

  0% ( 0%)    0% ( 0%)  Apr 18 01:20  sqlsnap__e0530006_04-18-2013_01.17.44__daily

  0% ( 0%)    0% ( 0%)  Apr 18 00:20  sqlsnap__e0530006_04-18-2013_00.17.27__daily

  0% ( 0%)    0% ( 0%)  Apr 17 23:20  sqlsnap__e0530006_04-17-2013_23.17.28__daily

  0% ( 0%)    0% ( 0%)  Apr 17 22:20  sqlsnap__e0530006_04-17-2013_22.17.25__daily

  0% ( 0%)    0% ( 0%)  Apr 17 21:20  sqlsnap__e0530006_04-17-2013_21.17.45__daily

  0% ( 0%)    0% ( 0%)  Apr 17 20:20  sqlsnap__e0530006_04-17-2013_20.17.38__daily

  0% ( 0%)    0% ( 0%)  Apr 17 19:20  sqlsnap__e0530006_04-17-2013_19.17.37__daily

  0% ( 0%)    0% ( 0%)  Apr 17 18:20  sqlsnap__e0530006_04-17-2013_18.17.28__daily

  0% ( 0%)    0% ( 0%)  Apr 17 14:20  sqlsnap__e0530006_04-17-2013_14.17.42__daily

  0% ( 0%)    0% ( 0%)  Apr 17 13:20  sqlsnap__e0530006_04-17-2013_13.17.52__daily

  0% ( 0%)    0% ( 0%)  Apr 17 12:21  sqlsnap__e0530006_04-17-2013_12.16.12__daily

  0% ( 0%)    0% ( 0%)  Apr 17 11:20  sqlsnap__e0530006_04-17-2013_11.17.35__daily

  0% ( 0%)    0% ( 0%)  Apr 17 09:20  sqlsnap__e0530006_04-17-2013_09.17.45__daily

  0% ( 0%)    0% ( 0%)  Apr 17 08:20  sqlsnap__e0530006_04-17-2013_08.17.48__daily

  0% ( 0%)    0% ( 0%)  Apr 17 07:20  sqlsnap__e0530006_04-17-2013_07.17.23__daily

  0% ( 0%)    0% ( 0%)  Apr 17 06:20  sqlsnap__e0530006_04-17-2013_06.17.47__daily

  0% ( 0%)    0% ( 0%)  Apr 17 05:20  sqlsnap__e0530006_04-17-2013_05.17.49__daily

  0% ( 0%)    0% ( 0%)  Apr 17 04:20  sqlsnap__e0530006_04-17-2013_04.17.45__daily (busy,vclone)

  0% ( 0%)    0% ( 0%)  Apr 17 03:20  sqlsnap__e0530006_04-17-2013_03.17.34__daily

  0% ( 0%)    0% ( 0%)  Apr 17 02:20  sqlsnap__e0530006_04-17-2013_02.17.48__daily

  0% ( 0%)    0% ( 0%)  Apr 17 01:20  sqlsnap__e0530006_04-17-2013_01.17.39__daily

  0% ( 0%)    0% ( 0%)  Apr 17 00:20  sqlsnap__e0530006_04-17-2013_00.17.40__daily

  0% ( 0%)    0% ( 0%)  Apr 16 23:20  sqlsnap__e0530006_04-16-2013_23.17.47__daily

  0% ( 0%)    0% ( 0%)  Apr 16 22:20  sqlsnap__e0530006_04-16-2013_22.17.26__daily

  0% ( 0%)    0% ( 0%)  Apr 16 21:20  sqlsnap__e0530006_04-16-2013_21.17.31__daily

  0% ( 0%)    0% ( 0%)  Apr 16 20:20  sqlsnap__e0530006_04-16-2013_20.17.47__daily

  0% ( 0%)    0% ( 0%)  Apr 16 17:20  sqlsnap__e0530006_04-16-2013_17.17.53__daily

  0% ( 0%)    0% ( 0%)  Apr 16 15:21  sqlsnap__e0530006_04-16-2013_15.18.53__daily

  0% ( 0%)    0% ( 0%)  Apr 16 14:16  sqlsnap__e0530006_04-16-2013_14.13.04__daily

If you have an idea ?

Thyansk

8 REPLIES 8

nigelg1965
4,214 Views

Hi

Seems to be a consistent 2 hour difference.

Could it be that your workstation is set to one time zone and your filer to another?

JGPSHNTAP
4,214 Views

I'm still not sure what i'm seeing... can you do this please

get-nasnapshot vol_nav_db_data01 | select Name,Created | sort Created -descending

hieraklion
4,214 Views

Unfortunately, no, I rease all snapshots. It was a test.

hieraklion
4,214 Views

Hi,

Worstation, Netapp and server in the same tz

GRAEMEOGDEN
4,214 Views

What version of the toolkit are you using?

Also check this thread, had similar problems in the past with GMT/BST changes.

https://communities.netapp.com/message/77428#77428

nigelg1965
4,214 Views

I'd say the powershell command is returning the raw data from the api of the date in UTC - the filer ontap command returns the date in it's configured timezone, which I'd guess is CEST.

JOHNGARRETT
4,214 Views

Two thoughts:

Just so we're clear, run a get-date in powershell and a date in Ontap. Make sure they match.

SMSQL is creating your snapshots, right? Check the server creating the snapshots and see if that server has the correct time as well. If you were to do a snap create <vol> <snapname> and then run a snap list, does it match your get-nasnapshot output (taking SMSQL out of the picture)?

Something is out of whack because the snapshot name and the Created property of the snapshot don't match.

beam
4,214 Views

Which version of the Toolkit are you using?  There was an issue where the UTC time returned by the API was interpreted as a Local time, causing the created value to appear incorrectly.  This was fixed with Toolkit 2.3.  See this thread: https://communities.netapp.com/thread/24886

-Steven

Public