EV 6.0 query to find the oldest and newest item in each user's archive
I need a SQL query to find the oldest and newest item in each user's archive. I found the solution in the post below :-
However it does not work for EV 6.0 which we are using. I find the IndexVolume table in Directory database is not present however the Oldest and Newest item data is contained in the 'Index' Table for 6.0.
If anybody can help me create a query for EV 6.0 I would greatly appreciate. I need to get this data out for legal lawsuit ASAP. Let me know if there is any other way to get this data from EV.
Thanks in Advanvce