Hi experts, I don't seem to be able to find confirmation on this so I refer to wealth of knowledge as this site.

This is refering specifically to querying SCCM db directly with SQL.

Is the format of v_GS_OPERATING_SYSTEM.lastbootuptime0 client machine dependant? I assume that as this is hardware inventory that the date is retrieved directly from the machine not from any AD interaction.

Example, I have PCs sitting on multiple domains in multiple countries with, obviously, various client regional date settings. So could running a query across all machines potentially return multiple date formats?

v_GS_OPERATING_SYSTEM also has a local0 (eg. Oc09) would that be a definitive source to determine the date format to apply to the lastbootuptime0?

One last thing... I dare to ask in this forum... are the answers to the above questions also true for 2012 sccm?

Thanks folks.

Times stored in UTC with offset stored elsewhere

See this recent post about how to capture the offset data too

https://social.technet.microsoft.com/Forums/en-US/75c48fdb-1b50-4256-87a7-2547114f9778/time-zone-report-in-local-time-zone?forum=configmanagergeneral#a641cdfc-ba90-4fa6-add2-3d2bc94eae0a

Same applies to 2012

Times stored in UTC with offset stored elsewhere

See this recent post about how to capture the offset data too

https://social.technet.microsoft.com/Forums/en-US/75c48fdb-1b50-4256-87a7-2547114f9778/time-zone-report-in-local-time-zone?forum=configmanagergeneral#a641cdfc-ba90-4fa6-add2-3d2bc94eae0a

Same applies to 2012

• Proposed as answer by Garth JonesMVP, Moderator Saturday, February 21, 2015 3:15 PM

Yes that answer is true for cm12.

The only way to know for sure is to review the underlying wmi class and it doesn't says what it is. https://msdn.microsoft.com/en-us/library/aa394239(v=vs.85).aspx but I would assume it is local time.