Query the ESE? RRS feed

  • Question

  • Hi

    We are running a version of MS Exchange that uses the ESE (Extensible Storage Engine). We have an inbox that receives automated alerts and the content has grown very large (1000s of emails) we want to 'query' the from/to/re values to derive aggregate counts and date dimensions.

    Is there anyway to do this?



    Monday, April 21, 2014 9:47 PM


  • What version in particular of Exchange are you running ?

    There are no API's for querying the ESE directly for that, to get the Stats you want you need to use one of the Mailbox API's which will depend on the version of Exchange your running. Eg if you running 2007 or later you can use either MAPI or Exchange Web Services. If you have Exchange 2010 then you use can an AQS query with EWS to query the Content Indexes see http://msdn.microsoft.com/en-us/library/office/dn579420(v=exchg.150).aspx. If your using Exchange 2013 then you could use eDiscovery.

    Depending on how complex you need to make your query and the actual number of Items in the Folder and the number of times you need to do this. You may find it easy just to enumerate through the Items (crawl the folder) which if you write your code well you can do reasonably quickly use EWS or using MAPI tables http://www.dimastr.com/redemption/mapitable.htm


    Tuesday, April 22, 2014 4:33 AM