Total Space & Free Space

[Lawrence_Lonsda]

Hi

I am looking to create a report to show the space servers have free and the total space. I have found a report that does what i want but shows the disk spaces in MB and i would prefer GB I was just wondering if there is a report that can show total disk space of a drive and free disk space in GB

Kind Regards

Lawrence

[RCorbeil]

See if this helps.

[Marc_Tobien]

Hello
Thank you for this template.
I have a problem converting it so that diskdrives are summed up and not displayed individually per asset. We end up summing the HDD space and the RAM. Unfortunately RAM Assed and al other appear multiple times when there are more than one diskdrives.
Is ther. a way to solve that?

[David_G]

You can use this sample custom report below which will give you back the Free space and total size in GB. Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.

• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon16) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblDiskdrives.Caption,
  Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 As
  numeric) As FreeGB,
  Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric) As
  TotalSizeGB,
  tblDiskdrives.Lastchanged
From tblAssets
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As numeric)
  <> 0 And tblState.Statename = 'Active' And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblDiskdrives.Caption