Unsolved
This post is more than 5 years old
11 Posts
0
747
April 24th, 2017 09:00
Find all emails older than X years, and output the size
Dear all,
Does anyone have a query for finding the size of all emails older than say 10 years, and outputting the size of that.
We are using sourceone/centera solution for this.
I understand I would need to use an sql query for that?
Thanks
No Events found!
RKatwal
2 Intern
•
600 Posts
0
May 8th, 2017 22:00
I do not take responsibility but query similar to the following may be able to help you.
SELECT fp.path, cast(sum(v.VolumeSize)/1024 as numeric) as 'Volume Size (MB)'
FROM Volume v (NOLOCK)
JOIN folderPlan fp (NOLOCK)on fp.FolderID=v.FolderNodeID
GROUP BY fp.Path
ORDER BY fp.Path
Regards,
Rajan Katwal
RKatwal
2 Intern
•
600 Posts
0
May 8th, 2017 22:00
Hi,
Unfortunately I do not have any SQL query handy that I could provide you.
Approximate size per month is displayed in SourceOne console. You may want to look into that and manually do the sum. It comes from combination of mainly volume table and folderplan table within SourceOne archive DB. It is not 100% accurate but close enough figure. Also that could be size after compression.
Thanks,
Rajan