SQL query to find bundles and policies having sandbox version

  • Document ID:7024017
  • Creation Date:18-Jul-2019
  • Modified Date:18-Jul-2019
    • Micro Focus Products:
      ZENworks Configuration Management

Environment

ZENworks Configuration Management 2017 Update 4

Situation

SQL query to identify bundles and policies having sandbox version.

Resolution

select * from zzenobject where zuid in (select zuid from zAssignableContentObject where version=-1);