Notification

Icon
Error

Verify a successful copy to user computer - how to inventory all computers for a copied file.

Posted: Thursday, April 22, 2021 1:47:29 PM(UTC)
davisr65

davisr65

Member Original PosterPosts: 1
0
Like
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
Brandon
#1Brandon Member Posts: 169  
posted: 4/22/2021 9:09:50 PM(UTC)
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.

Quote:
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.

Active Discussions

Lansweeper Monitor history showing only last monitors
by  cross_eur   Go to last post Go to first unread
Last post: 7/23/2021 6:06:51 PM(UTC)
Lansweeper Report Login time reduces number of computers by 300
by  cross_eur  
Go to last post Go to first unread
Last post: 7/23/2021 6:05:42 PM(UTC)
Lansweeper Merging 2 reports
by  Apaulcolypse   Go to last post Go to first unread
Last post: 7/22/2021 10:02:59 PM(UTC)
Lansweeper HELP - Add Registry Key Values to Asset Report
by  Apaulcolypse  
Go to last post Go to first unread
Last post: 7/22/2021 9:26:43 PM(UTC)
Lansweeper Can I request a custom report here?
by  Brian G   Go to last post Go to first unread
Last post: 7/22/2021 7:20:56 PM(UTC)
Lansweeper List all users with E-mail address
by  Brandon  
Go to last post Go to first unread
Last post: 7/21/2021 7:06:36 PM(UTC)
Lansweeper Identifying users of Windows legacy authentication
by  Baronet   Go to last post Go to first unread
Last post: 7/21/2021 5:26:38 PM(UTC)
Lansweeper Windows Version different between reports
by  RC62N  
Go to last post Go to first unread
Last post: 7/21/2021 3:27:04 PM(UTC)