How can an admin determine when someone's password last changed in Crowd?

Hi folks, how can I tell when someone last changed their password via Crowd?

I see User > Attributes > passwordLastChanged variable, but it's unclear how to convert this into a date. For example, what does this passwordLastChanged value signify?

1331653714613

4 answers

1 accepted

2 votes
Accepted answer

Solution: Remove the last three digits from Crowd's timestamps, then visit epochconverter.com in order to determine the date.

It seems that the dates in Crowd are too long to be standard Unix time because Crowd lists the dates as 13 digits, even though Unix time willl only be 10 digits long for the next ~7,992 years. According to Giuliano, the extra three digits represent milliseconds.

So if passwordLastChanged = 1331653714613 then ...


1. Truncate to only 10 digits: 1331653714

2. Enter this into epochconverter.com

3. Results:

GMT: Tue, 13 Mar 2012 15:48:34 GMT

Your time zone: Tue Mar 13 2012 11:48:34 GMT-4

1 vote

Just to implement, you can convert this into a date through a third-party page:

http://www.onlineconversion.com/unix_time.htm

Kind Regards

Solution: remove the last three digits from Crowd's timestamps, then visit epochconverter.com in order to determine the date.

It seems that the dates in Crowd are too long to be standard Unix time because Crowd lists the dates as 13 digits, even though Unix time willl only be 10 digits long for the next ~7,992 years. According to Giuliano, the extra three digits represent milliseconds.

So if passwordLastChanged = 1331653714613 then ...

1. Truncate to 1331653714

2. Enter this into epochconverter.com

3. Results:

GMT: Tue, 13 Mar 2012 15:48:34 GMT

Your time zone: Tue Mar 13 2012 11:48:34 GMT-4

Thank you Joe for informing us of this. I was starting to get a little crazy.

Without removing the last three digits I was getting things like:

Last Successful Login : 46522-12-20 22:26:55 -0700

Once I removed the last three difits all was good.
Last Successful Login : 2014-07-21 08:19:02 -0700
What confused me was that I was using the epochconverter.comwebsite to test the numbers I was working with and it was returning proper date/time. But in my Ruby code it was not. I guess the Ruby implementation does not account for ms.
In my User Class
@lastAuthenticated = (responseHash["attributes"][1]["values"][0])[0..-4].to_i

In my method where the output is displayed

puts "Last Successful Login : " + (Time.at(user.lastAuthenticated)).to_s

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

66 views 3 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you