SQL to get content types by bundle

  • 7014910
  • 14-Apr-2014
  • 18-Dec-2014

Environment

Novell ZENworks Configuration Management 11.3

Situation

How can one know which bundles are associated to which content types for purposes of satellite replication?


Resolution

select ZUID,Name,SubType,ContentTypeTags from zZENObject o , zACOContentTypeTags act where act.id = o.ZUID order by subtype,ContentTypeTags