In enterprise environments, tracking software installations across different regions is essential for compliance, support, and inventory management. This blog post provides an SCCM SQL query to help identify devices with a specific version of Google Chrome installed, categorized by geographic region, user, and install date.
📄 The SQL Query
SELECT
SYS.Name0 AS
[Device Name],
SYS.User_Name0 AS
[Last Logged On User],
ARP.InstallDate0
AS [Install Date],
CASE
CS.CurrentTimeZone0
WHEN -300 THEN
'USA (Central Time)'
WHEN -240 THEN
'Puerto Rico / Atlantic Time'
WHEN 60 THEN
'UK / Western Europe'
WHEN 120 THEN
'Central Europe / South Africa'
WHEN 180 THEN
'Eastern Europe / Russia'
WHEN 480 THEN
'India / APAC'
ELSE 'Unknown
Region'
END AS
[Country/Region],
ARP.DisplayName0
AS [Application Name],
ARP.Version0 AS
[Version]
FROM
v_R_System AS
SYS
INNER JOIN
v_Add_Remove_Programs AS ARP
ON
SYS.ResourceID = ARP.ResourceID
LEFT JOIN
v_GS_Computer_System AS CS
ON
SYS.ResourceID = CS.ResourceID
WHERE
ARP.DisplayName0
LIKE '%Chrome%'
AND ARP.Version0 =
'5.9.124'
ORDER BY
[Country/Region],
SYS.Name0;
Time Zone to Region Mapping
| CurrentTimeZone0 | Region Description |
| ------------------ | ----------------------------- |
| -300 |
USA (Central Time) |
| -240 |
Puerto Rico / Atlantic Time |
| 60 |
UK / Western Europe |
| 120 |
Central Europe / South Africa |
| 180 |
Eastern Europe / Russia |
| 480 |
India / APAC |
| Other values |
Unknown Region |
🔚Final Thoughts
Tracking Chrome installations by version and region helps ensure that your environment is secure, compliant, and up to date. This query is a straightforward way to get that insight leveraging SCCM data.
No comments:
Post a Comment