Systems Management Question

Add patch label to multiple schedules

07/12/2017 536 views
I can't seem to find a way to do this. I have created a patch label to patch a certain application on our workstations. We have about 40 schedules that patch different departments (sorted via label on computer name) around the organisation. Is there a way to add this new patch label to all the schedules without opening each schedule and adding it top the detect and deploy settings? 

2 Comments   [ + ] Show comments


  • Thanks Chuck, I'll check it out. We don't use the service desk component at the moment so should be a learning curve!
    • Here are some tips to help.

      Service desk rules can actually write to any part of the database, so they can be very powerful (which of course means they can also be damaging if you aren't careful). Rules have two main parts, a select statement and an update statement. The select statement needs to return at a minimum a column named ID. The results of this column will be placed into a variable <TICKET_IDS> for use in the update statement.

      So, in a case like this one, you could have a select statement that returns the ID for the patch schedules that need to be updated. The update query would then be an insert into the PATCHLINK_SCHEDULE_DEPLOY_LABEL_JT and the PATCHLINK_SCHEDULE_DETECT_LABEL_JT tables.

      If you don't already have a tool like MySQL Workbench setup I highly recommend doing so. It is very useful for looking at the tables to figure out where things are in the database.
  • Thanks, appreciate your help.

All Answers

You could technically use a service desk rule to add the appropriate rows to the patch schedule label join table. I don't have access to the database right now but it should definitely be possible.
Answered 07/13/2017 by: chucksteel
Red Belt

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