SQL Query : SCCM Client Version and Install Status

Use this query to get a view of different SCCM Client versions installed across the estate.

SELECT distinct
 SYS.Name0 as 'Machine Name',
 SYS.User_Name0 as 'Login ID',
 SYS.User_Domain0 as 'Domain',
 USR.Full_User_Name0 as 'Full Name',
 case
 when SYS.Client0 = 1 then 'Yes'
 when SYS.Client0 = 0 then 'No'
 else convert(varchar(2), SYS.Client0)
 end as 'Client Installed',
 SYS.Client_Version0 as 'Client Version'
 FROM v_R_System SYS
 join v_FullCollectionMembership FCM on SYS.ResourceID = FCM.ResourceID
 join v_Collection CN on FCM.CollectionID = CN.CollectionID
 join v_R_User USR on SYS.User_Name0 = USR.User_Name0
 WHERE CN.Name = 'All Systems'

Change the CN.Name to return the info for a different collection.

Sample OUTPUT

Related posts

Leave a Comment