Powershell Select-Object and Alter Property Names when modifying values

Question

I have a Cmdlet Get-AdUser that I am piping to a select object and in that select running a function on the AccountExpires property to convert the Property Value to a date value.

My question is when the object is output the column heading is no longer friendly and inherits the function used to return the new value. How do I form the statement so a friendly name is output? Was hoping to not have to assemble my own PSObject.

Get-AdUser "some.account" -Properties AccountExpires | select Enabled, Name, $({[datetime]$d =$_.AccountExpires; ConvertTo-Date($d)})

I then get a resulting table header of...

Enabled       True       [datetime]$d =$_.AccountExpires; ConvertTo-Date($d)
-------       -----      ----------------------------------------------------

HighlyUnavailable · Accepted Answer · 2014-03-11 05:34:47Z

2

Use an expression hashtable of @{E={scriptblock};L="Label"}.

select Enabled, Name, @{E={$({[datetime]$d =$_.AccountExpires; ConvertTo-Date($d)})};L="AccountExpires"}

See http://technet.microsoft.com/en-us/library/ee692794.aspx for more information on creating custom selected objects.

answered Mar 11, 2014 at 5:34

HighlyUnavailable

1,0028 silver badges14 bronze badges

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

1 Comment

ATek Over a year ago

The change was to minimal for me to edit but I had to modify the statement slightly. Was exactly what I was looking for. Thanks much! Select-Object SamAccountName, Name, @{E={[datetime]$d =$_.AccountExpires; ConvertTo-Date($d)};L="AccountExpires"}

Collectives™ on Stack Overflow

Powershell Select-Object and Alter Property Names when modifying values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related