‎11-27-2018 11:05 AM
‎11-27-2018 06:04 PM
Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
Sum(Cast(Cast(tblDiskdrives.Size As BigInt) / 1024 / 1024 / 1024 As Numeric)) As [Total size (GB)],
Sum(Cast(Cast(tblDiskdrives.Freespace As BigInt) / 1024 / 1024 / 1024 As Numeric)) As [Free in GB],
tblAssetCustom.Model,
tblADComputers.OU
From
tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers ON tblAssets.AssetID = tblADComputers.AssetID
Group By
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tblAssetCustom.Model,
tblADComputers.OU
Order By
tblAssets.AssetID
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now