→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-01-2015 05:46 PM
Solved! Go to Solution.
‎06-02-2015 01:13 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblDiskdrives.Caption,
Convert(Decimal(8,2),tblDiskdrives.Freespace / 1024 / 1024 / 1024) As FreeGB,
Convert(Decimal(8,2),tblDiskdrives.Size / 1024 / 1024 / 1024) -
Convert(Decimal(8,2),tblDiskdrives.Freespace / 1024 / 1024 / 1024) As UsedGB,
Convert(Decimal(8,2),tblDiskdrives.Size / 1024 / 1024 / 1024) As SizeGB,
Cast(Ceiling(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
Else tblDiskdrives.Size End) * 100) As nvarchar) + '%' As FreePCT
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3 And
tblDiskdrives.Size <> 0 And tblComputersystem.Domainrole > 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption
‎06-02-2015 01:13 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblDiskdrives.Caption,
Convert(Decimal(8,2),tblDiskdrives.Freespace / 1024 / 1024 / 1024) As FreeGB,
Convert(Decimal(8,2),tblDiskdrives.Size / 1024 / 1024 / 1024) -
Convert(Decimal(8,2),tblDiskdrives.Freespace / 1024 / 1024 / 1024) As UsedGB,
Convert(Decimal(8,2),tblDiskdrives.Size / 1024 / 1024 / 1024) As SizeGB,
Cast(Ceiling(tblDiskdrives.Freespace / (Case tblDiskdrives.Size When 0 Then 1
Else tblDiskdrives.Size End) * 100) As nvarchar) + '%' As FreePCT
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3 And
tblDiskdrives.Size <> 0 And tblComputersystem.Domainrole > 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now