Script to report full access permissions
hello
was wondering if someone could provide or at the very least point me in the right direction. i need to generate a report that lists full access permissions on mailboxes (i.e. a secretary has been granted full access permissions to an
executives mailbox). it would be a very time consuming process to use the gui and do this one by one. thanks in advance !
June 30th, 2010 1:50am
Try this...it will export results to a test file.
Get-Mailbox -server Exch2010 | Get-MailboxPermission | select identity, user, AccessRights > c:\temp\export.txtTim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 4:33am
awesome, that looks like what im looking forward to it. do you know if can i send the results to csv instead and clean up the formatting a little ??
June 30th, 2010 4:41am
sure...change command to
Get-Mailbox -server Exch2010 | Get-MailboxPermission | select identity, user, AccessRights | Export-csv c:\temp\export.csv
Tim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 4:42am
thanks. did that .. how would i format so identity , users, are in the own excel columns ?
June 30th, 2010 4:45am
You can open the txt file in excel and adjust the columns or I change the csv command aboveTim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 4:49am
thanks again. have the formatting worked out. one more question if u dont mind. the output after x amount of characters turns into ...
for example :
DOMAIN.LOCAL/Accounts/Users/Gol...
so i can't see the acutal username. are you aware of anyway to manipulate that ?
June 30th, 2010 4:55am
Try using the -autosize parameter with ft...see below
Get-Mailbox -server Exch2010 | Get-MailboxPermission | ft -autosize | select identity, user, AccessRights > c:\temp\export.csvTim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 4:59am
doesnt return any data if i add the autosize argument
June 30th, 2010 5:13am
try with txt extensionTim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 5:14am
same thing haha
June 30th, 2010 5:18am
Does it work with out the export...try this, should output to the EMS window.
Get-Mailbox -server Exch2010 | Get-MailboxPermission | ft -autosize identity, user, AccessRights
If so add > C:\temp\export.txt
to the end. Think I had something screwy with all the iterations.Tim Harrington - Catapult Systems - http://HowDoUC.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2010 5:23am
perfect, really appreciate it ! have a great night !
June 30th, 2010 5:31am