11-30-2017 04:12 AM
Hello All,
I am looking a way to find number of archive item index using a SQL query for a single user, we are using EV 12
Could you please help me with this.
Solved! Go to Solution.
11-30-2017 05:25 AM
How about this, against the Directory DB?
SELECT ArchiveName, SUM(IndexedItems) AS TotalIndexedItems FROM IndexVolumeView
WHERE ArchiveName = 'User 1' --Optional filter; comment out this line to list all archives
GROUP BY ArchiveName
(I'm assuming that when you say "for a single user" you mean "in a single user mailbox archive." If you mean something else, let me know.)
--Chris
11-30-2017 05:25 AM
How about this, against the Directory DB?
SELECT ArchiveName, SUM(IndexedItems) AS TotalIndexedItems FROM IndexVolumeView
WHERE ArchiveName = 'User 1' --Optional filter; comment out this line to list all archives
GROUP BY ArchiveName
(I'm assuming that when you say "for a single user" you mean "in a single user mailbox archive." If you mean something else, let me know.)
--Chris
11-30-2017 06:18 AM
Thanks Chris, yes your understanding is correct single user = single user archive.