Scan / Report question

[crichie]

I've been given a query to run a report if I was using Microsoft SCCM. Since I'm using Lansweeper, I was curious if I could run the query but substitute the tables accordingly. Here is what was given to me to run. Could you help me format this so it reports correctly in Lansweeper?

SELECT SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath
FROM v_GS_SoftwareFile AS SF INNER JOIN
v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID
WHERE
(SF.FileName LIKE 'XTALK30.EXE') OR
(SF.FileName LIKE 'ATMFRAME.EXE') OR
(SF.FileName LIKE 'ACPMGR.EXE') OR
(SF.FileName LIKE 'ACT6530X.OCX') OR
(SF.FileName LIKE 'ATERM.OCX') OR
(SF.FileName LIKE 'EXTRA.EXE') OR
(SF.FileName LIKE 'EXTRA!.EXE') OR
(SF.FileName LIKE 'ACCMGR32.EXE') OR
(SF.FileName LIKE 'GRAPHX32.EXE') OR
(SF.FileName LIKE 'WINFTP32.DLL') OR
(SF.FileName LIKE 'PTR32.EXE') OR
(SF.FileName LIKE 'EMU.EXE') OR
(SF.FileName LIKE 'KEAVT.EXE') OR
(SF.FileName LIKE 'KEAHP.EXE') OR
(SF.FileName LIKE 'X.EXE') OR
(SF.FileName LIKE 'EASYVIEW.EXE') OR
(SF.FileName LIKE 'SMTBF.DLL') OR
(SF.FileName LIKE 'SMTBF32.DLL') OR
(SF.FileName LIKE 'r1.exe') OR
(SF.FileName LIKE 'r1win.exe') OR
(SF.FileName LIKE 'r2.exe') OR
(SF.FileName LIKE 'r2win.exe') OR
(SF.FileName LIKE 'r4.exe') OR
(SF.FileName LIKE 'r4win.exe') OR
(SF.FileName LIKE 'r7.exe') OR
(SF.FileName LIKE 'r8.exe') OR
(SF.FileName LIKE 'rdeploy.exe') OR
(SF.FileName LIKE 'r8win.exe') OR
(SF.FileName LIKE 'r3win.exe') OR
(SF.FileName LIKE 'rsshd.exe') OR
(SF.FileName LIKE 'rftp.exe') OR
(SF.FileName LIKE 'rftpc.exe') OR
(SF.FileName LIKE 'rlat.dll') OR
(SF.FileName LIKE 'mnfserv.exe') OR
(SF.FileName LIKE 'rnnfserv.exe') OR
(SF.FileName LIKE 'rnnfsadm.exe') OR
(SF.FileName LIKE 'nfsgwapp.exe') OR
(SF.FileName LIKE 'bdes.dll') OR
(SF.FileName LIKE 'Rx.exe') OR
(SF.FileName LIKE 'R.exe') OR
(SF.FileName LIKE 'Rx2008.jar') OR
(SF.FileName LIKE 'rxmgr.exe') OR
(SF.FileName LIKE 'r4macsngl42.sea') OR
(SF.FileName LIKE 'r2macsngl41.sea')

[Hemoco]

This is not possible unless you know where your executable is stored. You could add some file scanning to the section custom scanning and then make a report like below, but I guess that's not what you want. Would take to much time for each scanning to find all executables on the harddisk.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.Lastchanged As Lastchanged1,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where (tblFileVersions.FilePathfull Like '%XTALK30.EXE%') Or
(tblFileVersions.FilePathfull Like '%ATMFRAME.EXE%') Or
(tblFileVersions.FilePathfull Like '%ACPMGR.EXE%') Or
(tblFileVersions.FilePathfull Like '%ACT6530X.OCX%') Or
(tblFileVersions.FilePathfull Like '%ATERM.OCX%') Or
(tblFileVersions.FilePathfull Like '%EXTRA.EXE%') Or
(tblFileVersions.FilePathfull Like '%EXTRA!.EXE%') Or
(tblFileVersions.FilePathfull Like '%ACCMGR32.EXE%') Or
(tblFileVersions.FilePathfull Like '%GRAPHX32.EXE%') Or
(tblFileVersions.FilePathfull Like '%WINFTP32.DLL%') Or
(tblFileVersions.FilePathfull Like '%PTR32.EXE%') Or
(tblFileVersions.FilePathfull Like '%EMU.EXE%') Or
(tblFileVersions.FilePathfull Like '%KEAVT.EXE%') Or
(tblFileVersions.FilePathfull Like '%KEAHP.EXE%') Or
(tblFileVersions.FilePathfull Like '%X.EXE%') Or
(tblFileVersions.FilePathfull Like '%EASYVIEW.EXE%') Or
(tblFileVersions.FilePathfull Like '%SMTBF.DLL%') Or
(tblFileVersions.FilePathfull Like '%SMTBF32.DLL%') Or
(tblFileVersions.FilePathfull Like '%r1.exe%') Or
(tblFileVersions.FilePathfull Like '%r1win.exe%') Or
(tblFileVersions.FilePathfull Like '%r2.exe%') Or
(tblFileVersions.FilePathfull Like '%r2win.exe%') Or
(tblFileVersions.FilePathfull Like '%r4.exe%') Or
(tblFileVersions.FilePathfull Like '%r4win.exe%') Or
(tblFileVersions.FilePathfull Like '%r7.exe%') Or
(tblFileVersions.FilePathfull Like '%r8.exe%') Or
(tblFileVersions.FilePathfull Like '%rdeploy.exe%') Or
(tblFileVersions.FilePathfull Like '%r8win.exe%') Or
(tblFileVersions.FilePathfull Like '%r3win.exe%') Or
(tblFileVersions.FilePathfull Like '%rsshd.exe%') Or
(tblFileVersions.FilePathfull Like '%rftp.exe%') Or
(tblFileVersions.FilePathfull Like '%rftpc.exe%') Or
(tblFileVersions.FilePathfull Like '%rlat.dll%') Or
(tblFileVersions.FilePathfull Like '%mnfserv.exe%') Or
(tblFileVersions.FilePathfull Like '%rnnfserv.exe%') Or
(tblFileVersions.FilePathfull Like '%rnnfsadm.exe%') Or
(tblFileVersions.FilePathfull Like '%nfsgwapp.exe%') Or
(tblFileVersions.FilePathfull Like '%bdes.dll%') Or
(tblFileVersions.FilePathfull Like '%Rx.exe%') Or
(tblFileVersions.FilePathfull Like '%R.exe%') Or
(tblFileVersions.FilePathfull Like '%Rx2008.jar%') Or
(tblFileVersions.FilePathfull Like '%rxmgr.exe%') Or
(tblFileVersions.FilePathfull Like '%r4macsngl42.sea%') Or
(tblFileVersions.FilePathfull Like '%r2macsngl41.sea%') Or
(tblFileVersions.FilePathfull Like '%iexplorer.exe%')