SQL query to find bundles with WOL in schedule
This document (7013433) is provided subject to the disclaimer at the end of this document.
Novell ZENworks Configuration Management 11.2
A number of bundles were set with schedule to include wake on lan. How to find those bundles easily?
SQL query for MS SQL:
select zzenobject.name, zassignment.type, zextraassignmentdata.value, zextraassignmentdata.name
join zzenobject on zzenobject.zuid=zassignment.ContentUID
join zextraassignmentdata on zextraassignmentdata.assignment=zassignment.zuid where zextraassignmentdata.name = 'wake.on.lan' and Value like 'true'
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7013433
- Creation Date:09-OCT-13
- Modified Date:09-OCT-13
- NovellZENworks Configuration Management
Did this document solve your problem? Provide Feedback