SCCM Agents Report

[HEngineer]

Hi,

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

Thanks

[Mister_Nobody]

https://community.lansweeper.com/t5/reports-analytics/workstation-sccm-report/td-p/17173

[HEngineer]

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

[Mister_Nobody]

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]

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

[HEngineer]

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