List archives with youngest archive date as well as the Bill Usage To
The following will list all archives and provide the oldest and younest archive date.
USE EnterpriseVaultDirectory
SELECT ArchiveName, OldestArchivedDateUTC, YoungestArchivedDateUTC
FROM EnterpriseVaultDirectory.dbo.IndexView
ORDER BY OldestArchivedDateUTC
What do I need to add to the SELECT statement to also provide the Bill Usage To account?
IIRC, the bill to is a resolved name from SIDs so to do this you would have to dump the SID into a command that could resolve the SID to a user name because it is not avaialble in the DB directly.
