→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎11-27-2014 05:33 AM
Solved! Go to Solution.
‎12-02-2014 05:21 PM
‎12-02-2014 05:21 PM
‎12-02-2014 04:44 AM
‎12-01-2014 02:02 PM
‎12-01-2014 07:56 AM
‎11-27-2014 09:59 AM
Select Top 1000000 tblVmwareDisk.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblVmwareDisk.Name As PartitionName,
Ceiling(tblVmwareDisk.TotalSpace / 1024 / 1024) As SizeMB,
Ceiling(tblVmwareDisk.FreeSpace / 1024 / 1024) As FreeMB,
tblVmwareDisk.Url,
Ceiling(tblVmwareDisk.FreeSpace / (Case tblVmwareDisk.TotalSpace When 0 Then 1
Else tblVmwareDisk.TotalSpace End) * 100) As FreePCT
From tblVmwareDisk
Inner Join tblAssets On tblVmwareDisk.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where Ceiling(tblVmwareDisk.FreeSpace / (Case tblVmwareDisk.TotalSpace
When 0 Then 1 Else tblVmwareDisk.TotalSpace
End) * 100) < 20 And tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now