Powershell select statement

Question

forEach($subscription in Get-AzureRmSubscription) {
Select-AzureRmSubscription -SubscriptionId $subscription.Id | Out-Null
Get-AzurermVM -Status | select $subscription.Name, ResourceGroupName, Name, 
PowerState | ConvertTo-Csv -NoTypeInformation -Delimiter "|"}

I'm trying to return the results of this query, but it does not include the subscription name in the results. It shows it in the table header, but not in each line of the results. It should show it on every line, but it is blank for the first column on each row. I'm guessing this has to do with the subscription variable not being apart of the -Status properties, but it shows it in the table header?

mklement0 · Accepted Answer · 2018-07-26 23:28:27Z

3

If you want to include a fixed value as a property of the custom objects output by the
Select-Object cmdlet (select is a built-in alias), you must use a calculated property:

... | Select-Object @{ n='SubscriptionName'; e={ $subscription.Name } }, 
                    ResourceGroupName, 
                    Name, 
                    PowerState | ...

By contrast, using $subscription.Name by itself is interpreted as the name of a property to access on each input object received.

edited Jul 26, 2018 at 23:28

answered Jul 26, 2018 at 23:15

mklement0

452k68 gold badges727 silver badges986 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mklement0 Over a year ago

@Alex: My pleasure; glad to hear it was helpful.

Collectives™ on Stack Overflow

Powershell select statement

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related