Thanks Jacob.

I need to see who are not empty on those fields first. I found the following two commands give different result:
Get-Mailbox -Filter {CustomAttribute1 -ne $null} | select Name, CustomAttribute1, CustomAttribue2
Get-Mailbox | ? CustomAttribute1 -ne $null | select Name, CustomAttribute1, CustomAttribue2

Aren't they supposed to give the same result?

Jacob Durham

10/12/2018

Empty

get-mailbox -ResultSize unlimited | Where-Object CustomAttribute1 -like $null

Open in new window

NotEmpty

get-mailbox -ResultSize unlimited | Where-Object CustomAttribute1 -notlike $null

Open in new window

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

Certified Expert Program

Credly Partnership

Udemy Partnership