AllExchange2010DAGMailboxesinaSiteQuery.ps1

<# all mailboxes in a site Ex10 EMS query #>
# one-line follows
get-exchangeserver | 
    where { $_.IsMailboxServer -eq $true -AND $_.Site -like '*SiteA*' -AND $_.admindisplayversion.major -eq 14 } | 
        get-mailboxdatabase | 
            where {$_.ReplicationType -eq "Remote"} | 
                get-mailbox -resultsize unlimited | 
                    select samaccountname,DisplayName,Alias, Office,WindowsEmailAddress, @{Name='Addresses';Expression={[string]::join(";", ($_.EmailAddresses))}}, Database,ServerName,IsResource,IsLinked,IsShared, UseDatabaseQuotaDefaults,IssueWarningQuota, ProhibitSendQuota,ProhibitSendReceiveQuota, ArchiveDatabase,ArchiveGuid,ArchiveName, ArchiveQuota,ArchiveWarningQuota,WhenMailboxCreated, HasPicture,HasSpokenName,OrganizationalUnit, LegacyExchangeDN,PrimarySmtpAddress,RecipientType, RecipientTypeDetails,RequireSenderAuthenticationEnabled, SimpleDisplayName,ExchangeVersion,Name,DistinguishedName, Guid,ObjectCategory,WhenChanged,WhenCreated |
                        export-csv .\Ex2010-mbx-users.csv -notype ; 

gisting up antique blog post code from circa 2013