SQL query to find bundles with WOL in schedule

  • 7013433
  • 09-Oct-2013
  • 09-Oct-2013

Environment

Novell ZENworks Configuration Management 11.2

Situation

A number of bundles were set with schedule to include wake on lan.  How to find those bundles easily?

Resolution

SQL query for MS SQL:

select zzenobject.name, zassignment.type, zextraassignmentdata.value, zextraassignmentdata.name
from zassignment 
join zzenobject on zzenobject.zuid=zassignment.ContentUID
join zextraassignmentdata on zextraassignmentdata.assignment=zassignment.zuid where zextraassignmentdata.name = 'wake.on.lan' and Value like 'true'