Custom Partition Report for Vault 10.x for Exchange
Been trying to get a solution through writing SQL query but it just isn't quite meeting my expectations. I want a report that shows the size taken on the disk per partition.
I have tried 2 methods so far and neither one give me correct numbers.
Query 1 looked in the PartitionDB at the Saveset table
grouped by column IdPartition and sum on the column ItemSize
Query 2 looked at the fingerprint DB at the MemberTable_XXX tables
union all of them together into temp table, then grouped by column PartitionIdentity and sum by column StoreSize
I contacted support but they said the best bet would be to go here, which makes sense.
Has anyone done this successfully?