powershell select-object property AND expandproperty

Question

Trying to execute a Select-Object, but i can't seem to return property and a value from a key-value list property. There are 3 properties i want returned RunStart, Message and 'tableName' from this Parameters property.

I get too much with this:

|Select-Object -Property Parameters,RunStart,Message

Parameters                                    RunStart              Message
----------                                    --------              -------
{[tableName, AHROR012], [schemaName, dbo]...} 11/14/2019 5:39:06 PM Operation on target failed

But I dont get the RunStart or Message when i do this:

|Select-Object -ExpandProperty Parameters -Property tableName,RunStart,Message

Key                 Value
---                 -----
tableName           AHROR012

How do i do it to get:

Parameters.tableName                         RunStart              Message
----------                                    --------              -------
AHROR012                                      11/14/2019 5:39:06 PM Operation on target failed

THANKS!!!

instead of using `-ExpandProperty`, use a calculated property. — Lee_Dailey, Nov 15 '19 at 17:57

score 8 · Accepted Answer · edited Nov 15 '19 at 19:01

8

... | Select-Object -Property @{
      Name='ParametersTableName';
      Expression={ $_.Parameters.tableName }
    }, RunStart, Message

edited Nov 15 '19 at 19:01

mklement0

382,024
64
607
775

answered Nov 15 '19 at 18:12

Kamil

96
1

score -2 · Answer 2 · answered Oct 18 '21 at 15:14

-2

A more elegant solution would be to use a 2nd select statement:

... | select RunStart,Message -ExpandProperty Parameters | Select RunStart,Message,tableName

answered Oct 18 '21 at 15:14

NitrusCS

597
1
5
20

powershell select-object property AND expandproperty

2 Answers2