Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Chuck Daniel April 16, 2018

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
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2018

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.

Chuck Daniel April 17, 2018

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
Kian Stack Mumo Systems
Community Champion
April 16, 2018

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.

Chuck Daniel April 16, 2018

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.

Ajay Verma February 5, 2020

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
AUG Leaders

Atlassian Community Events