Searching for PCs with IE7 Installed

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