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.
Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • 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.
Please log in to comment

Answer Chosen by the Author

0
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.
Answered 01/19/2016 by: chucksteel
Red Belt

Please log in to comment

Answers

0
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.



Answered 01/27/2016 by: chucksteel
Red Belt

  • Thanks a ton. I was looking under the incorrect category. I was using device category and looking at the topic of software and patching.
Please log in to comment
0
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.
Answered 01/27/2016 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity