header1   header
header
header Register : : Login header
header
connector   connector
menuleft menuright
submenu   submenu
left
Output Variables to a table
Last Post 03 Mar 2010 07:58 AM by MitchellGuthrie. 0 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
MitchellGuthrieUser is Offline
New Member
New Member
Posts:8
Avatar

--
03 Mar 2010 07:58 AM
    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
    You are not authorized to post a reply.


    Active Forums 4.3
    right
    footer   footer
    footer Sponsored by Quest Software • SAPIEN Technologies • Compellent • Microsoft Windows Server 2008 R2 footer
    footer   footer