Convert Date to UnixTimestamp in a "Select-Object" loop. PowerShell

Question

My goal is to make a PS script that creates a CSV file with specefied domain users given name and a timestamp when that user was last modified in unix timestamp format.

I have figured out everything except how to convert the "Modified" AD Attribute value to unix timestamp and how to use that inline in the Select-Object "loop"

I have the following:

get-aduser -filter {name -like test} -property GivenName, Modified | Select-Object GivenName, Modified | Export-CSV -path C:\PS\user.csv

That gives me the following output

Test,2016-02-09 11:48:48

How do i go about doing something like this?:

...| Select-Object GivenName, Modified.convertedToUnixTimestamp() |...

Possible duplicate of How to convert Human readable timestamp to Unix timestamp by using PowerShell? — ardila
– ardila, Commented Feb 12, 2016 at 10:23
I saw something similar to that "Possible duplicate", but how do i use it inline in my oneliner? — Jack Pettersson
– Jack Pettersson, Commented Feb 12, 2016 at 10:26

Jack Pettersson · Accepted Answer · 2016-02-12 10:57:42Z

1

Found it out myself:

get-aduser -filter {name -like "Test*"} -property GivenName, Modified | Select-Object GivenName, @{name="Modified_unix";Expression={Get-Date -date $_.modified -UFormat %s}} | Export-CSV -path C:\PS\user.csv

answered Feb 12, 2016 at 10:57

Jack Pettersson

1,7164 gold badges19 silver badges30 bronze badges

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

1 Comment

Matt Over a year ago

FYI This is called a calculated property.

xXhRQ8sD2L7Z · Accepted Answer · 2016-02-12 11:04:11Z

0

Using the link in the comments, try something like this to change the property in the pipe:

... | Select-Object GivenName,@{n="unixtimestamp";e={$_.Modified -UFormat ℅s}} |...

answered Feb 12, 2016 at 11:04

xXhRQ8sD2L7Z

1,7261 gold badge14 silver badges16 bronze badges

Collectives™ on Stack Overflow

Convert Date to UnixTimestamp in a "Select-Object" loop. PowerShell

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related