Disk Partitions and Space

[dsn7287]

Hi all,

Hope you are well.

So I have gotten to about 90% of the way with a report but I've hit a wall and would really like some help please.

The idea is basically for me to get a report generated from Lansweeper that lists all disk partitions of all the scanned PCs and along with their respective disk sizes and free space. (The below report achieves this). However in addition I also need to be able to get a total of the partition sizes (i.e. lets say laptop XXX had 3 partitions C, D and E, I need a column that shows the sum total of those three partitions as well - this is the area of the report I am having a problem with (please help ).

This is the code I have so far:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblOperatingsystem.Caption,
tblAssets.Username,
tsysOS.Image As icon,
tblDiskdrives.Caption As Caption1,
tblDiskdrives.Size / 1073741824 As [Size (GB)],
tblDiskdrives.Freespace / 1073741824 As [Freespace (GB)]
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID And
tblDiskdrives.AssetID = tblAssets.AssetID
Where tblAssetCustom.Manufacturer Not Like '%VMware%' And
tblAssetCustom.Manufacturer Not Like '%Parallels%' And
tblAssetCustom.Model Not Like '%virtual%' And tblAssetCustom.Model Not Like
'%HVM%' And tsysOS.OSname Not Like 'Win 2008%' And
tsysOS.OSname Not Like 'Win 2012%' And tsysOS.OSname Not Like 'Win 2003%' And
tblAssets.AssetName Not Like 'Axtw%' And tblAssets.AssetName Not Like 'W7%'
And tblAssetCustom.State = 1 And tblADComputers.OU Like '%OU=AUS%'
Order By tblAssets.AssetName,
Caption1