How is the disk space calculated for curdisksize and is this a valid query to run to report the space used for each repository?
'DiskGBUsed' = (Select Case
When [directory_objects].[name] = "XXXXXX'
Then (SELECT Try_Cast(sum([curdisksize])* .000000000931322574615479 as decimal(10,3))
FROM [XXXXXX].[dbo].[vol])
When [directory_objects].[name] = 'YYYYY"
Then (SELECT Try_Cast(sum([curdisksize])* .000000000931322574615479 as decimal(10,3))
FROM [YYYYY_DB].[dbo].[vol])
When [directory_objects].[name] = 'ZZZZ'
Then (SELECT Try_Cast(sum([curdisksize])* .000000000931322574615479 as decimal(10,3))
FROM [ZZZZ_DB].[dbo].[vol])
ELSE 0.00
END)