How to create a report based on scanned registry keys.
In this example we will detect the Firefox version on all computers based on a registry scan.
Registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Mozilla\Mozilla Firefox
Registry value: CurrentVersion
We first need to enter the needed key into the configuration tool and enable it:
In the waittime section make sure that REGISTRY is set.
In this screenshot REGISTRY 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,
tblRegistry.Valuename, tblRegistry.Value
From tblComputers Inner Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where tblRegistry.Valuename = 'Currentversion'
This is a sample report, you can add other fields if needed
Most requested articles:
|
