SQL Query to determine Frequency of Access

[AKL]

Hello

I am administering an Enterprise vault 9.0.1 environment with Exchange 2010 SP2 RU1, SQL 2008 R2 all running on Windows 2008 R2 VM servers.

Recently I have been asked to determine how frequently are items older than 6 months accessed "without" configuring Enterprise vault auditing. I know it is feasible via SQL queries on vault store database but I haven't started to put the puzzle pieces together yet.

If anyone has idea around same? SQL query to determine how many times items older than 6 months are accessed OR point in direction like which database and tables I will be looking into to pull out requested information?

Thanks in advance !

[JesusWept3 · Accepted solution]

you *have* to use Auditing if you want to do SQL Queries, the only other way you can do it is via IIS logs going against download.asp, but that won't give you a full picture of whats being accessed.

Auditing is there for this very reason

[AKL]

I guess I was afraid of same that we really do need to configure auditing first, thanks for confirmation