Search all calendars for a specific appointment?

Question

_{Thursday, October 3, 2019 2:36 PM}

We have a user who sent an appointment out to a large number of other users and was wondering why they didn't get responses for message tracking. As it turned out the request for responses had gotten unchecked.

The user would now like to know who all accepted the meeting so they can get a head count of attendees, and would like to avoid having to resend the meeting invite.

I tried using the following command without success:

Get-Mailbox -ResultSize unlimited | Search-Mailbox -SearchQuery Subject:"Meeting Subject"

However this gave me the following error:

The target mailbox or .pst file path is required.
     + Category Info                       : InvalidArgument: (:) [], Argument Exception

Is there a way to use PowerShell to do this? They just need a head count. Ideally if I could sort (or do different searches) for Accepted or Tentative that'd be great, but any number will do.

All replies (7)

_{Thursday, October 3, 2019 6:04 PM}

You need to provide additional parameters for the Search-Mailbox cmdlet, in your case the -LogOnly and -TargetMailbox/TargetLocation should do. But this will not show whether they've accepted the meeting or not, best have him resend it.

_{Thursday, October 3, 2019 7:32 PM}

So it won't search their Calendar, only mail items? I figured if it could search Calendars it'd at least give me anyone who's either accepted it or marked it as tentative (which is better than nothing) as if they declined it then it wouldn't be in their Calendar at all.

_{Friday, October 4, 2019 6:52 AM}

Hi,

You can use the following command to search the meeting:

Get-Mailbox -RecipientTypeDetails UserMailbox| Search-Mailbox -SearchQuery {subject:"<subject>" AND from:<sender name> AND kind:meetings} -TargetMailbox "<mailbox name>" -TargetFolder "<folder name>" -LogOnly -LogLevel Full 

This command will generate a log and send to a target mailbox, here is my test result:

There are some point you have to pay attention to:

1.  The target mailbox won't be searched, you can specify the user who isn't the attendee or the organizer mailbox as the target mailbox.

2.  When we receive a meeting request, the meeting will show in our Calendar at the same time. In my test, the Read status of the item in Calendar will shown as TRUE by default. So we should focus on the Read status for the Inbox folder.

When users have taken action to the meeting request (Accept, Tentative, Decline), the request will be moved to "Deleted Items". However, we cannot tell if the user accepts or marks it as tentative.

Regards,

Lydia Zhou

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Friday, October 4, 2019 7:40 AM}

So it won't search their Calendar, only mail items? I figured if it could search Calendars it'd at least give me anyone who's either accepted it or marked it as tentative (which is better than nothing) as if they declined it then it wouldn't be in their Calendar at all.

It will search everything, my point was that it will not tell you whether the meeting was actually accepted. Declined items will be found in the Deleted Items folder, so again not definitive (you can check in which folder the item is in the log file).

_{Friday, October 4, 2019 8:01 PM}

2.  When we receive a meeting request, the meeting will show in our Calendar at the same time. In my test, the Read status of the item in Calendar will shown as TRUE by default. So we should focus on the Read status for the Inbox folder.

When users have taken action to the meeting request (Accept, Tentative, Decline), the request will be moved to "Deleted Items". However, we cannot tell if the user accepts or marks it as tentative.

Thanks, this is very helpful.

By this logic, if the result showed that the item was in their Deleted Items folder and was not in either their Inbox OR their Calendar, then they would have declined it? I wouldn't expect the item to remain in their Calendar folder if they actively declined the invite.

Here are some examples from the search I just ran that I can't quite make out what they mean given the above explanation:

- I have a number of users that only have it in Deleted Items, but don't know if it's because they deleted it without taking action or--if the above is true--they declined it.

- I have matches where users have the item as FALSE in their Inbox, TRUE in their Calendar, but no entry in Deleted Items. This leads me to believe they've not yet taken any action on the item (as it's unread in their Inbox).

- I also have matches where users have the item as FALSE in Deleted Items, and TRUE in their Calendar, and no match for their Inbox. I'm taking this to mean they deleted it without marking it as read (possibly from a mobile device, or shift selecting a bunch of emails to delete and catching the invite by mistake).

With these results, I was thinking if I looked for users who had it in their Calendar and Deleted Items, these would be people that responded to the meeting request in some fashion. If it is in fact true that the item would be removed from the Calendar folder if they Decline the invite, then any users who have it in both Calendar and Deleted Items should by elimination be people that either responded with Accept or Tentative--which would be a good enough starting point for me.

_{Wednesday, October 9, 2019 7:56 AM}

Hi,

There should be two records for each user. One is the meeting entry, one is the meeting request.

If the user declines and removes the meeting from his calendar, the meeting entry and meeting request email will go to "Deleted Items". Like use05 in the test, and there are two logs showing with "Deleted Items" in the image.

When users respond the meeting request with Accept or Tentative, the meeting entry will stay in "Calendar" folder, and only the meeting request email will go to "Deleted Items".

So we only can know the user reads the request, decline or doesn't decline the meeting from these logs.

Regards,

Lydia Zhou

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Tuesday, October 15, 2019 7:07 AM}

Just checking in to see if above information was helpful. If you have any questions or need further help on this issue, please feel free to post back.

Regards,

Lydia Zhou

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].