Hi All, I have a script that works well so far. What it does is tells me how many mailboxes we've migrated from E2K3 to E2K7 based on the targetAddress attribute being populated. What I'd like to do is give the variables at the end a nice column heading and export to csv. Can anyone help?
$MailboxCountTotal = Get-Recipient -ResultSize unlimited -RecipientTypeDetails LinkedMailbox -Filter {((ExternalEmailAddress -ne "*") -and (Database -ne 'CN=SG15-DB01,CN=SG15,CN=InformationStore,CN=MDS3AEXxx,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=USiOMG,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=USIOMG,DC=COM'))} | measure-object
$MailboxCountEMEA = Get-Recipient -ResultSize unlimited -RecipientTypeDetails LinkedMailbox -Filter {((ExternalEmailAddress -ne "*") -and (Database -ne 'CN=SG15-DB01,CN=SG15,CN=InformationStore,CN=MDS3AEXxx,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=USiOMG,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=USIOMG,DC=COM'))} | Where {($_.ServerName –eq “MDS3AEXxx”) –or ($_.ServerName –eq “MDS3AEXxx”)} | Measure-Object $MailboxCountNA =
Get-Recipient -ResultSize unlimited -RecipientTypeDetails LinkedMailbox -Filter {((ExternalEmailAddress -ne "*") -and (Database -ne 'CN=SG15-DB01,CN=SG15,CN=InformationStore,CN=MDS3AEXxx,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=USiOMG,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=USIOMG,DC=COM'))} | Where {($_.ServerName –eq “MDS3AEXxx”) –or ($_.ServerName –eq “MDS3AEXxx”)} | Measure-Object $MailboxCountAPAC =
Get-Recipient -ResultSize unlimited -RecipientTypeDetails LinkedMailbox -Filter {((ExternalEmailAddress -ne "*") -and (Database -ne 'CN=SG15-DB01,CN=SG15,CN=InformationStore,CN=MDS3AEXxx,CN=Servers,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=USiOMG,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=USIOMG,DC=COM'))} | Where {($_.ServerName –eq “MDS3AEXxx”)} | Measure-Object $MailboxCountTotal.Count $MailboxCountNA.Count $MailboxCountEMEA.Count $MailboxCountAPAC.Count |