HelloWe are running EV 9.4. I have the SQL query below.SELECTEVDA.Archivename, round(cast(AP.ArchivedItemsSize as float)/1024,2) as 'size of archive in MB',Ap.ArchivedItems as 'no of archived items',AP.modifieddate,eme.MbxAlias,eme.mbxarchivingstateF...
hiwe are on EV 9 sp4. I have the SQL query below. This gives me archive name and last time an archive was modified. I would like also to include the mbxalias info from the 'exchangemailboxentry' table. I believe i need to add a join query. Can anyone...
we are using EV 8sp5
is it possible to get the the date of the oldest and youngest email in a vault store ?
EG - if an email was ingested on 5th Jan 2015 but the actual creation date of that email is 25th Oct 2011, is it possible to ge...
We are using EV 8 SP5.
i need a SQL query that gives the total size of an archive. The VS DBs are on a seperate SQL instance to the directory DB so i will need a JOIN in the query somehwere.
Can anyone help?
we are on EV8 Sp5. I am trying to see if we have archives for a large number of users (over 2000) who have left the business and no longer have an exchange mailbox. All i have to go off is their old smtp address
is there any way i can run a S...