/build/static/layout/Breadcrumb_cap_w.png

Devices not in a Patch deployement Schedule

So when you are looking at a device under patching detect/deploy status. If it is part of a deployment schedule it will say "Patches will be Deployed from these Patch Schedules". If it is not part of a patching schedule it will say "Patch Deployement is not enabled for this device". Where I can find that in the database so that I can run a report against all devices to quickly find out which devices are not part of a deployment schedule?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: IgorAngelini 2 years ago
Second Degree Blue Belt
1

Who knew that those set theory classes in collage would come in handy? Try (PS. You can use this as a smart label if you want):

SELECT DISTINCT MACHINE.ID AS TOPIC_ID,
       MACHINE.NAME AS SYSTEM_NAME
       
FROM (
  MACHINE
  LEFT OUTER JOIN PATCH_SCHEDULE_MACHINE_PATCH_JT MPJ
  ON MPJ.MACHINE_ID = MACHINE.ID
)

WHERE MPJ.MACHINE_ID IS NULL

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