Export Transport Rule in csv with column

Question

Export Transport Rule in csv with column

asdf das 46

Hi,
need to export domainlist of O365 transport rule to a csv but with columns.
This code works:

$domain= Get-TransportRule "Test Rule" | select -ExpandProperty ExceptIfRecipientDomainIs | out-file C:\myfile.csv

but I need two Columns inside CSV, the first "Column 1" that contains results of $domain, the second Column 1 that contain the name of the Rule "Test Rule" for each record

How can i achieve this?

thanks so much

3 answers

Your answer

Answer 1

Roderick Bant 2,056

Try the example below

Get-TransportRule "Test Rule" | select -ExpandProperty ExceptIfRecipientDomainIs | Export-Csv C:\myfile.csv

Roderick Bant 2,056 Reputation points

2021-09-10T14:50:00.75+00:00

You might want to add the -NoTypeInformation parameter to the Export-Csv CmdLet to get a clean .CSV file
asdf das 46 Reputation points

2021-09-10T15:35:52.053+00:00

Hi this doesn't work :

TYPE System.String

"Length"
"17"
"18"
"29"
"13"
"8"
"16"
"12"
"25"
"16"
"14"
"13"
"12"
"20"
"16"
"9"
"10"
"17"

and also not achived my question, I'd like to put this result inside a Column "Column1" and create another Column "Column2" with the name of the rule

Answer 2

Rich Matheisen 47,901

I don't have an Exchange organization in which to try this, so I'm not sure what the results will be from the Select-Object (i.e. an array or a comma-separated string), or if "Name" is the correct property name in the transport rule object, but give this a try and see if it helps:

Get-TransportRule "Test Rule" |
    ForEach-Object{
        [PSCustomObject]@{
            "Domain(s)" = (Select-Object -ExpandProperty ExceptIfRecipientDomainIs) -join ";"
            # Or this:
            # "Domain(s)" = (Select-Object -ExpandProperty ExceptIfRecipientDomainIs) -Split(",") | -join ";"
            "Rule Name" = $_.Name
        }
    } | Export-CSV C:\myfile.csv -NoTypeInformation

asdf das 46 Reputation points

2021-09-11T12:05:52.75+00:00

thanks for answer.

not working on both methods :-(

This is the result. I have almost 20 domain in list but seems show only one and blank

"Domain(s)","Rule Name"
"","Test Rule"
Rich Matheisen 47,901 Reputation points

2021-09-11T14:40:21.11+00:00

As I said, I don't have an Exchange organization to work with! However you can do this: $x = Get-TransportRule "Test Rule"

Then examine the result. Since you're interested in the property "ExceptIfRecipientDomainIs" you can start by finding out its type: $x.ExceptIfRecipientDomainIs.gettype() Is it an array? if it is, they examine the type of its 1st element: $x.ExceptIfRecipientDomainIs[0].gettype()

Based on this (jj957929(v=exchg.150)) it seems to be an array (or list) of type "Word" -- I'm not sure of what that may be translated to in PowerShell, though.

However, it it turns out to be a simple array of strings, then the Select-Object cmdlet shouldn't use the "-ExpandProperty" parameter, and you should simply join the contents of the array with a semicolon as a separator.

Answer 3

Hello Asdfdas,

Export-TransportRuleCollection, This cmdlet is available in on-premises Exchange and in the cloud-based service. Some parameters and settings may be exclusive to one environment or the other.

Use the Export-TransportRuleCollection cmdlet to export the transport rules in your organization.

In your case try having a look with "ExpandProperty ExceptIfRecipientDomainIs" and in the rule name string check whether it is rightly mentioned.

To see the return types, which are also known as output types, that this cmdlet accepts, see Cmdlet Input and Output Types. If the Output Type field is blank, the cmdlet doesn't return data.

Hope this answers all your queries, if not please do repost back.
If an Answer is helpful, please click "Accept Answer" and upvote it : )

Share via

Export Transport Rule in csv with column

3 answers

TYPE System.String

Your answer