EVS and Filesystem Archives Bill Usage to

[Zhoerd]

Hello all,

I've serached these forums and some other resources, but I need to populate the Bill Usage to entry for Filesystem archives. I've found out the way to do this for the exchange archives, but not the FSA's. Does anybody know a solution besides going through them by hand?

Sincerely,
Sjoerd de Jong

[JesusWept3 · Accepted solution]

OK, so , Billing accounts in the database are set as Trustees, and are linked from the root table, to the Trustee table.
A simple query for looking at this would be

USE EnterpriseVaultDirectory
SELECT A.ArchiveName, T.SID
FROM Archive A, Trustee T, Root R
WHERE A.RootIdentity = R.RootIdentity
       AND R.OwningTrusteeIdentity = T.TrusteeIdentity


This would show you every archive (Journal, FSA, Exchange Mailbox, Shared archive, etc etc)
However with the billing being blank it will not return any File archives.

So we need to do the following

1. Open the Vault Admin Console, go to the properties of your File System Archive and set a billing account
2. Run the following query
    
    USE EnterpriseVaultDirectory
    SELECT A.ArchveName, T.TrusteeIdentity, T.SID
    FROM Archive A, Trustee T, Root R
    WHERE A.RootIdentity = R.RootIdentity
           AND R.OwningTrusteeIdentity = T.TrusteeIdentity
           AND R.Type = 129            -- Type 129 is an FSA archive
           AND A.ArchiveName = 'your Archive'

In my example it returns the following

Administrator File    -  47  - S-1-5-21-366442885886-3761301255-52149189-1148

3. Note the TrusteeIdentity, this is the Identity and SID for the user you just placed as the Billing Owner in the VAC.
4. Now assuming that you want ALL file system archives to be owned by the same person, we do the following

USE EnterpriseVaultDirectory
UPDATE Root
SET OwningTrusteeIdentity = 47
WHERE Type = 129
      AND OwningTrusteeIdentity IS NULL

This way it only updates FSA archives (Type = 129) and it won't overwrite any billing accounts already set as they have to be null

hope this helps

[JesusWept3]

oh and backup your EnterpriseVaultDirectory database before performing any changes