Report for SCCM client agent version

Question

_{Monday, August 28, 2017 6:16 AM}

Hi, I'm trying to get all the servers SCCM client agent version in my collection. When I run the "Scan  1 - Last Scan by collection" reports I get the WSUS Enterprise Server for SCCM Clients: 6.3.9600.18324. 

When I compare to the website below which for my SCCM 1702 it should be version 5.00.8498.1007 or below. How I get the SCCM report reflecting the client version in the report ?

https://buildnumbers.wordpress.com/sccm/

All replies (4)

_{Monday, August 28, 2017 6:37 AM ✅Answered | 1 vote}

Client_version0 from view v_R_Sytems does contain it.

Torsten Meringer | http://www.mssccmfaq.de

_{Monday, August 28, 2017 8:45 AM}

Sorry do you mean this will be under Reporting -> Reports or it's a query collection ?

_{Monday, August 28, 2017 12:31 PM}

The WSUS client is not the ConfigMgr client so those are two different version numbers.

There may or may not be a default report that contains the client agent version number but you can easily create one simply query the DB directly using the info that Torsten gave you. Alternatively, you can create a simple query in the ConfigMgr console itself and get the client agent version from the System class (SMS_R_System).

Jason | https://home.configmgrftw.com | @jasonsandys

_{Monday, August 28, 2017 2:07 PM}

You can use the following SQL query or create report to get the client versions http://eskonr.com/2013/09/sccm-configmgr-2012-ssrs-reportcount-of-client-versions/

Though the following SQL code is for Configmgr 2007 and 12 ,you can still update this for Configmgr Current branch by adding the when condition with Version name and turn this to report.

select sys.Client_Version0, "CM Name"=
case sys.Client_Version0
when '4.00.6487.2000' then 'CM07 SP2 (4.00.6487.2000)'
when '4.00.6487.2188' then 'CM07 R3 (4.00.6487.2188)'
when '4.00.6487.2187' then 'CM07 R3 (4.00.6487.2187)'
when '4.00.6487.2157' then 'CM07 R3 (4.00.6487.2157)'
when '5.00.0000.0000' then 'CM12 RTM (5.00.0000.0000)'
when '5.00.7804.1000' then 'CM12 SP1 (5.00.7804.1000)'
when '5.00.7804.1202' then 'CM12 SP1 CU1 (5.00.7804.1202)'
when '5.00.7804.1300' then 'CM12 SP1 CU2 (5.00.7804.1300)'
when '5.00.7804.1400' then 'CM12 SP1 CU3 (5.00.7804.1400)'
when '5.00.7958.1000' then 'CM12 R2 (5.00.7958.1000)'
when '5.00.7958.1101' then 'CM12 R2 KB 2905002(5.00.7958.1101)'
when '5.00.7958.1203' then 'CM12 R2 CU1 (5.00.7958.1203)'
when '5.00.7958.1303' then 'CM12 R2 CU2 (5.00.7958.1303)'
when '5.00.7958.1401' then 'CM12 R2 CU3 (5.00.7958.1401)'
else 'Others(non-Clients)'
End,count(*) [Total]
from v_R_System sys
where sys.Name0 not like 'unknown' and
sys.Client_Version0 not like '' and sys.Client_Version0 not like '0.0%'
group by sys.Client_Version0
order by 3 desc

Eswar Koneti | Configmgr Blog: http://www.eskonr.com | Linkedin: eskonr | Twitter: @eskonr