[MySQL] Simple NetApp OCI DWH Scale Query

 If you want to provide details on the scale of your NetApp OnCommand Insight infrastructure. This query run against the Data Warehouse MySQL DB, provides anwers:

USE `dwh_inventory`;

SELECT 'Storage'            AS 'Table', COUNT(*) FROM `storage`            UNION

SELECT 'host'               AS 'Table', COUNT(*) FROM `host`               UNION

SELECT 'hv_virtual_machine' AS 'Table', COUNT(*) FROM `hv_virtual_machine` UNION

SELECT 'hv_data_store'      AS 'Table', COUNT(*) FROM `hv_data_store`      UNION

SELECT 'volume'             AS 'Table', COUNT(*) FROM `volume`             UNION

SELECT 'volume_map'         AS 'Table', COUNT(*) FROM `volume_map`         UNION

SELECT 'volume_mask'        AS 'Table', COUNT(*) FROM `volume_mask`        UNION

SELECT 'switch'             AS 'Table', COUNT(*) FROM `switch`             UNION

SELECT 'internal_volume'    AS 'Table', COUNT(*) FROM `internal_volume`    UNION

SELECT 'qtree'              AS 'Table', COUNT(*) FROM `qtree`              UNION

SELECT 'acq_data_source'    AS 'Table', COUNT(*) FROM `acq_data_source`;