sql query to get all patches assigned to baselines

  • 7018223
  • 01-Nov-2016
  • 01-Nov-2016

Environment

Novell ZENworks Configuration Management 11.4
Novell ZENworks Patch Management 11.4

Situation

What is an sql query to get all patches assigned to baselines?

Resolution

select distinct bps.signature_id, ps.distpackstatus, ps.name from BaselineGroupPatchSignature bps, patchsignature ps where bps.signature_id=ps.signature_id and bps.groupuid in (select distinct baseline_id from baselinegroup)