→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here
3 weeks ago
Hi,
How to create a report which shows all computers with SCCM agent installed?
Thanks
3 weeks ago
3 weeks ago
Is there a way to get the report without adding to the files/registery scanning
3 weeks ago
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
3 weeks ago
Did you see built-in reports? Filter by 'SCCM'
3 weeks ago
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