Link to home
Start Free TrialLog in
Avatar of thornmn
thornmn

asked on

Export Send Connector Address Space

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!
Avatar of Tony J
Tony J
Flag of United Kingdom of Great Britain and Northern Ireland image

What command are you running?
Avatar of thornmn
thornmn

ASKER

[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
SOLUTION
Avatar of Tony J
Tony J
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thornmn

ASKER

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
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thornmn

ASKER

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
Avatar of thornmn

ASKER

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...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thornmn

ASKER

Accepted
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.
Avatar of thornmn

ASKER

Additional command found based upon initial comments from Tony1044
Thank you for the points. Glad I helped in some small way and you resolved it.

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