get-inboxrule on multiple mailboxes

dannymainprize · 2018-06-28T17:53:39.000Z

I am trying to list the inbox rules on all the mailboxes in my O365 (approx 6,000). We had a malware infection and a bunch of people had a rule get created that marked messages as read and moved them to the archive folder. I need to find who has these rules still applied so I can clear them.

Microsoft tells me to use Start-RobustCloudCommand.ps1, but I can 't figure out how to convert my existing script to use that. I’ve been told to use invoke-command and Scriptblock, but all the examples I can find kinda suck.

My existing script takes ~6 hours and only reports the first handful of people. I created a dummy mailbox with some rules just to check, and it never shows them so I know my script is not completing.

Here is what I am running:

$users = get-mailbox -resultsize unlimited

$results=ForEach ($user in $users)
{
        $rules = get-InboxRule -Mailbox $user.name
        if ($rules.length -gt 0) {
                echo ""
                echo $user.name
                echo ""
                $rules | select name, priority, description | fl
                echo ""
        }
} 
$results | Out-File -FilePath "D:\Downloads\Powershell Scripts\rulesoutput.txt" -Append

Anyone know a better way to run this against multi thousand mailboxes, or have a better way all together?

Neally · 2018-06-28T18:44:15.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2018-06-28T19:03:58.000Z

I doubt this is faser though.

get-mailbox -resultsize unlimited  |
foreach {
    Write-Verbose "Checking $($_.alias)..." -Verbose
    $inboxrule = get-inboxrule -Mailbox $_.alias  
    if ($inboxrule) {
        foreach($rule in $inboxrule){
        [PSCustomObject]@{
            Mailbox         = $_.alias
            Rulename        = $rule.name
            Rulepriority    = $rule.priority
            Ruledescription = $rule.description
        }
    }
    }
} | 
Export-csv "$env:userprofile\desktop\export.csv" -NoTypeInformation

Neally · 2018-06-28T19:07:24.000Z

The issue is that it needs to check for each mailbox the rules.

It would be faster if you split that script by let’s say 6 or so and have each script check against that, then it would be 6 times faster. ¯_(ツ)_/¯

lucid-flyer · 2018-06-28T19:13:12.000Z

Microsoft have some throttling in place.
See here and here .
The second one actually gives an example around Inbox rules.

jitensh · 2018-06-29T00:40:23.000Z

That depends on your exchange performance

$users = (get-mailbox -RecipientTypeDetails userMailbox -ResultSize unlimited ).UserPrincipalName
foreach ($user in $users)
{
$rules=Get-InboxRule -Mailbox $user 
if($rules.length -gt '0') {
$rules | select name, priority, description | Export-Csv c:\inboxrules.csv -NoTypeInformation
}

}

dannymainprize · 2018-07-03T12:15:59.000Z

Thanks all. Running all suggestions to see if I can get some actual results.

dannymainprize · 2018-07-05T09:18:43.000Z

Worked perfect. I even got to tell Microsoft to close my ticket about this because spiceworks knows their stuff better than they do.

spiceuser-dcqar · 2018-12-14T15:35:15.000Z

HI What commands you ran to do this?

I need all our users who have forwarding rule and i am also script rookie