SQL query to find bundles with WOL in schedule

  • Document ID:7013433
  • Creation Date:09-Oct-2013
  • Modified Date:09-Oct-2013
    • Micro Focus Products:
      ZENworks Configuration Management

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'