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"
"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.
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
1 of 1 people found this helpful
it should be under Custom Data by default, this is a built in default.
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.
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.
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.
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