• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • 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

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

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