Also - to change the report to view disk space from "Free" to "Total", change the below lines:
Line 27:
Old: When tblAssets.AssetID = freespace.AssetID Then 'Pass'
New: When tblAssets.AssetID = disksize.AssetID Then 'Pass'
Line 29:
Old: End As [Disk space > 64GB],
New: End As [Disk size > 64GB],
Line 49:
Old: freespace.AssetID Then '#d4f4be'
New: disksize.AssetID Then '#d4f4be'
Line 905-906:
Old: Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As free,
New: Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As free,
Line 912-913:
Old: Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) > 64000) As freespace On freespace.AssetID = tblAssets.AssetID
New: Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) > 64000) As disksize On disksize.AssetID = tblAssets.AssetID