Submit your file scans under Configuration/Scanning Setup/Custom Scanning, rescan your machines and run the report below to list computers that meet both requirements.
Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Where (tblAssets.AssetID In (Select Top 1000000 tblFileVersions.AssetID From tblFileVersions Where tblFileVersions.Found = 1 And tblFileVersions.FilePathfull = 'c:\program files\application\filename.dll') And tblAssets.AssetID Not In (Select Top 1000000 tblFileVersions.AssetID From tblFileVersions Where tblFileVersions.Found = 1 And tblFileVersions.FilePathfull = 'c:\program files\application\filename.exe')) And tblAssets.Lastseen Is Not Null And tblAssetCustom.State = 1 Order By tblAssets.Domain, tblAssets.AssetName
Submit your file scans under Configuration/Scanning Setup/Custom Scanning, rescan your machines and run the report below to list computers that meet both requirements.
Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.IPAddress, tblAssets.Firstseen, tblAssets.Lastseen From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Where (tblAssets.AssetID In (Select Top 1000000 tblFileVersions.AssetID From tblFileVersions Where tblFileVersions.Found = 1 And tblFileVersions.FilePathfull = 'c:\program files\application\filename.dll') And tblAssets.AssetID Not In (Select Top 1000000 tblFileVersions.AssetID From tblFileVersions Where tblFileVersions.Found = 1 And tblFileVersions.FilePathfull = 'c:\program files\application\filename.exe')) And tblAssets.Lastseen Is Not Null And tblAssetCustom.State = 1 Order By tblAssets.Domain, tblAssets.AssetName
Yes i know the exact path that both the dll and the exe will be in so i just want to be able to look for all computers with the c:\program files\application\filename.dll and then in those show the ones that don't have the c:\program files\application\filename.exe
These kinds of queries are possible, but you cannot search an entire computer for a specific DLL/EXE, if this is what you're trying to do. You can only submit specific file paths and value names for file and registry scanning.
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.