Is there a field anywhere for overall Cluster Datastore Capacity?

I'm trying to use linear bar charts in a widget to display overall capacity/used/free but cannot find the right object to query for it.  I can find the DataStoreUsedSpace in Orion.vim.clusters but no corresponding datastore size. Weirdly it has that for CPU and MEM but nothing for datastore cap.

Any ideas?

Parents
  • You can use the navigational property to get to the current data store statistics.

    SELECT [vClusters].ClusterID
          , [vClusters].CortexID
          , [vClusters].ManagedObjectID
          , [vClusters].DataCenterID
          , [vClusters].Name
          , [vClusters].TotalMemory
          , [vClusters].TotalCpu
          , [vClusters].CpuCoreCount
          , [vClusters].CpuThreadCount
          , [vClusters].EffectiveCpu
          , [vClusters].EffectiveMemory
          , [vClusters].DrsBehaviour
          , [vClusters].DrsStatus
          , [vClusters].DrsVmotionRate
          , [vClusters].HaAdmissionControlStatus
          , [vClusters].HaStatus
          , [vClusters].HaFailoverLevel
          , [vClusters].ConfigStatus
          , [vClusters].OverallStatus
          , [vClusters].CPULoad
          , [vClusters].CPUUsageMHz
          , [vClusters].MemoryUsage
          , [vClusters].MemoryUsageMB
          , [vClusters].TriggeredAlarmDescription
          , [vClusters].OrionIdPrefix
          , [vClusters].OrionIdColumn
          , [vClusters].PlatformID
          , [vClusters].VmCapacityCount
          , [vClusters].VmCapacityConstraint
          , [vClusters].DiskUtilizationDepletionDate
          , [vClusters].DatastoreUsedSpace
          , [vClusters].CpuUtilizationDepletionDate
          , [vClusters].MemoryUtilizationDepletionDate
          , [vClusters].DateCreated
          , [vClusters].DetailsUrl
          , [vClusters].PollingSource
          , [vClusters].VsanEnabled
          , [vClusters].VsanUuid
          , [vClusters].HostStatus
          , [vClusters].DataStores.Capacity
    --                     ^          ^
    --                     |          |
    --                     +- Navigation Property Name (Orion.VIM.Datastores)
    --                                |     
    --                                +- Property Name within Orion.VIM.Datastores
          , [vClusters].DataStores.FreeSpace
          , [vClusters].DataStores.SpaceUtilization
    FROM Orion.VIM.Clusters AS [vClusters]
    

    P.S. - you probably don't need all those fields, but I just went from the default and added.

  • That did the trick! (and is also the final impetus needed to always use [aliases])

  • After I discovered what could be done with aliases, I never went back.

Reply Children
No Data