sql query to get all patches assigned to baselines

  • Document ID:7018223
  • Creation Date:01-Nov-2016
  • Modified Date:01-Nov-2016
    • Micro Focus Products:
      ZENworks Configuration Management
      ZENworks Patch Management

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)