Server Storge

[sleague]

I am looking for a report that tell me how much total storage, and free storage I have on all my servers and there drives.

Thank you

Sean

[Susan_A · Accepted solution]

Moved this from the Report Center to Report Requests & Questions. Please note that the Report Center is for posting finished Lansweeper reports, not questions.

A sample report that lists the information you are after can be seen below. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  
• Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder. The dictionary explains in great detail what each table and field stores.

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