→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cody_bbh
Engaged Sweeper
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.
1 REPLY 1
CyberCitizen
Honored Sweeper
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