Labeling computers with patches listed under "Deployment Scheduled"

My detect and deployment schedules run every day. Computer A and B might both have detected patches they need, but the patches available for deployment are controlled via a collection of labels. So, while both computers detected eligible patches, it might be the case that only computer A will deploy patches during the next daily deployment schedule, while computer B will not. I would like to create a label that applies to Computer A, but NOT computer B in this scenario. This will allow me to run a series of scripts against only the computers with patches to deploy during the next daily deployment schedule.

If I examine the inventory settings for computers A & B, I can easily determine which computer will be patching during the daily deploy schedule by examining the "Deployment Scheduled" list under "Security" > "Patching Detect/Deploy Status" > "Deploy Status". How can I leverage this information for a smart label? 

If not a smart label, what about a SQL select/update statement?

2 Comments   [ + ] Show comments
  • Anyone? - MJNM 7 years ago
  • There isn't anything that is available in the wizard to accomplish what you're trying to do. You'll need to modify/create the SQL. The PATCHLINK tables in the DB are where you will be able to get that info. - erik.ragan 7 years ago
    • I figured that was the case, but I wasn't exactly sure how to create the SQL query after looking at the Patchlink table. I'm not a SQL expert yet... I figured it might be a common enough thing that someone else would know right off the bat. - MJNM 7 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login


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