SCCM query timezone

In this article I would like to share the steps we have to do in order to get clients or servers Time Zone information, this request could be pretty common and required, therefore I really hope that the following details will be useful for you and your teams!

By default SCCM Hardware inventory doesn’t collection data about timezone, perhaps it is but no fully details, in order to collect this information first, we have to add those WMI to hardware inventory.

Open SCCM server and go to Administration > Overview > Client Settings
Then, Right click Default Client Settings and click Properties, > In the Hardware Inventory tab, click Set Classes:

 

On the search tab just type “time” and tick the group or whatever you would like to retrieve:

After that, we can wait for next hardware inventory cycle or run it manually, let’s do it manually.
Right click on eh collections >  first run: Download Computer Policy, then,  Collect Hardware Inventory:

You can monitor these actions on client operation:

Once fully query completed, from your end you can go a head and create timezone query.
Computer, Time Zone, like Windows 2016%

select distinct SMS_G_System_COMPUTER_SYSTEM.Name, SMS_G_System_TIME_ZONE.Caption, SMS_G_System_TIME_ZONE.Description, SMS_G_System_TIME_ZONE.TimeStamp from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_TIME_ZONE on SMS_G_System_TIME_ZONE.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows Server 2016 %"
  • Dear Folks,  Hope you are healthy and well, keep safe yourself!.
1 Comment
  1. Dudi Ovadia 3 months ago
    Reply

    SQL report

    select distinct
    s.Name0,
    os.InstallDate0,
    os.Version0,
    s.Operating_System_Name_and0,
    dst.Caption00,
    dst.StandardDay00,
    dst.StandardDayOfWeek00,
    dst.StandardMonth00

    From v_R_System s
    left join v_GS_SYSTEM_CONSOLE_USAGE con on con.ResourceID = s.ResourceID

    left join v_GS_OPERATING_SYSTEM OS on os.ResourceID = s.ResourceID
    left join TIME_ZONE_DATA DST on s.ResourceID=dst.MachineID

    where dst.Caption00 = ‘(UTC+02:00) Jerusalem’
    and (dst.StandardDay00 ‘5’ or dst.StandardDayOfWeek00 ‘0’ or dst.StandardMonth00 ’10’)

    order by os.InstallDate0,os.Version0, dst.StandardDay00 desc

Leave a Comment

Your email address will not be published.

Comment moderation is enabled. Your comment may take some time to appear.

In the news
Load More