SQL Statement to retrieve Object count information from Automic Database

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL Statement to retrieve Object count information from Automic Database

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

!NOTE: Please test in Test-Environment before running in Production Environment

 

Sql-Statement to retrieve the "numer of objects" (Count) , their type (type) and client (client) they are located in:

 

select  Oh_client as Client,

           Oh_otype as Type,

           Count(*) as Count 

           from OH group by oh_client, Oh_otype;