03-05-2019 11:53 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblVmwareDisk.Name,
tblVmwareDisk.Url,
tblVmwareDatacenters.DatacenterID,
tblVmwareDatacenters.Name As Datacenter,
tblVmwareDatastoreClusters.Name As DatastoreCluster,
tblVmwareDisk.TotalSpace As Space,
tblVmwareDisk.FreeSpace As Free,
tblVmwareDatastores.Type,
tblVmwareDatastores.Uncommitted,
tblVmwareDatastores.Accessible,
tblVmwareDatastores.MultipleHostAccess,
tblVmwareDatastores.MaintenanceMode,
tblVmwareDatastores.MaxPhysicalRdmFileSize,
tblVmwareDatastores.MaxVirtualRdmFileSize,
tblVmwareDatastores.MaxFileSize,
tblVmwareDatastores.MaxVirtualDiskCapacity,
tblVmwareDatastores.MaxMemoryFileSize,
tblVmwareDatastores.Timestamp,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblVmwareDatastores.InternalKey
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 tblVmwareInfo On tblVmwareInfo.AssetID = tblAssets.AssetID
Inner Join tblVmwareDatastores On tblVmwareDatastores.HostID =
tblVmwareInfo.VmwareID
Inner Join tblVmwareDatacenters On tblVmwareDatacenters.DatacenterID =
tblVmwareDatastores.DatacenterID
Left Outer Join tblVmwareDatastoreClusters On
tblVmwareDatastoreClusters.DatastoreClusterID =
tblVmwareDatastores.DatastoreClusterID
Left Outer Join tblVmwareDisk On tblVmwareDatastores.DatastoreID =
tblVmwareDisk.DatastoreID
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName,
tblVmwareDisk.Name