A Report to find a single file

[jstrong71]

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?

[chrisrowe]

jstrong71 wrote:
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)

[CyberCitizen]

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.