How to create a report based on scanned file information.
In this example we will detect the Firefox version on all computers based on a file scan.
Filename: %programfiles%\Mozilla Firefox\firefox.exe
We first need to enter the needed filename into the configuration tool and enable it:
In the waittime section make sure that FILE is set.
In this screenshot FILES is set to "1" which means every day.
In the web interface we can see the result from our scan.
Now we are going to create a report to list all computers that have firefox installed with the version number.
SQL code:
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblFileVersions.FilePathfull, tblFileVersions.Found,
tblFileVersions.FileVersion, tblFileVersions.CompanyName,
tblFileVersions.Filesize
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Where tblFileVersions.FilePathfull Like '%firefox.exe'
This is a simple sample report, you can add other fields if needed
Most requested articles:
|
