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: 134  
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 Install Adobe Reader Error
by  Hilbers   Go to last post Go to first unread
Last post: Today at 3:08:30 PM(UTC)
Lansweeper End of Life Asset Report
by  Hendrik.VE  
Go to last post Go to first unread
Last post: Today at 2:18:23 PM(UTC)
Lansweeper Translation settings not saved
by  Brandon   Go to last post Go to first unread
Last post: Yesterday at 2:10:22 PM(UTC)
Lansweeper Combobox translation
by  sneagele  
Go to last post Go to first unread
Last post: Yesterday at 2:03:45 PM(UTC)
Lansweeper Freelance for Lansweeper Deploy?
by  Brandon   Go to last post Go to first unread
Last post: 5/7/2021 6:32:21 PM(UTC)
Lansweeper Installation issues
by  Richie_Rich  
Go to last post Go to first unread
Last post: 5/6/2021 11:29:09 PM(UTC)
Lansweeper Cloud relay data stored time
by  Richie_Rich   Go to last post Go to first unread
Last post: 5/6/2021 11:14:42 PM(UTC)
Lansweeper Custom attributes from AD
by  dhoward  
Go to last post Go to first unread
Last post: 5/6/2021 11:10:45 PM(UTC)