cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
runiuksp
Engaged Sweeper
Hello,

I need a really simple report:

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

Could you help please?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
runiuksp
Engaged Sweeper
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
Lansweeper Alumni
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
Lansweeper Alumni
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