Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Searching for PCs with IE7 Installed

Created: 29 Nov 2006 • Updated: 07 Jul 2009 • 7 comments
kyle_campbell's picture
0 0 Votes
Login to vote

Inventory Solution comes with a report that searches for Web Browsers that are installed on Clients. If you run the report, however, it doesn't show PCs with the newly released IE7. The reason is Microsoft got tricky and changed the naming a little bit.

What you need to do is make a clone of the query "Count of Computers by Browser, Version (Including IE7) and OS" located under: Reports Tab -> Assets and Inventory -> Inventory -> Windows -> Software/Applications -> Web Browsers. Then modify the level 0 query by locating the lines in the WHERE clause that searches for the browsers. The last line will look like this:

(UPPER(csw.ProductName) = ''INTERNET EXPLORER*''))

The modification you need to make to the query is to add an additional line after the "INTERNET EXPLORER*" search so that the last two lines look like the following:

OR (UPPER(csw.ProductName) = ''INTERNET EXPLORER*'')    
OR (UPPER(csw.ProductName) = ''WINDOWS® INTERNET EXPLORER''))

Basically what Microsoft did was change the naming from INTERNET EXPLORER* to ''WINDOWS® INTERNET EXPLORER so if you run the report as is you only get results for Internet Explorer 6 and any previous versions, not any Internet Explorer 7 results. Making this modification will get you up and running and reporting accurately.

Kyle

Comments 7 CommentsJump to latest comment

jgo's picture

You can also make the change within Auditpls.ini !!!

John Golembiewski
Midwest Practice Principal
ITS Partners
Jgo@itsdelivers

0
Login to vote
endo's picture

Where in auditpls.ini do you make the change? And what is the change?

0
Login to vote
Brandon's picture

Open

\\server\NSCap\Bin\Win32\X86\AeXAPedit.exe

then navigate to

\\server\NSCap\Bin\Win32\X86\Inventory Solution\auditpls.ini

under the known as tab add the entry

Internal name:
Windows® Internet Explorer.*

Known as:
Internet Explorer

I haven't tried it yet so someone can correct me if I am wrong.

0
Login to vote
jjesse's picture

Maybe I'm doing something wrong as I'm not the greatest SQL guru out there but on my test system I get error in Line 27 after making that change.

Jonathan Jesse Practice Principal ITS Partners

0
Login to vote
jgo's picture

You should definitely look at line 27.
Perhaps you could pull the code from the report and run the query in SQL query Analyzer? Maybe it would give you a better error? I just tried it and it worked on mines!

John Golembiewski
Midwest Practice Principal
ITS Partners
Jgo@itsdelivers

0
Login to vote
kwebb004's picture

This works as long as you copy word for word the script in the article. At first I got a line 27 error and went back and checked the query and noticed I had left off the first part of the line.

This helps out a great deal in keeping track of IE 7 out on the floor for me.

Thanks Kyle!

0
Login to vote
chasman's picture

Wow - thank you so much.

Your tech tip saved me a lot of time.

crystal

0
Login to vote