Looking for information on exporting user account information like, name, email address and last used date. Or the ability to run a script to produce locally.
Thank you in advance for any useful information.
Hi Bob,
one option would be to query the database directly.
Below an example that should work on mysql
Hope that helps
Cheers
Kurt
SELECT u.user_name, u.first_name, u.last_name, u.email_address
from_unixtime((cast(attribute_value AS UNSIGNED)/1000)) AS "Last Login"
FROM cwd_user u
JOIN (
SELECT DISTINCT child_name
FROM cwd_membership m
JOIN licenserolesgroup gp ON m.parent_name = gp.GROUP_ID
) AS m ON m.child_name = u.user_name
JOIN (
SELECT *
FROM cwd_user_attributes
WHERE attribute_name = 'login.lastLoginMillis'
) AS a ON a.user_id = u.id
JOIN cwd_directory d ON u.directory_id = d.id
ORDER BY "Last Login" DESC;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.