SQL to check number of email with email received date in inbox for user

[Y1251]

Hi,

may I have a SQL to generate a report that a user inbox status in vault and the output as below:

username, email subject, received date 

thanks

[GertjanA]

Hello,

If you look for this question in Google, you will get this post from the forum:

https://vox.veritas.com/t5/Enterprise-Vault/Query-on-what-items-were-archived-on-a-particular-date/t...

Enjoy!

[AndrewB]

sorry but email subject is not stored in SQL