01-14-2021 10:25 AM
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?
Solved! Go to Solution.
01-18-2021 12:05 PM
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.
01-15-2021 02:03 AM - edited 01-15-2021 02:32 AM
Hello again.
I am not sure. What I would do is use the usage page (http://server/enterprisevault/usage.asp), and save the archivelist (will be a tsv file). Import that in Excel, then use VLOOKUP based on archivename to put the billing account in your overview.
<EDIT>
See: https://vox.veritas.com/t5/Enterprise-Vault/reporting-billing-account-and-youngest-item/m-p/853065
01-18-2021 12:05 PM
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.