The report below gives back a list of vCenters with datastores.
The report will only list assets when the following criteria are met:
- You have Lansweeper 7.0 or higher.
- There is vCenter datastore data scanned.
- The assets must be active.
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
