Powershell format date/time into Go or Unix

mattroell · 2020-05-07T18:47:02.000Z

I’m using powershell to get when users password will expire, which will be exported to a csv file and then parsed and written to influx.

Here is what I have at the moment:

Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties "DisplayName", "msDS-UserPasswordExpiryTimeComputed" |
Select-Object -Property "Displayname",@{Name="ExpiryDate";Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed").ToString("yyyy-MM-MMTHH:mm:ssZK")}} | export-csv C:\telegraf\csv\useracctexpire.csv

Here is the result:

#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser
“Displayname”,“ExpiryDate”
“FirstName LastName”,“2020-07-07T08:39:00Z-05:00”

The ExpiryDate is not in the correct format, I’ve been playing around trying to get it either into Go or Unix, and it’s not there just yet.

Neally · 2020-05-07T18:50:40.000Z

Welcome!

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2020-05-07T18:53:55.000Z

When you use ‘export-csv’ you can use the paramter ‘-NoTypeInformation’ that will get rid of the first line.

export-csv "C:\telegraf\csv\useracctexpire.csv"

#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser
"Displayname","ExpiryDate"
"FirstName LastName","2020-07-07T08:39:00Z-05:00"

# vs
export-csv "C:\telegraf\csv\useracctexpire.csv" -notypeinformation

"Displayname","ExpiryDate"
"FirstName LastName","2020-07-07T08:39:00Z-05:00"

Neally · 2020-05-07T18:54:37.000Z

mattroell:

The ExpiryDate is not in the correct format
“2020-07-07T08:39:00Z-05:00”

well, what format do you want it to be in?

mattroell · 2020-05-07T18:57:01.000Z

It needs to be in either Go or Unix

Neally · 2020-05-07T18:58:08.000Z

mattroell:

It needs to be in either Go or Unix

That makes no sense. What format is ‘Go’ or ‘Unix’

Can you give a sample what you want it to look like?

mattroell · 2020-05-07T19:01:22.000Z

Sorry about that

Go: 2006-01-02T15:04:05Z07:00

Unix: 1588860000

Does that help?

Neally · 2020-05-07T19:12:24.000Z

mattroell:

Sorry about that

Go: 2006-01-02T15:04:05Z07:00

Unix: 1588860000

Does that help?

yes.
epoch unix time would be like so:

$epoch = [Math]::Floor([decimal](Get-Date(Get-Date).ToUniversalTime()-uformat "%s"))
$epoch

so this in theory:
also keep UTC and timezones in mind.

Get-ADUser -filter "Enabled -eq 'true' -and PasswordNeverExpires -eq 'False'" –Properties "DisplayName", "msDS-UserPasswordExpiryTimeComputed" |
Select-Object -Property "Displayname",
@{Name="ExpiryDate";Expression={[Math]::Floor([decimal](Get-Date([datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")).ToUniversalTime()-uformat "%s"))}} |
export-csv "C:\telegraf\csv\useracctexpire.csv" -NoTypeInformation

mattroell · 2020-05-07T19:26:39.000Z

That’s exactly what I’m looking for, thank you for all your help.