SQL Query : Systems With Hardware Scan > 60 Days ago

You can identify devices which have not checked in for some time, or those with potentially faulty SCCM clients using this query.  SELECT a.ResourceID, a.Netbios_name0, b.LastHWScan FROM v_R_System a INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID WHERE b.LastHWScan <= Dateadd(day, -60, getdate()) order by LastHWScan desc Sample Output    

Read More

Powershell : Extend SCCM Hardware Inventory

This scenario involves creation of new WMI classes on a PC to capture custom registry settings which have been populated using a script run from a GPO. Create new WMI classes on an example PC import WMI-Commands.psm1 module from https://gallery.technet.microsoft.com/WMI-PowerShell-cmdlets-ac049637 New-WMIClass -ClassName “BitLockerReport” in the Root\cimV2 namespace New-WMIClass -ClassName “aaaa”,”bbbb” to create two new classes in Root\cimV2 New-WMIProperty -ClassName “BitLockerReport” -PropertyName “BitLockerHash”  (note that you can add -PropertyValue to define the default value for the new property Add the new WMI classes to Client Settings SCCM Console – Administration >…

Read More