EVS and Filesystem Archives Bill Usage to
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
- 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
