You are viewing limited content. For full access, please sign in.

Question

Question

disk space

asked on January 7, 2019

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)

0 0

Answer

SELECTED ANSWER
replied on January 7, 2019

curdisksize is calculating by summing toc.edoc_size, doc.txt_size, doc.img_size, doc.lft_size, doc.loc_size, ann.attach_size. Your query looks ok to me.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.