→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
wolfpack
Engaged Sweeper
I am trying without much success to run a report that only has the following results generated:
1) Server list by Hostname/Computername
2) Hard drive letters (optional)
3) Total Hard drive space Free (all drives)
4) Total Hard drive space Used (all drives)
5) Total Hard drive space (all drives)

I have been through nearly every forum discussion, and have tried many of the reports that have been posted, but none of them can give me anything close to what I need. Every one I have tried gives me a whole lot of garbage that I don't need, and nothing that I do need. Any help on this would be greatly appreciated.

Thanks!
1 REPLY 1
Hemoco
Lansweeper Alumni
Please use the report below for the information you are after.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblDiskdrives.Caption,
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling((tblDiskdrives.Size / 1024 / 1024) - (tblDiskdrives.Freespace / 1024 /
1024)) As UsedMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1 And
tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption