Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,304
Community Members
 
Community Events
165
Community Groups

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
Answer accepted

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
Giuliano C. Atlassian Team Oct 17, 2012

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
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

172 views 1 3
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you