7 Replies Latest reply on May 30, 2013 5:06 PM by joaopaulonj

    Query for Internet Explorer 9

    Apprentice

      Hello,

       

      Not sure if I am missing something but when I create a query for Internet Explorer 9 I can't find an entry.  Also when I create one for IE8 I only get XP computers with IR installed.  I suspect this is because for 8, it's a core part of the Win 7 OS?

       

      Any advice is appreciated.

       

      Jonathan

        • 1. Re: Query for Internet Explorer 9
          Catalysttgj Expert

          What is your query exactly?

           

          One thing i notice is if you try a query for:

           

          "Computer"."Software"."Add or Remove Programs"."Program"."Name" LIKE "Internet Explorer"

          and having this same column in the output column set

           

          in an environment with 13600 devices it yields a ridiculous list. Over 234,000 rows. Obviously this is because of the many patches, and other things that can contain the phrase "Internet Explorer" in the name of the product, so not sure if this is causing an issue for you.

           

          An alternative that you might consider is querying for the actual executable file and a version. Something like:

           

          "Computer"."Software"."Package"."Name" = "IEXPLORE.EXE"

          AND

          "Computer"."Software"."Package"."Version" Like "9."

          Note: I'm not sure what the exact version is that you need to look for, but this information should be out there on a machine that you know has 9. Just navigate to the file and do properties on it, and use that number. The "LIKE" operator with "9." will probably get something though i would hope.

           

          Of course you could include the same columns in the output column set, but consider "qualifying" these fields to the exact file that you want, because this file might exist in multple locations on a machine. You'll probably want to even dial in the query itself on the specific file path instead of just using "Name", so that you're getting the true used file, and not some backup or whatever that might exist on a machine.

          • 2. Re: Query for Internet Explorer 9
            Apprentice

            We use the following in the ldappl3.template to pull the IE version into Custom Data. This gives the exact version.

             

            KEY=HKLM,Software\Microsoft\Internet Explorer,Version,Custom Data - Internet Explorer - Version

            • 3. Re: Query for Internet Explorer 9
              mrspike SSMMVPGroup

              it should be under Custom Data by default, this is a built in default.

              1 of 1 people found this helpful
              • 4. Re: Query for Internet Explorer 9
                Specialist

                Yes, this is why we use the simple Query:

                "Computer",Custom Data","Internet Explorer","Version" EXISTS

                Gives you all Versions of Internet Explorer and then you can "sort" to Version.

                 

                Best Regards

                Troga

                • 5. Re: Query for Internet Explorer 9
                  Apprentice

                  Thanks everyone, all of your responses were helpful and I got exactly what I needed.  I also added primary owner to my query to identify the owner of the workstations.

                  • 6. Re: Query for Internet Explorer 9
                    Rookie

                    Using this only returns about 12 remarks, where as we have almost 300 users.

                     

                    My Logic reflects this: "Computer","CustomData","Internet Explorer","Version" EXISTS

                     

                    and my column sort shows the same path. 

                     

                    For columns I have Device Name, Type, OS Name, and Version. 

                    • 7. Re: Query for Internet Explorer 9
                      Rookie

                      Query versions of IE solved!

                        develop a query with versions of IE in custom data.

                       

                      Query versions of IE solved!

                       

                       

                        develop a query with versions of IE in custom data. after almost getting crazy.

                       

                       

                      initially thought it might be a problem on the basis of the inventory, but when done in the laboratory was the same problem, it was important for me to dismiss the problem on the basis of the inventory.

                      first do the procedure of adding to the inventory the registry key with the version of IE. the construction of the query will be so as follows: believe it

                      "Computer". "Custom Date". "Internet Explorer". "Version" NOT EXISTS

                       

                      query.jpg

                      Result.jpg