Server report needed

[mmichalek]

Hello,

I was asked by my manager to provide a report that will include the following information.

Server name, Volumes on the server, Total volume size, Amount used on each volume in GB, Amount available on each volume in GB.

Trying to create custom report , but u don't think this can be done by running just one report.

Can someone assist/help with this request.

Thank You.

Marcin Michalek

[mmichalek]

Perfect,

Thank You so much, this report will work.

[MikeMc]

This is the report we use in our environments for server space:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tsysOS.OSname,
  tblAssets.Description,
  tblDiskdrives.Caption,
  Cast((Cast(tblDiskdrives.Freespace As DECIMAL) / Cast(tblDiskdrives.Size As
  DECIMAL) * 100) As DECIMAL(18,2)) As TotalPercentFree,
  Cast(Cast(tblDiskdrives.Freespace As DECIMAL) / 1024 / 1024 / 1024 As
  DECIMAL(18,2)) As FreeGB,
  Cast(Cast(tblDiskdrives.Size As DECIMAL) / 1024 / 1024 / 1024 As
  DECIMAL(18,2)) As TotalSizeGB,
  tblDiskdrives.Lastchanged As [Last Changed],
  tsysOS.Image As icon
From tblAssets
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where Cast(Cast(tblDiskdrives.Size As BIGINT) / 1024 / 1024 As NUMERIC) <> 0 And
  tblComputersystem.Domainrole > 2 And tblDiskdrives.DriveType = 3 And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblDiskdrives.Caption