cancel
Showing results for 
Search instead for 
Did you mean: 

List archives with youngest archive date as well as the Bill Usage To

ZS1
Level 3

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Prone2Typos
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

2 REPLIES 2

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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

 

Regards. Gertjan

Prone2Typos
Moderator
Moderator
Partner    VIP    Accredited Certified

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.