[OCI DWH] StorageGRID Objects in the NetApp OnCommand Insight DataWarehouse

on

I'm working on updating some Object storage reports, and investigating the NetApp StorageGRID data we have in the NetApp OnCommand Insight DataWarehouse with a view to Object Recharge / Chargeback reporting. So, what do we have?

dwh_inventory.storage

  • Identifying data:
    • model = Webscale
    • manufacturer = NetApp
    • family = StorageGrid
  • Specific data:
    • id
    • name
    • identifier
    • ip
    • microcodeVersion
    • rawCapacityMB
    • manageURL
    • url
    • lastAcquiredTime, active
    • + customer annotations
  • Zero (0) data:
    • spareRawCapacityMB
    • failedRawCapacityMB
    • isVirtual
    • cluster
  • NULL data:
    • serialNumber
    • memoryMB
    • cpuCount


Using the StorageID from the dwh_inventory.storage, and searching for your StorageGRIDs in the following two tables like so:

select * from dwh_inventory.storage_pool where StorageID IN ({comma separated list of StorageIDs})

select * from dwh_inventory.internal_volume where StorageID IN ({comma separated list of StorageIDs})

You see that:

  • dwh_inventory.storage_pool.name = [The Tenant]
  • dwh_inventory.internal_volume.identifier / name = [The Bucket]

Note: dwh_inventory.internal_volume.type = storage grid bucket


Comments

Post a Comment