‎05-27-2024 08:55 AM
Hi,
How to create a report which shows all computers with SCCM agent installed?
Thanks
‎05-27-2024 10:40 AM
‎05-27-2024 11:20 AM
Is there a way to get the report without adding to the files/registery scanning
‎05-27-2024 11:50 AM
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
‎05-27-2024 10:38 AM
Did you see built-in reports? Filter by 'SCCM'
‎05-27-2024 11:20 AM
I couldn't find a report to show machines with SCCM agent installed
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now