SQL Statement to retrieve Object count information from Automic Database

Document ID : KB000089042
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
SQL Statement to retrieve Object count information from Automic Database
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;