Daniel_Hausdorf_6982

SQL Statement to retrieve Object count information from Automic Database

Discussion created by Daniel_Hausdorf_6982 on Oct 4, 2016
Latest reply on Oct 7, 2016 by Daniel_Hausdorf_6982
*** NOTE: Please test this in your TEST / DEV System before running it on your PROD System ***

This SQL Statement will retrieve the following information : 
- Number of Objects (Count)
- Their Type (type)
- which Client (client)

NOTE: This statement counts initial data and deleted objects.

select  Oh_client as Client,
        Oh_otype as Type,
        Count(*) as Count
from OH group by oh_client, Oh_otype;

Outcomes