‎08-27-2013 09:22 PM
Solved! Go to Solution.
‎08-28-2013 06:45 PM
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
‎08-28-2013 09:52 PM
‎08-28-2013 06:45 PM
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
‎08-28-2013 06:17 PM
‎08-28-2013 06:08 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now