Feed a list of user in Get-Mailbox command

damonvillar6266 · 2018-10-24T16:55:23.000Z

I am in the process of creating a script that will be show different mailbox properties. Be low is the beginning of the script

$BSBUsers = Get-Mailbox -Filter {CustomAttribute1 -eq “BSB”}
ForEach ($User in $BSBUsers) {
Get-CASMailbox | where {$_.OWAEnabled}

}

The above works but the output is for everyone in the organization and not just the users with BSB set as CustomAttribute1. If I add a Write-Host $User it show the correct people.

How do I fix this?

Thanks in advance

Neally · 2018-10-24T16:57:47.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-10-24T17:00:17.000Z

try your filter like so:

$BSBUsers = get-mailbox -Filter "CustomAttribute1 -eq 'BSB'"

ForEach ($User in $BSBUsers) {
    Get-CASMailbox | where {$_.OWAEnabled} 
}

shelly · 2018-10-24T17:02:37.000Z

You have the correct user, but you aren’t using that user to filter which mailbox you are trying to get. Your code is really saying to get ALL casmailboxes, and then filter to only those that have the same OWAEnabled parameter as the current user does. You meant to filter on the user’s name, yes?

It should be more like:

Get-CASMailbox $($_.Login)

learn.microsoft.com

Get-CASMailbox (ExchangePowerShell)

This cmdlet returns a variety of client access settings for one or more mailboxes. These settings include options for Outlook on the web, Exchange ActiveSync, POP3, and IMAP4. You need to be assigned permissions before you can run this cmdlet....

edit: correction in filter wording

damonvillar6266 · 2018-10-24T17:18:12.000Z

I am trying to get a list of users in $BSBUsers that have OWAEnabled

It shows the output for ALL CASMailboxes and not just the ones in $BSBUsers.

How can I make this work? I just want to query users in $BSBUsers and not every casmailbox.

Thanks

damonvillar6266 · 2018-10-24T17:29:39.000Z

$BSBUsers = Get-Mailbox -Filter "CustomAttribute1 -eq 'BSB'"
    ForEach ($User in $BSBUsers) {
    #Write-host $User
    Get-CASMailbox -Filter {OWAEnabled -eq "True"}
}

I tried the above and it still wants to show me output for ALL casmailboxes in the organization. I am trying to identify who has OWAEnabled for users in the variable $BSBUsers

PatrickFarrell · 2018-10-24T17:30:01.000Z

That is because you are just calling Get-CasMailbox. You aren’t specifying a user name after it. You did the for loop but forgot to put the variable on the Get-CasmMailbox call.

$BSBUsers = Get-Mailbox -Filter {CustomAttribute1 -eq "BSB"}
    ForEach ($User in $BSBUsers) {
    Get-CASMailbox $User | where {$_.OWAEnabled}

}

damonvillar6266 · 2018-10-24T17:42:05.000Z

Thanks - When I try that I receive the below error message. Any ideas?

$BSBUsers = Get-Mailbox -Filter "CustomAttribute1 -eq 'BSB'"
    ForEach ($User in $BSBUsers) {
    Get-CASMailbox $User| where {$_.OWAEnabled -eq "True"}

Cannot process argument transformation on parameter ‘Identity’. Cannot convert value “User in BSBUsers” to type “Microsoft.Exchange.Configuration.Tasks.MailboxIdParameter”. Error: “Cannot convert hashtable to an object of the following type: Microsoft.Exchange.Configuration.Tasks.MailboxIdParameter. Hashtable-to-Object
conversion is not supported in restricted language mode or a Data section.”

CategoryInfo : InvalidData: ( [Get-CASMailbox], ParameterBindin…mationException
FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-CASMailbox
PSComputerName : outlook.Office 365.com

shelly · 2018-10-24T17:57:26.000Z

That error is telling you that simply using $User isn’t matching with a valid identity in CASMailbox. So, your $User is likely returning UserPrincipalName, and I’m guessing that there’s a different Mailbox attribute that is used for the CASMailbox identity filter. Would you instead use something like $($.mail) or $($.login) for the $user identity? Which attribute matches your logon for OWA?

You can test the available properties (attributes) by testing your own login, assuming you do have an OWA login as well as regular mailbox. Run a simple

$me = get-mailbox -identity dvillar@yourcomany.com (or whatever your email account is). Then type $me. (that’s really $me with a period) which should show you a popup menu of different properties you can look at. or quite simply just type $me and see what prints.

damonvillar6266 · 2018-10-24T18:47:05.000Z

Thanks for your help…

So, if I run the get-casmailbox command I see a ‘Name’ property that matches the output of the get-mailbox command. So if one of the users

in $BSBUsers is ‘Joe Blow’ then ‘Joe Blow’ matches with the ‘Name’ property in get-casmailbox.

Are you saying I need to substitute $Name for $User in my get-casmailbox command?

I feel really dumb right about now

damonvillar6266 · 2018-10-24T19:32:05.000Z

Thanks for everyone’s help - it pushed me in the right direction for sure.

So, I figured it out. Since the names contained in the variable $BSBUsers consisted of a users full name it therefore contained a space. I had to enclose $User in the get-casmailbox command in quotes. Once this was done it worked.

My next question is how can I add mutiple properties in the where command. I.E. where {$_.OWAEnabled}. Say I wanted to include .ActiveSyncEnabled, etc.

How can I do that?

$BSBUsers = Get-Mailbox -Filter "CustomAttribute1 -eq 'BSB'"
    ForEach ($User in $BSBUsers) {
    #Write-host $Name -ForegroundColor Green
    Get-CASMailbox "$User" | where {$_.OWAEnabled}
}