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

hieraklion · ‎2013-04-18

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

nigelg1965 · ‎2013-04-18

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 · ‎2013-04-18

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 · ‎2013-04-19

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

hieraklion · ‎2013-04-19

Hi,

Worstation, Netapp and server in the same tz

GRAEMEOGDEN · ‎2013-04-19

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 · ‎2013-04-19

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 · ‎2013-04-19

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 · ‎2013-04-19

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