‎10-23-2015 04:47 PM
Solved! Go to Solution.
‎10-27-2015 04:31 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
Case When tblComputersystem.Domainrole > 1 Then 'Server' Else 'Workstation'
End As [Server/Workstation],
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblDiskdrives.Caption As [Drive letter],
tblDiskdrives.Description,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As Size,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Freespace
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblDiskdrives.Description Not Like '%floppy%' And
tblDiskdrives.DriveType = 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
[Drive letter]
‎10-29-2015 12:07 PM
‎10-27-2015 05:09 PM
‎10-27-2015 04:31 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
Case When tblComputersystem.Domainrole > 1 Then 'Server' Else 'Workstation'
End As [Server/Workstation],
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblDiskdrives.Caption As [Drive letter],
tblDiskdrives.Description,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As Size,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Freespace
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblDiskdrives.Description Not Like '%floppy%' And
tblDiskdrives.DriveType = 2 And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
[Drive letter]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now