Solved

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

Posted on 2013-11-15
4
378 Views
Last Modified: 2013-11-27
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
Comment
Question by:cmatchett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

Expert Comment

by:Subsun
ID: 39651724
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
 

Author Comment

by:cmatchett
ID: 39651893
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
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 39651965
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
 

Author Comment

by:cmatchett
ID: 39680128
great work, thanks very much
0

Featured Post

What, When and Where - Security Threats from Q1

Join Corey Nachreiner, CTO, and Marc Laliberte, Information Security Threat Analyst, on July 26th as they explore their key findings from the first quarter of 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month3 days, 21 hours left to enroll

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question