Environment
Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2
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
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