Computers without IE 11
I'm trying to create a report that will give me a list of all our Windows 7 computers which do not have IE 11 installed.
I have tried using the method given here:http://www.itninja.com/question/create-report-listing-computers-without-a-specific-software-title. I replaced %Software Title% with %xplorer 11%. I also had to add "or (M.OS_NAME not like '%7%')" to filter out Windows 8 computers which get included even though they very do have IE 11 installed.
When running this in MySQL workbench, it takes less than a second to return 214 results. When running this from the KACE reports, it hangs for a long time and never produces a report (waited at least 1 hour). Is there something else that needs to be added to get this to run from the Kace web console?
I have tried using the method given here:http://www.itninja.com/question/create-report-listing-computers-without-a-specific-software-title. I replaced %Software Title% with %xplorer 11%. I also had to add "or (M.OS_NAME not like '%7%')" to filter out Windows 8 computers which get included even though they very do have IE 11 installed.
When running this in MySQL workbench, it takes less than a second to return 214 results. When running this from the KACE reports, it hangs for a long time and never produces a report (waited at least 1 hour). Is there something else that needs to be added to get this to run from the Kace web console?
1 Comment
[ - ] Hide Comment
Answer this question
or Comment on this question for clarity
Answers
IE does not show like normal software
Create a CIR and then run reports on that value
http://www.itninja.com/blog/view/create-custom-inventory-rules-that-inventory-internet-explorer
Create a CIR and then run reports on that value
http://www.itninja.com/blog/view/create-custom-inventory-rules-that-inventory-internet-explorer
Please log in to comment
-
I would like to give this a try. I do see a software entry in my system with a custom inventory rule for IE that was created by a former employee.
The magic step that is missing for me is that when creating a report, how do you get the "Custom fields" category to appear?
You need the id of the CIR. you can get using sql workbench and reading the table that stores the CIR info. Sorry just switched my Tech station to W10 and I do not have toad installed yet so cannot give a screen shot of the table.
but if you hover your mouse over the CIR you will get the id of the entry

or create a simple wizard report with that cir and then edit that report in sql

but if you hover your mouse over the CIR you will get the id of the entry

or create a simple wizard report with that cir and then edit that report in sql

Please log in to comment
-
I understand all that and actually found an easier way to get the information I wanted (which was simply, does the PC have IE 11 or not). What I was asking about in my previous comment was the image in the above linked article. The second to last image shows the available checkboxes which can be selected for the report, including "Display svcversion of Internet Explorer Installed". I have a custom inventory rule as described earlier in the article. I do not have the checkbox shown available when creating a report. I do not have the "Custom Fields" category at all.
Comments