asked on

shared Mailboxes full report

Hello,

I need to report detailed statistics from shared mailboxes on Exchange 07.
I tried to use get-mailboxpermission command but I can't filter all columns.

The final csv file should include these properties: Mailbox_Name,WhenCreated, Mailbox_smtp_address,RequireSenderAuthenticationEnabled (Yes/No), HiddenFromAddressListsEnabled (Yes/No), Mailbox_database, ProhibitSendQuota
Prohibit_Send_Quota,Prohibit_Receive_Quota,IssueWarningQuota, ,ManagedBy,Notes,Full_Access (users samaccountname),Send_As(users samaccountname),User_Account_Is_Blocked (Yes/No),Accept_Messages_from

I suppose that it wouldn't be an easy work to write such script because i don't know that all properties are available.

Chris Dent

This gets us near to that. Anything missing?

You may have to clarify on what you mean by Accout_Is_Blocked and ManagedBy.

Chris

Get-Mailbox | ForEach-Object {
  $Stats = Get-MailboxStatistics $_.DistinguishedName

  $_ | Select-Object Name, WhenCreated, PrimarySmtpAddress, RequireSenderAuthenticationEnabled,
    HiddenFromAddressListsEnabled, Database, ProhibitSendQuota, ProhibitSendReceiveQuota, IssueWarningQuota,
    AcceptMessagesOnlyFrom, AcceptMessagesOnlyFromDLMembers, RejectMessagesFrom, RejectMessagesFromDLMembers,
    @{n='FullAccess';e={ 
      Get-MailboxPermission $_.DistinguishedName | 
        Where-Object { !$_.IsInherited -And $_.AccessRights -Match 'FullAccess' -And $_.User -NotMatch 'SELF' } |
        ForEach-Object { $_.User } }},
    @{n='SendAs';e={
      Get-ADPermission $_.DistinguishedName |
        Where-Object { !$_.Inherited -And $_.Rights -Match 'Send-As' } |
        ForEach-Object { $_.User } }}
}

Open in new window

pi01162

ASKER

First thanks for reply!
ManagedBy (Shared mailbox manager) and Account_Is_Blocked (user's account is blocked in ActiveDirectory)

pi01162

ASKER

Helo,

I tested this script and almost works except Send-As permission.
The script doesn't display those permissions. Full Acces is ok.

So please look again at Your's script and check "Send-As"

P.s Also I add manager field at the end

Get-Mailbox -organizationalunit 'domain.corp/Mailboxes' -id | ForEach-Object {

  $Stats = Get-MailboxStatistics $_.DistinguishedName

  $_ | Select-Object Name, WhenCreated, PrimarySmtpAddress, RequireSenderAuthenticationEnabled,
    HiddenFromAddressListsEnabled, Database, ProhibitSendQuota, ProhibitSendReceiveQuota, IssueWarningQuota,
    AcceptMessagesOnlyFrom, AcceptMessagesOnlyFromDLMembers, RejectMessagesFrom, RejectMessagesFromDLMembers,
    @{n='FullAccess';e={ 
      Get-MailboxPermission $_.DistinguishedName | 
        Where-Object { !$_.IsInherited -And $_.AccessRights -Match 'FullAccess' -And $_.User -NotMatch 'SELF' } |
        ForEach-Object { $_.User } }},
    @{n='SendAs';e={
      Get-AdPermission $_.DistinguishedName |
        Where-Object { !$_.Inherited -And $_.Rights -Match 'Send-As' } |
        ForEach-Object { $_.User } }},

    @{n='Manager';e={Get-User $_.DistinguishedName | select}}

}

Open in new window

ASKER CERTIFIED SOLUTION

pi01162

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial