cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HEngineer
Engaged Sweeper

Hi,

How to create a report which shows all computers with SCCM agent installed?

Thanks

5 REPLIES 5

Is there a way to get the report without adding to the files/registery scanning 

Select Distinct Top 1000000 tblAssets.Domain,
  tblAssets.AssetID,
  tblAssets.assetname,
  tblAssets.oscode,
  tblProcesses.ExecutablePath,
  tblProcesses.Caption,
  Max(tblProcesses.Lastchanged) last_scan
From tblAssets
  Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetID
Where tblProcesses.caption Like 'CcmExec.exe'
Group By tblAssets.Domain,
  tblAssets.AssetID,
  tblAssets.assetname,
  tblAssets.oscode,
  tblProcesses.ExecutablePath,
  tblProcesses.Caption
Mister_Nobody
Honored Sweeper II

Did you see built-in reports? Filter by 'SCCM'

I couldn't find a report to show machines with SCCM agent installed