→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
davisr65
Engaged Sweeper

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

1 REPLY 1
brandon_jones
Champion Sweeper III
Under scanning click on file and registry scanning. Under file scanning and a file scan. In the filename field enter the path to the file.

You will then need to create a report that will show the computers that don't have the file. Below is a report that you can customize for you.

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


On the line 'Where tblFileVersions.FilePathfull Like '%filepath%' take out the word filepath and enter the name of the file that you entered in the file scan under settings. This will only work after you have entered the file scan under settings and the computers are scanned.