SQL to get content types by bundle

  • Document ID:7014910
  • Creation Date:14-Apr-2014
  • Modified Date:18-Dec-2014
    • Micro Focus Products:
      ZENworks Configuration Management

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