Environment
Novell ZENworks Configuration Management 11.4
Novell ZENworks Patch 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)