Get-NamedProperties.ps1

# Get-NamedProperties
#
# Example:
# .\Get-NamedProperties.ps1 -Mailbox user1 | ft Prop*

[CmdletBinding()]
param (
    [Parameter()]
    [string]
    $Mailbox
)

$mb = Get-Mailbox $Mailbox
. $exscripts\ManagedStoreDiagnosticFunctions.ps1
$mbTableResult = Get-StoreQuery -Database "$($mb.Database.ToString())" -Query "SELECT MailboxNumber FROM Mailbox WHERE MailboxGuid = '$($mb.ExchangeGuid.ToString())'"
Write-Host "Found mailbox $($mb.DisplayName) with mailbox number $($mbTableResult.MailboxNumber)."
$mailboxNumber = $mbTableResult.MailboxNumber
Get-StoreQuery -Database "$($mb.Database.ToString())" -Query "SELECT * FROM ExtendedPropertyNameMapping WHERE MailboxNumber = $mailboxNumber"