SCCM Client Version Report

In order to help understand what versions of the SCCM client is out there within our environment I have pulled together this SQL query to help:

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.7711.0000' then 'CM12 RTM (5.00.7711.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.7804.1500' then 'CM12 SP1 CU4 (5.00.7804.1500)'
when '5.00.7804.1600' then 'CM12 SP1 CU5 (5.00.7804.1600)'
when '5.00.8239.1000' then 'CM12 SP2 (5.00.8239.1000)'
when '5.00.8239.1203' then 'CM12 SP2 CU1 (5.00.8239.1203)'
when '5.00.8239.1301' then 'CM12 SP2 CU2 (5.00.8239.1301)'
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)'
when '5.00.7958.1501' then 'CM12 R2 CU4 (5.00.7958.1501)'
when '5.00.7958.1604' then 'CM12 R2 CU5 (5.00.7958.1604)'
when '5.00.8239.1000' then 'CM12 R2 SP1 (5.00.8239.1000)'
when '5.00.8239.1203' then 'CM12 R2 SP1 CU1 (5.00.8239.1203)'
when '5.00.8239.1301' then 'CM12 R2 SP1 CU2 (5.00.8239.1301)'
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

Where has the System Centre Management service gone?

Have been doing some work with System Center Operations Manager (SCOM) 2012 R2 this week and after some changes I had to restart the SCOM agent service to make them take effect.  Only I couldn't find the "System Center Management" service to do this however, it appears Microsoft has rebranded the service and it's now called the "Microsoft Monitoring Agent" service.

Along with the rebranding of the service, Microsoft have added functionality to the agent.  It now has standalone features.

To get more information about MMA and it’s new functionalities here are some useful links:

• How to enable MMA for standalone functionality
• Download location of MMA as a separate product
• Monitoring with MMA explained (TechNet)