Finding active users on a particular date in Crowd

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Summary

In order to find the information about active users on a particular date in Crowd, you can run a database query to pull the data.

Environment

4.1.0+

Solution

select user_name, active, created_date from cwd_user
where user_name not in (
select aly.entity_name
from cwd_audit_log_changeset cs
join cwd_audit_log_entity aly on aly.changeset_id  = cs.id
join cwd_audit_log_entry alr on alr.changeset_id  = cs.id
where ((cs.event_type =('USER_CREATED') or (cs.event_type =('USER_UPDATED')
                                        and alr.new_value='false')))
and aly.entity_type = 'USER' and alr.property_name = 'Active'
and TO_TIMESTAMP(cs.audit_timestamp/1000 )::date >= current_date -1);



Last modified on Jul 20, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.