SQL query to find number of indexed item.

[Cdee]

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.

[ChrisLangevin · Accepted solution]

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

[Cdee]

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