Finding active users on a particular date in Crowd
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.
環境
4.1.0 以降
ソリューション
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);
最終更新日 2021 年 7 月 20 日
Powered by Confluence and Scroll Viewport.