Problem Definition

When viewing user Attributes in the UI they are stored in epoch integers. While these can be converted manually with a calculator, it becomes inconvenient to convert the values if they need to be viewed regularly or frequently.

• lastActive
• lastAuthenticated
• passwordLastChanged

Suggested Solution

Display the values in real GMT or local dates next to the fields

Workaround

Following our List the Last Login Date for all Users in Crowd article, you can adjust the queries to output of each of these attributes for all users in Crowd:

• lastActive

  select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'lastActive';
  

• lastAuthenticated

  select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'lastAuthenticated';
  

• passwordLastChanged

  select cwd_user.user_name, to_timestamp(CAST(cwd_user_attribute.attribute_value as double precision)/1000) from cwd_user_attribute, cwd_user where cwd_user_attribute.user_id = cwd_user.id AND cwd_user_attribute.attribute_name = 'passwordLastChanged';