Hard drive space and size query

[SimplyClueless]

Hopefully some of these questions are useful for the community;

I have a new one; can someone help me with a query that specifies

Machine name
Last Scanned time
Hard drive size
Hard drive space

?


thanks in advance

[SimplyClueless]

good advice; this seems to work quite well

[RCorbeil]

Be aware that that report produces single values for size and capacity that are the sum of all drives, i.e. if you have a 250GB boot drive, a 1TB data drive and an external 1TB drive, the size reported will be based on 2.25TB. If you want all drives individually identified, take a look at this message thread.

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen As [last scan],
Sum(Cast(Cast(tblDiskdrives.Size As BigInt) / 1024 / 1024 / 1024 As Numeric))
As [Total size (GB)],
Sum(Cast(Cast(tblDiskdrives.Freespace As BigInt) / 1024 / 1024 /
1024 As Numeric)) As [Free in GB]
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen
Order By tblAssets.AssetID