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 […]

Download :  SQLQuery-Findmachines-withoutlook-locationspecific SELECT distinct b.Netbios_Name0, b.User_Name0, b.ad_site_name0, a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID WHERE FileName = ‘outlook.exe’ and AD_Site_Name0 like ‘%perth%’ ORDER BY b.Netbios_Name0

This is one guide that will take your SCCM skills and environment to a whole new level ! This would give you good insight into your infra and also let you understand how the enterprise class Microsoft Suite is behaving under the hood. The guide has also been implemented in several real world production environments […]

This guide will take you through troubleshooting guides, tips, tricks and tools to achieve 95%+ compliance in your environment and maximum coverage. The guide assumes the following environmental conditions:   Microsoft System Center Configuration Manager 2007 R3 WSUS 3.0 SP2 used as base for Software Updates Windows Client endpoints Three tier SCCM hierarchy   – […]

An awesome example of what power bi can do – and its all interactive and dynamic content – which sync’s with your sql data in real time. a little bit of sql and little bit of excel does the magic. The dashboard above was created to show the remnants of Office 2010 in the environment. […]