Solved

Export Send Connector Address Space

Posted on 2010-11-17
13
4,089 Views
Last Modified: 2013-04-10
I have an Exchange 2007 organization and have a need to export the domains listed in a Send Connector out to a file.
When I tried to do this, they are listed with the '...' just as in the powershell.

I know this can probably be exported out of AD as well, but I am having difficutly in getting it accopmlished.
Thanks!
0
Comment
Question by:thornmn
  • 7
  • 5
13 Comments
 
LVL 25

Expert Comment

by:Tony1044
ID: 34156104
What command are you running?
0
 

Author Comment

by:thornmn
ID: 34156500
[PS] C:\Windows\system32>Get-SendConnector -id "send_connector_name" | export-csv c:\o
utput.csv
I have used variations of this command.  Using the above command provides the following output in the AddressSpaces column:  
Microsoft.Exchange.Data.MultiValuedProperty`1[Microsoft.Exchange.Data.AddressSpace]

Thanks
0
 
LVL 25

Assisted Solution

by:Tony1044
Tony1044 earned 250 total points
ID: 34156550
Ok - what happens if you just run the following:

Get-SendConnector | Select Name, @{Name=AddressSpaces;Expression={[string]::join(";", ($_.AddressSpaces))}}| Export-CSV c:\output.csv

Also - you're running the management shell as an administrator, yet?
0
 

Author Comment

by:thornmn
ID: 34156590
No dice:
The term 'AddressSpaces' is not recognized as the name of a cmdlet, function, s
cript file, or operable program. Check the spelling of the name, or if a path w
as included, verify that the path is correct and try again.
At line:1 char:74
+ Get-SendConnector -id "US_to_UK_Send" | Select Name, @{Name=AddressSpaces <<<
< ;Expression={[string]::join(";", ($_.AddressSpaces))}}| Export-CSV c:\output.
csv
    + CategoryInfo          : ObjectNotFound: (AddressSpaces:String) [], Comma
   ndNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException
0
 
LVL 25

Accepted Solution

by:
Tony1044 earned 250 total points
ID: 34156685
Sorry - think I'm giving part of a script there and I'm not in front of an Exchange system to test.

Try just this for now:

Get-SendConnector -Identity "Send Connector Name" | ft -autosize -wrap property AddressSpaces


0
 

Author Comment

by:thornmn
ID: 34157598
Format-Table : A positional parameter cannot be found that accepts argument 'Ad
dressSpaces'.
At line:1 char:49
+ Get-SendConnector -Identity "US_to_UK_Send" | ft <<<<  -autosize -wrap proper
ty AddressSpaces
    + CategoryInfo          : InvalidArgument: (:) [Format-Table], ParameterBi
   ndingException
    + FullyQualifiedErrorId : PositionalParameterNotFound,Microsoft.PowerShell
   .Commands.FormatTableCommand
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:thornmn
ID: 34158268
I ran this command (added a dash in front of Property) and received the on-screen output w/out error.

Get-SendConnector -Identity "US_to_UK_Send" | ft -autosize -wrap -property AddressSpaces

It did truncate after 5 lines...
0
 

Assisted Solution

by:thornmn
thornmn earned 0 total points
ID: 34158569
Ok, here is what I did to solve this:
Followed this article to prevent the truncation of the lines:
http://exchangeserverpro.com/how-to-prevent-truncation-of-long-output-in-exchange-management-shell
COMMAND:  [PS] C:\>$FormatEnumerationLimit =-1
Ran this command:
[PS] C:\Windows\system32>Get-SendConnector -Identity "connector_name" | ft -autosize -wrap -property AddressSpaces |out-file c:\output.txt

Thanks Tony1044 for getting me on the right path!

0
 

Author Comment

by:thornmn
ID: 34158621
Accepted
0
 
LVL 25

Expert Comment

by:Tony1044
ID: 34162380
Sorry I couldn't respond sooner - I was on the road. Glad you resolved the truncation. Never been sure why MS choose to do it by default.

Glad you got the result you wanted and thank you for the points request.
0
 

Author Closing Comment

by:thornmn
ID: 34186418
Additional command found based upon initial comments from Tony1044
0
 
LVL 25

Expert Comment

by:Tony1044
ID: 34186520
Thank you for the points. Glad I helped in some small way and you resolved it.

Good luck.
0
 
LVL 3

Expert Comment

by:bakerm00
ID: 39066420
old post - but had to post a cleaner way
$Sendcon= get-sendconnector <name>
$Sendcon.addressspaces | select domain | Export-CSV c:\output.csv
1

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
This video discusses moving either the default database or any database to a new volume.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now