Where are Work Notes stored?

[hazyitsm]

What table(s) holds the values for the Work Notes? To keep it a little simpler, let's just say Work Notes for Incidents. So the activity feed within an individual incident shows all comments and work notes done up until now. For each entry, it shows the time stamp of the entry, who made the entry, what was updated, and the actual notes.

Where in the database can I find each individual work note (or comment) entry? I assume it has to be one or several tables that are related to the Task (Incident, ...) table. It has to be somewhere 🙂

Ultimately, I want to find a way to report on all the different users who updated each Incident, so if you know a simpler way, I'm game.

Thanks,

Dan

[hazyitsm]

It looks like everything I want is in the sys_journal_field table; but I can't determine how to relate that table with the Task table. Any ideas?

Thanks! Dan

[march]

The Element ID of the sys_journal_field table correspond to the SYS_ID of the task record.

So, if you create a database view linking your table sys_journal_field to incident through field element_id/sys_id and then you report on that DB view, you should be able to find what you are searching for.

I never tested, but this should work...

[march]

It works -> attached DB View (capture.jpg)
And the result (capture2.jpg)

[hazyitsm]

That looks perfect. I'll try it and update.