User Activity SQL Query

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

Customers ask for a query to pull all the user activity from Jira for a specific user for a specific period of time. They need the exact information that displays on the Activity tab of a user's profile, without having to click the Show More... link dozens of times.

診断

In the User Profile you can retrieve this information but it takes to much time and some times you can't find all the information if it is too old.

ソリューション

You can run the following query at your database:

select * from changeitem CI
join changegroup CG on CI.groupid = CG.id
where author = 'xxx'
and created between '2013-07-01 00:00:00' and '2013-07-31 00:00:00'

 You need to change the author from xxx to the username you want to search and adjust the period of time.

This query will list all the changes the user have made, the old value, the new value and when it was made.

最終更新日: 2016 年 2 月 23 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.