cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query to find number of indexed item.

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.

1 Solution

Accepted Solutions
Accepted Solution!

Re: SQL query to find number of indexed item.

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

View solution in original post

2 Replies
Accepted Solution!

Re: SQL query to find number of indexed item.

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

View solution in original post

Re: SQL query to find number of indexed item.

Thanks Chris, yes your understanding is correct single user = single user archive.