Table for Activity Stream per INC

[Earlie Thomas]

I am looking for a table that list the Activity per INC, does anyone know if this exist

[sachin_namjoshi]

Activity are stored in sys_audit table.

But, audit table is not available for reporting OOB due to performance issues.

As Admin, you can find out INC based records on sys_audit table.

Regards,

Sachin

[Brian Lancaster · Accepted solution]

There are several.  Just to name a few.  However due to the size of the tables I do not believe you can report on them.

sys_journal_field
sys_audit
sys_history_set

[Earlie Thomas]

Thank you both for the quick response, what we are trying to do may be accomplished through another way.

We have INC that come in, and the first touch is the Service Desk

- they are responsible for reassigning the INC to the right group

- we need to track, how long it takes for that group to pick up the ticket and how long to resolution from that point

Hoping for somethin OOB

[Brian Lancaster]

You should be able to do this using metric definitions or possibly Performance Analytics.