→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !
‎04-22-2021 02:47 PM - last edited on ‎04-01-2024 04:16 PM by Mercedes_O
I recently deployed a copy of an executable file to the users" desktop and start menu. I am receiving notification from some users that they never received the file. Rather than connecting to each computer manually, is there a way i can do an inventory for the executable in question to find which computer does not have the file?
thx
‎04-22-2021 10:09 PM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
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 tblFileVersions.FilePathfull Like '%filepath' And
tblFileVersions.Found = 'false' And tblassetcustom.State = 1
Order By tblassets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now