Vault Cache query

[GTK]

what is the quickest way to see how many users have vault cache enabled. Currently it is targeted to whole exchange Org (by mistake) and I need to know exactly how many users have it enabled. Is there a SQL query that can find this?

thanks

[JesusWept3]

quickest way i believe is

USE EnterpriseVaultDirectory
SELECT COUNT(*) FROM Archive WHERE RetainArchiveHistory > 0

However that will not tell you how many are enabled right at this moment, it will only tell you how many have had it enabled once in their archives life time

[JesusWept3 · Accepted solution]

Another way you can do it is look at the AdminJobEntry table.
This query will give you the users who have active vault cache jobs created in the last two days

The job author will give you the physical NT Username of who began the sync , such as MYDOMAIN\UserA

SELECT JobAuthor "User", COUNT(AdminJobEntryId) "Vault Cache Job Count"
FROM AdminJobEntry
WHERE uniqueJobId = 'VaultCacheJob'
  AND StartTime > DateAdd(d, -2, getDate())
GROUP BY JobAuthor

[Rob_Wilcox1]

You could also analyse the IIS logs.