I set up two file scans that are working correctly and showing present or not present on the assets but the report I am trying shows all assets with first file present even using "and where XXXX not like xxx". What is the correct format for showing assets with the .olb but excluding those that also have the .exe?
Select Top 1000000 tsysOS.Image As icon,
tblAssets.Username,
tblAssets.AssetID,
tblAssets.AssetName,
tblFileVersions.Found,
tblFileVersions.Lastchanged As [Files last changed],
tblAssets.Description,
tblAssetCustom.Model,
tsysOS.OSname As OS
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblFileVersions.Found = 'True' And tblFileVersions.FilePathfull Not Like
'%winword.exe' And tblFileVersions.FilePathfull Like '%msword.olb' And
tblAssets.Assettype = -1
Order By tblAssets.Username,
tblAssets.AssetName
