It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Get all user actions from database between dates

zakirov_em Oct 11, 2017

Hi.
I need get all user actions from database between dates.
Tryed get some information from db, but can find only "comment" action.
Need your help.

If it not possibly, what about all user logins between dates?

1 answer

1 vote
Mizan Ali Sayed Oct 11, 2017

issue actions can be fetched from changegroup and changeitem tables

refer https://developer.atlassian.com/jiradev/jira-platform/jira-architecture/database-schema/database-change-history

zakirov_em Oct 11, 2017

Not indeed what i search. I need all informations about user actions. (change something, commit, assign) 

what about all user logins between dates?

Nic Brough [Adaptavist] Community Leader Oct 11, 2017

"all information" means you are going to have to look in many many places.

I would start by defining what you really need.  Could you explain *why* you are asking for this?  What does the end user get out of what you are doing?

zakirov_em Oct 11, 2017

there is such a task in the company. find out the user's activity, logins or actions for a specific period

Nic Brough [Adaptavist] Community Leader Oct 11, 2017

Doesn't really answer the question.

What are you specifically interested in?

Mizan Ali Sayed Oct 11, 2017

@zakirov_em , Nic is (Of course) right , there are many actions a user can perform apart from actions related to an issue , 

eg actions :

create a version,component,boards,filters,dashboards

update profile , actions on data related to add-ons , etc

So it is not feasible to have a report of all actions performed by a users .

---x-----x----

Since you asked for login details, try modifying the queries mentioned in this KB

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

1,260 views 2 13
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you