Search-mail for meetings with specific start dates

Hi,

I'm hoping this will be an easy syntax question to answer.  I'm currently in the process of migrating 1000 users cross-forest between Exchange and Lync environments.  As part of this, we don't want people to be using the old forest Lync environment, and as part of preventing this, we want to search user mailboxes for meetings to that environment.  Right now the search is picking up old items in it.  In the results, I am only seeing a "sent date" and "received date".  The start time is empty.  This isn't too useful because somebody could easily have sent a meeting request 2 months ago for a future date or one that was held 2 months ago.  I can't differentiate between the two currently.

Is there a way to filter out meeting content based on the start date?  This is what I'm currently doing:

get-mailbox -resultsize unlimited | search-mailbox -searchquery "Kind:meetings","(DN) Danish" -logonly -loglevel full -targetmailbox me -targetfolder PSC-SearchLog

Also, you may see that I'm using "(DN) Danish" for the search.  This is because search-mailbox apparently can't penetrate hypertext encoding where "Join Online Meeting" is pointing to "https://meet.domain.com/{meeting id}".  It can't search either "Join Online Meeting" or the url itself, so my options are limited to plain text to search.  Is there a way to penetrate hypertext?  Thanks!

Don't cross the streams!


June 8th, 2015 11:46am

What you are looking to do may be a bit advanced for the Search-Mailbox cmdlet. You will likely have better luck using the EWS Managed API with Powershell. This blog has some really good details on it: http://gsexdev.blogspot.com/#!. This post may be of particular interest: http://gsexdev.blogspot.com/2012/02/ews-managed-api-and-powershell-how-to.html?q=ews+calendar

Getting familiar with the EWS Managed API can be a bit daunting at first, but I am not sure there is a better way available to accomplish what you are looking for.

Free Windows Admin Tool Kit Click here and download it now
June 8th, 2015 1:12pm

Agree with Sean that EWS would be your best bet with MS tools, however if your open to 3rd part utilities check out our DigiScope product http://www.lucid8.com/product/digiscope.asp as you can pretty much search on any criteria across all or specific message types, date ranges for creation, start, end dates etc as shown below in the simple search and there are even more advanced methods you can use via Regular Expression or by using the advanced search fields. 

If your just looking to find the items you can use the free DEMO license, however if you want to act upon them i.e. export, delete, purge you would need a license

June 8th, 2015 2:48pm

Thanks for the quick response.  I'm sure learning EWS would be beneficial, and I appreciate the links to the blog posts.  This needs to be done by Monday though, and with all the other custom scripting we have going on (cross-forest public folder content sync, cross-forest public folder acl sync, cross-forest mailbox migrations, cross-forest resource migrations, transport rule sync, etc) I just won't have time to dedicate to it.  

I'd just have to go with the imperfect search-mailbox results.  

Free Windows Admin Tool Kit Click here and download it now
June 9th, 2015 11:46am

Thanks.  I'll take a peek and see if it produces usable results.  
June 9th, 2015 11:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics