Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Exporting users who have full mailbox rights on exchange 2007 mailboxes - PowerShell

I would like to export from Exchange 2007 who has full mailbox rights to a set number of mailboxes.

I have the mailboxes in question in a spreadsheet and i would like to use this as input into my PowerShell query.

The below query will get my all mailboxes

Get-Mailbox -ResultSize unlimited | Get-MailboxPermission | where { ($_.AccessRights -match “FullAccess”) -and ($_.IsInherited -eq $false) -and -not ($_.User -like “NT AUTHORITY\SELF”) } | Export-csv -path "c:\output"

thanks for the help
0
cmatchett
Asked:
cmatchett
  • 2
  • 2
1 Solution
 
SubsunCommented:
Just to be clear..

Are you trying to export all mailboxes which a user has full mailbox permission?

Or to report all users who has permission on a set of mailboxes?

Or to check if a user have permission on a set of mailboxes or not?
0
 
cmatchettAuthor Commented:
I have an excel spreadsheet that contains 120 mailboxes.

My task is to get all the users who have full mailbox control on these 120 mailboxes.

I would like the powershell query to take the mailbox names from the spreadsheet and then query who has full mailbox control of it.
0
 
SubsunCommented:
Save the excel file to csv file..

For example if you have the header of csv file in following format..
Email
Mbxa@domain.com
Mbxb@domain.com
Mbxc@domain.com

Open in new window

Then try the following code..
Import-Csv C:\Input.csv | % {
Get-Mailbox $_.Email | 
	Get-MailboxPermission | 
		where {
		($_.AccessRights -match “FullAccess”) `
		-and ($_.IsInherited -eq $false) `
		-and -not ($_.User -like “NT AUTHORITY\SELF”) 
		}
} | Export-csv -path "c:\output.csv" -nti

Open in new window

0
 
cmatchettAuthor Commented:
great work, thanks very much
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now