SQL Query to list "Bill Usage to" option

[Rajesh_Velaga1]

SQL Query to list "Bill Usage to" option

[JesusWept3 · Accepted solution]

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]

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?

[jprknight-oldax]

JW2 you have done it again!

I already have a vbscript to lookup the AD name from the SID so combining this with your SQL query above I can create another kick ass page in EVDashboard.

I was only searching for anything on the forums which happened to mentioned which table contained the 'bill usage to' field!

Love your work!

Jeremy.