/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


K1000 Report of All Patches Missing by Machine

03/21/2013 5693 views

Trying to make a tidy report that will show all patches missing grouped by machine name. Does anyone have some good SQL they want to donate that has been working out well for them?

Answer Summary:
0 Comments   [ + ] Show comments

Comments


All Answers

2

For each Machine, what patches are NOT installed

 

**SQL Statement**

Select CASE WHEN MACHINE.SYSTEM_DESCRIPTION = '' THEN MACHINE.NAME  WHEN MACHINE.SYSTEM_DESCRIPTION != '' THEN CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) END AS MACHINE_NAME,

P.TITLE AS DISPLAY_NAME, P.IDENTIFIER as KB_ARTICLE from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P

where 

MACHINE.ID = S.MACHINE_ID and

S.PATCHUID = P.UID and

S.STATUS != 'PATCHED'

order by MACHINE_NAME, P.TITLE

Answered 03/21/2013 by: nshah
Red Belt

  • Works nicely in MySQL Workbench. Thank you!
  • This report is works for me, but what I really want is a count for the number of patches missing for each PC. Adding a count statement in workbench gives me an execute command denied error. I'm not sure if this is because the data comes from multiple tables and access is actually denied or I'm just doing it wrong.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ