Office 365 - Filter mailbox users by department or title

[FN-GM]

Hi,

 

I must be having a bad day but i cannot figure out or find the information on how i can use get-mailbox but filter it down bases on department or title.

I want to set some options on some mailboxes.

 

Thanks

[Edu-IT]

http://www.edugeek.net/showthread.php?t=137596

 

Might help?

[EduTech]

Hi,

 

I do not believe department is an attribute shown in the Get-Mailbox output, but the following should help. Department is shown in Get-MsolUser.

 

This Command will allow you to bring back all the users whom have X value in the Office Attribute.

 

get-mailbox | Where {$_.Office -ilike "MyOffice"}

 

This Command will allow you to bring back all the users whom have X value in the Department Attribute.

 

Get-MsolUser| Where {$_.Department -ilike "MyDepartment"}

 

I hope that helps,

James.

[FN-GM]

Hi,

 

I do not believe department is an attribute shown in the Get-Mailbox output, but the following should help. Department is shown in Get-MsolUser.

 

This Command will allow you to bring back all the users whom have X value in the Office Attribute.

 

get-mailbox | Where {$_.Office -ilike "MyOffice"}

 

This Command will allow you to bring back all the users whom have X value in the Department Attribute.

 

Get-MsolUser| Where {$_.Department -ilike "MyDepartment"}

 

I hope that helps,

James.

 

 

But that would then pickup users who do not have mailboxes wouldn't it?

 

Thanks

Edited July 28, 2014 by FN-GM

[EduTech]

But that would then pickup users who do not have mailboxes wouldn't it?

 

Thanks

 

If you were to run Get-MsolUser that indeed is the case. If you do want to use Department then in order to get ONLY Mailboxes back it would need to be more specific i.e. What License SKU they have for example.

 

You could use the following, but then this assumes that the license assigned to all users includes Exchange.

 

Get-MsolUser | Where {($_.Department -ilike "GBS") -and ($_.IsLicensed)}

 

 

Thanks,

James.

Edited July 28, 2014 by EduTech