Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

In what table is the "Issue Created" logged in the database?

I'm looking at the activity log for issues and only see comments in the [jiraaction] and non issue related items in the [dbo].[audit_log].     I would like to find where the [jiraeventype] system actions are logged:

ID TEMPLATE_ID NAME DESCRIPTION event_type
1 NULL Issue Created This is the 'issue created' event. jira.system.event.type
2 NULL Issue Updated This is the 'issue updated' event. jira.system.event.type
3 NULL Issue Assigned This is the 'issue assigned' event. jira.system.event.type
4 NULL Issue Resolved This is the 'issue resolved' event. jira.system.event.type
5 NULL Issue Closed This is the 'issue closed' event. jira.system.event.type
6 NULL Issue Commented This is the 'issue commented' event. jira.system.event.type
7 NULL Issue Reopened This is the 'issue reopened' event. jira.system.event.type
8 NULL Issue Deleted This is the 'issue deleted' event. jira.system.event.type
9 NULL Issue Moved This is the 'issue moved' event. jira.system.event.type
10 NULL Work Logged On Issue This is the 'work logged on issue' event. jira.system.event.type
11 NULL Work Started On Issue This is the 'work started on issue' event. jira.system.event.type
12 NULL Work Stopped On Issue This is the 'work stopped on issue' event. jira.system.event.type
13 NULL Generic Event This is the 'generic event' event. jira.system.event.type
14 NULL Issue Comment Edited This is the 'issue comment edited' event. jira.system.event.type
15 NULL Issue Worklog Updated This is the 'issue worklog updated' event. jira.system.event.type
16 NULL Issue Worklog Deleted This is the 'issue worklog deleted' event. jira.system.event.type
17 NULL Issue Comment Deleted This is the 'issue comment deleted' event. jira.system.event.type

2 answers

1 accepted

0 votes
Answer accepted

The events are not logged or stored anywhere themselves, as they're transient and not needed once they've gone out.

The changes that cause them to be fired are mostly logged, in various places, depending on what they are.

You're asking specifically about "create" - the issue that is created is the record that there was an issue creation event.  You'll find the date and time of the creation in the "created" field on the issue.  Worklog events create or update worklogs, moves and edits are in the issue history, and so-on.

Delete is not logged unless you have the audit log enabled.

OK, now I understand and get what Kian was saying.    Not what I wanted to hear but I can make that work.   Thank you both.

0 votes

Hello Chuck, 

Check out this knowledge base article for information about the JIRA change history stored in the DB.

I think there are going to be some limits. As I understand it, JIRA does not store email notifications in the DB. Nor would it store a record of deleted tickets. You may be limited in what you can pull from the DB.

Thanks.   Appreciate the assist.

Sadly, this only returns what I already have.   I'm specifically looking for the [jiraeventype] system actions.    Things like 'Issue Created', 'Issue Closed', etc....    Since they are reported on the jira issues, I cannot believe they are not in the database somewhere.

Hi 

 

Can anyone confirm in which table I can find Report Date in Jira ?

Suggest an answer

Log in or Sign up to answer
TAGS

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