如何用PowerShell查询含收件人的多人日历会议项

Alright, let's tweak that PowerShell filter to only grab meetings with at least two people (and exclude those solo task-reservation appointments!). Your current code pulls all calendar items, so we need to add targeted conditions to focus on meetings with other attendees.

The Adjusted Filter #

Here's the updated $filter parameter that meets your exact requirements:

$filter = "[MessageClass]='IPM.Appointment' AND ([MeetingStatus] <> 0 OR [RequiredAttendees] <> '' OR [OptionalAttendees] <> '' OR [Resources] <> '')"

What Each Part Does #

Let's break down why this works for your use case:

• [MessageClass]='IPM.Appointment': Keeps all calendar-related items (we still need this base filter to target appointments/meetings)
• [MeetingStatus] <> 0: Excludes "non-meeting" solo appointments (solo tasks use the olNonMeeting status which equals 0, while actual meetings use values like 1 for sent meetings or 3 for received invites)
• [RequiredAttendees] <> '': Ensures there's at least one mandatory attendee besides the organizer
• [OptionalAttendees] <> '': Catches meetings with optional invitees
• [Resources] <> '': Includes meetings that book resources like conference rooms (which count as additional participants)

Full Working Code Example #

Here's how to plug this filter into your complete script:

# Initialize Outlook COM object
$Outlook = New-Object -ComObject Outlook.Application
$Namespace = $Outlook.GetNamespace("MAPI")
$calendarFolder = $Namespace.GetDefaultFolder([Microsoft.Office.Interop.Outlook.OlDefaultFolders]::olFolderCalendar)

# Filter for meetings with multiple participants
$filter = "[MessageClass]='IPM.Appointment' AND ([MeetingStatus] <> 0 OR [RequiredAttendees] <> '' OR [OptionalAttendees] <> '' OR [Resources] <> '')"

$filteredMeetings = $calendarFolder.Items.Restrict($filter)

# Optional: Verify results by viewing key properties
$filteredMeetings | Select-Object Subject, RequiredAttendees, OptionalAttendees, MeetingStatus

Extra Tips #

• If you want to narrow it further to only meetings you organized and sent, replace [MeetingStatus] <> 0 with [MeetingStatus] = 1 (this targets the olMeeting status specifically)
• The filter uses Outlook's Jet query syntax, so keep brackets around property names and single quotes for string values
• If you encounter edge cases where a meeting has MeetingStatus=0 but still has attendees, the attendee checks will catch those scenarios

内容的提问来源于stack exchange，提问作者Bobby Dore