→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-16-2015 11:57 AM
Solved! Go to Solution.
‎09-17-2015 12:06 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblDiskdrives.Caption As [Disk drive],
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As
[Size (GB)],
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 As
numeric) As [Free space (GB)],
Cast(Cast(tblDiskdrives.Size - tblDiskdrives.Freespace As bigint) / 1024 /
1024 / 1024 As numeric) As [Used Space (GB)],
Cast(Cast(tblDiskdrives.Freespace As float) / tblDiskdrives.Size *
100 As Decimal(10,2)) As PercentageUsed
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblDiskdrives.Size > 0 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
[Disk drive]
‎09-17-2015 12:06 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblDiskdrives.Caption As [Disk drive],
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As
[Size (GB)],
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 As
numeric) As [Free space (GB)],
Cast(Cast(tblDiskdrives.Size - tblDiskdrives.Freespace As bigint) / 1024 /
1024 / 1024 As numeric) As [Used Space (GB)],
Cast(Cast(tblDiskdrives.Freespace As float) / tblDiskdrives.Size *
100 As Decimal(10,2)) As PercentageUsed
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblDiskdrives.Size > 0 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
[Disk drive]
‎09-16-2015 04:17 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now