Help with IE8 report

[runiuksp]

Hello,

I need a really simple report:

Computer Name
IP location
OsName - Windows 7
IE browser - version 8

Could you help please?

[runiuksp]

That's great!

Many thanks


Would you be able to do kind of similar one that will show all computers with google chrome not installed?


Thanks

[Hemoco]

runiuksp wrote:
That's great!

Many thanks


Would you be able to do kind of similar one that will show all computers with google chrome not installed?


Thanks

A sample report can be found here.

[Hemoco · Accepted solution]

The report below lists the IE8 installations on your Windows 7 computers. We assume this is what you're after. To use the report below, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tsysOS.OSname,
tblSoftwareUni.softwareName,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tsysOS.OSname = 'win 7' And tblSoftwareUni.softwareName Like
'windows internet explorer 8%' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName