Script for billing account change
- 12 years ago
go to http://evServer/EnterpriseVault/Usage.asp
then open up the usage by archive name, export to a TSV file
After that you can just import to excel, sort by billing account
then you will have the name of those that have no items
and for those that do have items, you would need to do the following
1. Open the Vault Admin Console
2. Find one user who you wish to change the billing account on
3. Go to the properties and assign the new billing account, note the name of the user
4. Open up SQL Management Studio
5. Run the following querySELECT A.ArchiveName, T.TrusteeIdentity, T.SID
FROM Archive A, Root R, Trustee T
WHERE A.RootIdentity = R.RootIdentity
AND R.OwningTrusteeIdentity = T.TrusteeIdentity
AND A.ArchiveName = 'Your User'6. Note down the TrusteeIdentity (e.g. 582)
7. Get a list of all the Archive Names from the Usage report
8. Run the following queryUPDATE Root
SET OwningTrusteeIdentity = 582
WHERE R.RootIdentity IN
(SELECT RootIdentity
FROM Archive
WHERE ArchiveName IN ('User A', 'User B', 'User C', 'User D', 'User E'))After that, just refresh your vault admin console, and you should no longer have any unknown billing accounts except for the ones you are processing to delete