How to Run a Report showing only Windows devices with certain MS Updates?
We have an EMR that requires windows and MS IE. But it requires old versions and it seems that certain Updates from MS cause issues at the workstations. I am trying to run a report showing only devices with certain MS KB's on them. Is this possible with the K1000 Appliance? Do I need to set up a software inventory rule first? There is no way I can manually go through every device's updates to check for this.......
Thank you for Any Help!
EDIT: I should clarify that we do not utilize the K1000 to deploy patches to a majority of machines. Although we have updates turned off with GP, users do have the ability to download them manually.
Thank you for Any Help!
EDIT: I should clarify that we do not utilize the K1000 to deploy patches to a majority of machines. Although we have updates turned off with GP, users do have the ability to download them manually.
1 Comment
[ + ] Show comment
-
Thanks Chucksteel, but I cannot seem to get the wizard to create a report that finds the KBs. I am looking for KB3104002 and KB3124275. If anyone is able to assist with a custom SQL report, I would really appreciate it. - bstutz 8 years ago
Answers (3)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
8 years ago
This query seems to work:
SELECT MACHINE.NAME AS SYSTEM_NAME,
USER_LOGGED, GROUP_CONCAT(SOFTWARE.DISPLAY_NAME) AS INSTALLEDSOFTWARE
FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID)
LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID)
GROUP BY MACHINE.ID
HAVING INSTALLEDSOFTWARE like '%KB3124275%' and INSTALLEDSOFTWARE like '%KB3104002%'
ORDER BY SYSTEM_NAME
It's not as clean of a report as I would like but it should get the job done.
Posted by:
chucksteel
8 years ago
Here is what I used for the wizard:
Title: Computers with KB3104002 Installed
Category: Patching
Topic: Device
Sub Topic: Software
Only show rows from Device with at least one Software row. Checked
Fields to Display:
Device, Device Identity Information, System Name
Software: Software Info, Display Name
Filters:
Software: Display Name contains KB3104002
If I try searching for machines with both KBs installed I don't get any results, though. I'll try playing with it more if I have time later today.
Comments:
-
Thanks a ton. I was looking under the incorrect category. I was using device category and looking at the topic of software and patching. - bstutz 8 years ago
Posted by:
chucksteel
8 years ago
Top Answer
Yes, this is possible. Even if you aren't patching with the K1000 patches should show up as installed in the inventory. For a first attempt I would recommend using the reporting wizard to see if that will build this report for you. If it doesn't then you can post the KB numbers that you are looking for and someone might be able to create a custom SQL report that will find computers with them installed.
