Need a Report for specific existing Autorun command - exists or not exists

[tenupmoc]

Hello,

i need a specific sql query for tblAutorunUNI.command "C:\Program Files\Microsoft OneDrive\OneDrive.exe" /background" , that reports all clients, if the command exists or not exists.

Doing a query for is not like 'C:\Program Files\Microsoft OneDrive\OneDrive.exe' reports all other autorun commands too.

[Mister_Nobody]

Try this

Select Top (1000000) tblAssets.AssetID,
  tblAssets.Domain,
  tblAssets.AssetName,
  tblAutorunUni.Caption,
  tblAutorunUni.Command,
  tblAutorunUni.CreationDate,
  tblAutorun.Lastchanged
From tblAssets
  Inner Join tblAutorun On tblAssets.AssetID = tblAutorun.AssetID
  Inner Join tblAutorunUni On tblAutorun.AutorunUNI = tblAutorunUni.AutorunUNI
Where tblAutorunUni.Command Like '%\OneDrive.exe" /background'
Order By tblAutorun.Lastchanged Desc

[tenupmoc]

Thx,

but this report will only show all assets where the command line exists.

I need a report, that shows all assets where the command line exists or not exists, you know.

All information in one report.

[Mister_Nobody]

IMHO, it is useless but take SQL:

Select Top 1000000 tblAutorun.assetid,
  tblAssets.assetname,
  tblAutorunUni.Command,
  Count(tblAutorunUni.Command) onedrive_present
From tblAssets
  Inner Join tblAutorun On tblAssets.AssetID = tblAutorun.AssetID
  Left Join tblAutorunUni On tblAutorun.AutorunUNI = tblAutorunUni.AutorunUNI
      And tblAutorunUni.Command Like '%\OneDrive.exe" /background'
Group By tblAutorun.assetid,
  tblAssets.assetname,
  tblAutorunUni.Command