The report below gives back a list of vCenters with datastore clusters.
The report will only list assets when the following criteria are met:
- You have Lansweeper 7.0 or higher.
- There is vCenter datastore cluster data scanned.
- The assets must be active.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblVmwareDatastoreClusters.Name,
tblVmwareDatacenters.DatacenterID,
tblVmwareDatacenters.Name As Datacenter,
(tblVmwareDatastoreClusters.FreeSpace) / 1024 / 1024 / 1024 As SpaceGB,
(tblVmwareDatastoreClusters.Capacity) / 1024 / 1024 / 1024 As CapactityGB,
tblVmwareDatastoreClusters.DrsEnabled,
tblVmwareDatastoreClusters.IoLoadBalanceEnabled,
tblVmwareDatastoreClusters.DefaultIntraVmAffinity,
tblVmwareDatastoreClusters.DefaultVmBehaviour,
tblVmwareDatastoreClusters.LoadBalanceInterval,
tblVmwareDatastoreClusters.SpaceUtilizationThreshold,
tblVmwareDatastoreClusters.MinSpaceUtilizationDifference,
tblVmwareDatastoreClusters.IoLatencyThreshold,
tblVmwareDatastoreClusters.IoLoadImbalanceThreshold,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblVmwareVcenters On tblAssets.AssetID = tblVmwareVcenters.AssetID
Inner Join tblVmwareDatacenters On tblVmwareVcenters.VcenterID =
tblVmwareDatacenters.VcenterID
Inner Join tblVmwareDatastoreClusters On tblVmwareDatacenters.DatacenterID =
tblVmwareDatastoreClusters.DatacenterID
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName,
tblVmwareDatastoreClusters.Name
