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?
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.
