Finding active users on a particular date in Crowd
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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
1
2
3
4
5
6
7
8
9
10
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);Updated on March 17, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.