Export EV info to CSV via SQL Query
We are running Enterprise Vault 10.0.1
I am trying to export EV size information for each mailbox via SQL query, and here is what I have:
COUNT(S.IdTransaction) "Num. Items Archived",
SUM(S.ItemSize)/1024 "Archived Items Size (MB)"
FROM EnterpriseVaultDirectory.dbo.Archive A,
WHERE S.SavesetIdentity = SP.SavesetIdentity
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointId = R.VaultEntryId
AND R.RootIdentity = A.RootIdentity
GROUP BY A.ArchiveName
Above query works, but I also need SamAccountName.
Can anyone guide me?
Idea here is to script the query and export to CSV file and email the file daily...