Forum Discussion

Rajesh_Velaga1's avatar
Rajesh_Velaga1
Level 4
14 years ago

SQL Query to list "Bill Usage to" option

SQL Query to list "Bill Usage to" option
Enterprise Vault
Information Governance
Tip-How to
  • JesusWept3's avatar
    JesusWept3
    14 years ago

    SELECT A.ArchiveName "Archive Name", T.SID "Billing Owner"
    FROM Archive A, Root R, Trustee T
    WHERE A.RootIdentity = R.RootIdentity
    AND R.OwningTrusteeIdentity = T.TrusteeIdentity

    The problem you will have is that EV stores the SID and not the AD Account name, it then dos a SID lookup in AD to populate information in the VAC.

    You could use Linked Servers to bridge to AD and do a SID lookup from there i believe

Rajesh_Velaga1's avatar
Rajesh_Velaga1
Level 4
14 years ago

We wanted to automate EV Archive deletions, We will manually delete EV archives
if billing usage field is "unknown" (Users deleted from AD). Is that possible to
find out EV archives associated to deleted AD users using SQL query?