Scan for file in Application directory

[cody_bbh]

I have a product that requires a new configuration file to be pushed out to it. Unfortunately, members of the help desk haven't kept up the computer name list and we need to scan to build a fresh list. I need to be able to see if a file exist in something like this structure. \\ComputerName\C$\Program Files (x86)\ApplicationRoot\ApplicationSubDir\ *.config file.

[CyberCitizen]

Custom file scanning will work for this. Will give you a report of machines that have the necessary files etc. You can then create a report which can be used for deployment if the file your scanning is an older version etc.

Scanning > Data Selection > File & Registry Scanning

We had an issue with our Laptop WiFi dropping connections on site. Turns out it was the Intel WiFi Driver that needed to be updated.

So we scanned for the driver, and used the following report to upgrade machines.

You will need to change the filename, version and maybe remove the model of device. For our instance we needed to limit it to a certain laptop model.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblAssetCustom.Model,
  tblAssets.Version,
  tblAssets.IPAddress,
  Case SubQuery1.Found
    When 1 Then 'Yes'
    Else 'No'
  End As FileFound,
  SubQuery1.FileVersion As [Driver Version],
  SubQuery1.Filesize,
  SubQuery1.PathSearched,
  SubQuery1.LastAccessed,
  TsysLastscan.Lasttime As LastFileScan,
  tblAssets.Lastseen,
  Case
    When SubQuery1.FileVersion Like '20.70.13.2' Then '#d4f4be'
    Else '#ffadad'
  End As backgroundcolor,
  Case
    When TsysLastscan.Lasttime < GetDate() - 1 Then
      'Last file scan more than 24 hours ago! Scanned info may not be up-to-date.'
  End As Comment
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblFileVersions.AssetID,
        tblFileVersions.FilePathfull As PathSearched,
        tblFileVersions.Found,
        tblFileVersions.FileVersion,
        tblFileVersions.CompanyName,
        tblFileVersions.Filesize,
        tblFileVersions.Lastchanged,
        tblFileVersions.CreationDate,
        tblFileVersions.LastAccessed,
        tblFileVersions.LastModified
      From tblFileVersions
      Where tblFileVersions.FilePathfull Like '%NETwtw06.sys%') SubQuery1 On
    SubQuery1.AssetID = tblAssets.AssetID
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblAssetCustom.Model Like '%PORTEGE X20%' And tblAssetCustom.State = 1 And
  TsysWaittime.CFGname = 'files'
Order By FileFound Desc,
  [Driver Version],
  tblAssets.AssetName