sql query for bundles having immediate schedule

  • Document ID:7018843
  • Creation Date:27-Apr-2017
  • Modified Date:27-Apr-2017
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 2017

Situation

sql query for bundles having immediate schedule

Resolution

select distinct zzenobject.path, zassignment.type, zextraassignmentdata.value, zextraassignmentdata.name
from zassignment 
join zzenobject on zzenobject.zuid=zassignment.ContentUID
join zextraassignmentdata on zextraassignmentdata.assignment=zassignment.zuid where value like '%ImmediateSchedule%'