
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
Labels:
- Labels:
-
API & Integrations
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2021 10:09 PM
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.
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.
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.
