Enable Caption0 in Win32_TimeZone in client settings / hardware inventory. Then you can query caption0 in v_GS_Time_Zone which will show, for example, "(UTC-06:00) Central Time (US & Canada)" for Central time zone.
From: [email protected] [mailto:[email protected]] On Behalf Of Mukherjee, Surajit Sent: Thursday, March 20, 2014 5:19 AM To: [email protected] Subject: [mssms] Time zone thru sccm report Hi folks, Any way to find system time zone thru SCCM? I am getting the value in int using below query from SCCM db view dbo.v_GS_COMPUTER_SYSTEM which is not clear. SELECT dbo.v_GS_COMPUTER_SYSTEM.CurrentTimeZone0, dbo.v_R_System.Netbios_Name0 FROM dbo.v_GS_COMPUTER_SYSTEM INNER JOIN dbo.v_R_System ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID Thanks in advance for any help or guidance. Suraj _____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
