Reports which show the EV archive and retention policy for FSA and Exchange Email

[John_Santana]

Hi People,

How can I generate the reports of the retention period, archive policy and archiving task schedule for FSA and Exchange on my EV 9 server ?

I only know how to browse and go through the EV item through the VAC one by one and then note it manually.

Any suggestion and solution eg. SQL script would be greatly appreciated.

Thanks

[AndrewB]

How do you envision linking those data points together in a report? or are you asking how to query each one seperately?

[John_Santana]

yes, I'm trying to get big picture of the current data archiving policy and its retention from different objects, like for FSA, Exchange mailbox, Journalling, etc...

[AndrewB]

retention period

use EnterpriseVaultDirectory

select * from RetentionCategoryEntry

archive policy

use EnterpriseVaultDirectory

select * from PolicyEntry

archiving task schedule for FSA and Exchange

use EnterpriseVaultDirectory

select * from Task

[AndrewB]

john how are you coming along with this one?

[John_Santana]

Yes, it seems that there is no way to generate the settings and each policy rule that is readable easily.

I guess, I'll have to fumble my way through each and every policy settings.

[AndrewB]

give this a shot:

https://www-secure.symantec.com/connect/downloads/enterprise-vault-configuration-reporter-ev-10