Notification

Icon
Error

A Report to find a single file - Looking to build a report that will find just a single file on the server.

Posted: Tuesday, March 24, 2020 6:37:25 PM(UTC)
jstrong71

jstrong71

Member Original PosterPosts: 9
0
Like
I was wondering if anyone has already built a report that can simply enough find any asset or server that has one specific file in this case ATMFD.DLL Has someone already created a report like that?
CyberCitizen
#1CyberCitizen Member Posts: 359  
posted: 3/26/2020 3:28:57 AM(UTC)
Hi jstrong71,

Depends, should be easy enough to do with custom file scanning if its in an expected path. The only issue is if the file is under the user profile then the path is no longer in the same location on every machine.
Rowe
#2Rowe Member Posts: 1  
posted: 3/26/2020 1:38:28 PM(UTC)
Originally Posted by: jstrong71 Go to Quoted Post
I was wondering if anyone has already built a report that can simply enough find any asset or server that has one specific file in this case ATMFD.DLL Has someone already created a report like that?


This is what I am using

Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.IPAddress,
tblFileVersions.FilePathfull As Path,
tblFileVersions.FileVersion As Version,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Where (tblFileVersions.FilePathfull Like '%ATMFD.DLL%' And
tblAssetCustom.Model = 'MODEL#') Or
(tblFileVersions.FileVersion Like '5.%' And tblAssetCustom.State = 1)

Active Discussions

Lansweeper NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)