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'