SQL query to find all bundles that have settings that are not inherited from the zone

  • 7006250
  • 02-May-2012
  • 28-Aug-2012

Environment

Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2

Situation

In a zone has a large number of bundles in it, locating bundles that do not inherit their settings from the zone is a very manual and slow process. What database query will return all bundles that have settings that are not inherited from the zone?

Resolution

The following query should return all bundles that do not inherit the zone settings:
select distinct zzenobject.path from zzenobject,zsystemsetting,zAssignableContentObject
where zSystemSetting.ObjectUID=zZENObject.ZUID and not
(zSystemSetting.Name ='bundle.sandbox.chained.bundles.settings')
and zAssignableContentObject.ZUID=zZENObject.ZUID
and zAssignableContentObject.ReleaseUID is null

Feedback service temporarily unavailable. For content questions or problems, please contact Support.