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]

... maybe even month. All the ideas that had been thrown my way just seemed far too complicated, and they each had unwanted side effects. This is exactly what I'm looking for.

Thank you!

Dan

[lbr2k]

Do you know the scirpt to copy task work notes to incident work notes?