Showing results for 
Search instead for 
Did you mean: 
Level 6
since ‎11-28-2011

User Statistics

  • 158 Posts
  • 4 Solutions
  • 0 Kudos given
  • 13 Kudos received

User Activity

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...
hi   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...
hi   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?   Thanks  
Hi 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...