Video Screencast Help

How to generate report in EV for Archived Email ?

Created: 02 Jul 2013 • Updated: 03 Sep 2013 | 7 comments
This issue has been solved. See solution.

In EV 9.0.4, how can I generate the report to show how many disk space the Email archive occupies ? I need to view and categorize this information based on year to determine the retention / data expiration policy.

Any kind of help, SQL Script will be greatly appreciated.

Thanks

Operating Systems:

Comments 7 CommentsJump to latest comment

GertjanA's picture

Hello John,

It is difficult to asses how much space an archive uses. There are some queries on the forum that will show the number of items and the size of the archive. I am not totally sure about the 'size of the archive'. If you use SIS, an archive might actually be smaller I believe.

If I recall correct, some of the queries allow setting a date-range, which would allow some sort of educated guess to set expiry.

I used the attached Powershell to check the fysical disks for size and occupation. (found that via Google)

there are some parameters you need to adjust.$ifile = (Get-location).path + "\domain.txt" where doman.txt containes the servernames that have the disks attached.

Name like '%IndexFOLDERNAME%' looks at folders that are like this entry, and have the indexes. In my environment, this would be something like '%EVINDEX%

Name like '%StorageFolderName%' same, but then for data-location. for me, this would be something like %EVStorage%

It generates an HTML file, which can be copied/pasted in Excel. I used this to prove weekly growth, and the need to add more storage.

Rename the file to ps1, that should do the trick

 

AttachmentSize
DiskSpace.txt 3.53 KB

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

SOLUTION
John Santana's picture

Gertjan, thanks for the reply, what is SIS ?

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

AndrewB's picture

single instance storage

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

John Santana's picture

ok, so in this case EV can help us to achieve SIS for my current strategy of archiving to CIFS share ?

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

GertjanA's picture

Hello John,

If you have enabled sharing on the Vault Store Group, or Vault Store, then yes.

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision

SOLUTION