Hi,
I am trying to create a report which will search all laptops for the following files and report the machines which they are both not found. This is what I have so far but it is not working and bringing in loads of other machines which are not laptops. - any help appreciated.
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tblassets.Username,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblFileVersions.FilePathfull,
tblFileVersions.Found
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblFileVersions On tblassets.AssetID =
tblFileVersions.AssetID
Where (tblassets.AssetName Like '%LT%' And tblFileVersions.FilePathfull =
'C:\ProgramData\Cisco\Cisco AnyConnect Secure Mobility Client\Profile\WelcomStaffSBL_client_profile.xml') Or
(tblFileVersions.FilePathfull =
'C:\OneDrive Migration\HomeFolders_OneDrive_Migration.bat' And
tblFileVersions.Found = 'FALSE' And tblassetcustom.State = 1)
