Notification

Icon
Error

Internet Explorer 9 report

Posted: Tuesday, September 20, 2011 5:16:48 PM(UTC)
DIDE

DIDE

Member Original PosterPosts: 15
0
Like
This issue has been solved! Click here to view the solution
How can I made a report with only the computers that have Internet Explorer 9.
My other reports for versions 6, 7 and 8 works... but not for the version 9.

Query used for ex. version 8:

Select Distinct Top 1000000 dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As Version, Count(dbo.tblSoftware.SoftwareID) As Total, dbo.tblComputers.Computer From dbo.tblSoftware Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Where dbo.tblSoftware.softwareName Like '%windows internet explorer 8%' Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblComputers.Computer Order By Count(dbo.tblSoftware.SoftwareID) Desc, dbo.tblSoftware.softwareName
Lansweeper
#1Lansweeper Member Posts: 13,442  
posted: 9/21/2011 12:41:04 PM(UTC)
which error do you get?
DIDE
#2DIDE Member Original PosterPosts: 15  
posted: 9/21/2011 12:43:47 PM(UTC)
I got no results (no errors also).
The same query with Internet Explorer 6, 7 and 8 gave me results.
With 9 nothing.
Lansweeper
#3Lansweeper Member Posts: 13,442  
posted: 9/22/2011 8:46:56 PM(UTC)
Lansweeper reads software info from the following registry locations:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

(x64 only)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall

More concretely this means that any program that shows up under Programs and Features will be scanned by Lansweeper.

IE9 is being delivered to some operating systems as an "update", not as a "program". It doesn't show up under Programs and Features, which explains why it's not being scanned by default and why your reports have no results.


What you could do is perform a file scan for the executable instead. First make sure that you have added the file for scanning, as shown in the attached image.

If you immediately wish to scan for this executable, perform a "Full Rescan" of the computers you need.


Use the following SQL code to find all computers with IE9 installed:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblFileVersions.FilePathfull As [Attempted To Scan], tblFileVersions.Found, tblFileVersions.FileVersion, tblFileVersions.CompanyName, tblFileVersions.Filesize From tblComputers Inner Join tblFileVersions On tblComputers.Computername = tblFileVersions.Computername Where tblFileVersions.FilePathfull Like '%iexplore.exe' And tblFileVersions.FileVersion Like '9.%'
Lansweeper attached the following image(s):
IE9FileScanning.jpg
DIDE
#4DIDE Member Original PosterPosts: 15  
posted: 9/26/2011 8:46:00 AM(UTC)
Thank you, your query helped!
mhansen
#5mhansen Member Posts: 2  
posted: 1/29/2013 6:43:02 PM(UTC)
I have the same issue, and am trying to use this solution, but when I copy your query text in to the database scripts box it returns - Invalid object name 'tblComputers'.

It seems like any query I copy in to the box returns the same. Any ideas?
Lansweeper
#6Lansweeper Member Posts: 13,442  
posted: 1/29/2013 8:14:41 PM(UTC)
The query posted in this thread is a 4.2 one, not a 5.0 one. Note that database changes were made in Lansweeper 5.0. For 5.0, use the report below instead. Entire procedure:
- Submit the iexplore.exe for scanning in the web console under Configuration/Scanning Setup/Custom Scanning.
- Rescan your assets by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting Rescan on the left.
- Run the report below. Please note that this is a query, not a script, and should be run in the web console under Dashboard/Reports/Report Builder.
Quote:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFileVersions.FilePathfull Like '%iexplore.exe'
Order By tblAssets.AssetUnique,
tblFileVersions.FilePathfull
mhansen
#7mhansen Member Posts: 2  
posted: 1/30/2013 2:41:14 AM(UTC)
That worked very well. Thank you.

Michael

Active Discussions

Lansweeper Linux Agent - login user
by  Dinusha Chandrasinghe   Go to last post Go to first unread
Last post: Today at 11:03:07 AM(UTC)
Lansweeper device with multiple NICs
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 7:42:57 PM(UTC)
Lansweeper Internal Note
by  mdavis2503   Go to last post Go to first unread
Last post: Yesterday at 6:00:07 PM(UTC)
Lansweeper Problem with deploy software
by  Max90  
Go to last post Go to first unread
Last post: Yesterday at 12:09:40 PM(UTC)
Lansweeper Can lsagent be protected from deletion
by  RKCar   Go to last post Go to first unread
Last post: 11/29/2021 8:56:09 PM(UTC)
Lansweeper HTTPS not secure
by  Larry Rhea  
Go to last post Go to first unread
Last post: 11/29/2021 7:50:59 PM(UTC)
Lansweeper Warning about Built-in Admin
by  Larry Rhea   Go to last post Go to first unread
Last post: 11/29/2021 7:45:45 PM(UTC)