PowerShell combine filters ResourceType & AdditionalResponse

DrCyberCure 

Here's an example using the more recent Get-EXOMailbox (which is faster and more efficient (in most cases), but not necessary if you work for a small-to-medium-sized organisation).

Get-EXOMailbox (and the older Get-Mailbox) support server-side filtering, which is why they provide a -Filter parameter. Server-side filtering is always faster, however, it's not available on every commandlet.

Get-CalendarProcessing does not support server-side filtering, which is why there is no -Filter parameter. You have to do the filtering client-side.

Here's a functional example you can tailor to your needs.

Get-EXOMailbox -Filter "ResourceType -eq 'workspace'" -PropertySets StatisticsSeed -Properties Alias, ResourceType |
    ForEach-Object {
        $Mailbox = $_;

        Get-CalendarProcessing -Identity ($_.Identity) |
            ForEach-Object {
                if ($_.AdditionalResponse -match "WORD")
                {
                    [PSCustomObject] @{
                        Guid = $Mailbox.Guid;
                        ResourceType = $Mailbox.ResourceType;
                        Alias = $Mailbox.Alias;
                        AdditionalResponse = $_.AdditionalResponse;
                    }
                }
            }
    } |
        Export-Csv -NoTypeInformation -Path "C:\Data\someOutputfile.csv";

Cheers,

Lain

DrCyberCure 

2/ Try this command instead : 

Get-CalendarProcessing | Where-Object { $_.AdditionalResponse -contains "WORD" } | Select Alias

Here is my attempt at writing an example : 

# Get all mailboxes.
$mailboxes = Get-Mailbox -ResultSize Unlimited

# Filter mailboxes by ResourceType.
$mailboxes = $mailboxes | Where-Object { $_.ResourceType -eq "Workspace" }

# Filter mailboxes by AdditionalResponse containing "WORD".
$mailboxes = $mailboxes | Where-Object { $_ | Get-CalendarProcessing | Select-Object -ExpandProperty AdditionalResponse -like "*WORD*" }

# Select the Alias property.
$mailboxes = $mailboxes | Select-Object Alias

# Export the list to a CSV file.
$mailboxes | Export-Csv -Path "C:\path\to\output.csv" -NoTypeInformation

not tested yet,

DrCyberCure 

Something like

$total = foreach ($mailbox in Get-Mailbox -Filter '(ResourceType -eq "workspace")') {
    if (Get-CalendarProcessing -Filter '(AdditionalResponse -contains "WORD")') {
        [pscustomobject]@{    
            DisplayName = $mailbox.displayname
            Alias       = $mailbox.alias
        }
    }
}
$total | Export-Csv -NoTypeInformation -Path c:\temp\mailboxes.csv -Encoding UTF8 -Delimiter ';'

Untested, don't have an Exchange Server available at this moment 😉