Purpose : Active Directory Sites and System Center Configuration Manager Boundaries are hard to keep in sync – especially in an environment where there are regular changes and several team managing each technology separately. This Power BI dashboard solution will help analyze and reduce down the gaps in SCCM. The dashboard will help SCCM administrators […]

download : SQLQuery-find-agentsversions 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 […]