How to generate report for activity logs for incident task table

[vinzz]

Hi ,

I would like to generate report for activity logs for incident task table.

Not sure how to proceed.

Thanks

[SanjivMeher]

If you are talking about ticket activity, you should find it in sys_audit table as well as in sys_history_set table.

[vinzz]

Hi Sanjiv,

Thanks for the reply.

I have already tried to generate report on table sys_audit, but the report displays sys_id in place of number & the other values displayed are also database values, eg for state closed it displays the database value of closed as 5.

Thanks

[Tracy Davis]

The system tables are going to be huge and very hard to report against. I'd try starting with the metric tables - ex Metric_instance or create your own metric definitions to capture what you need.

Here are a couple good threads on the subject.

https://community.servicenow.com/community?id=community_question&sys_id=c6cc0329db9cdbc01dcaf3231f9619ba

https://www.reddit.com/r/servicenow/comments/5zqrt6/activity_log_question/

[Joe78man]

Is there any way to merge two tables to run a report? it's a little frustrating having to pull 3 or 4 different reports to get all the information about 1 ticket. 

I run one for response SLAs, another for resolution SLA, one for the main incident data, now another for the activity? There must be an efficient way to do this that I don't know of.

Thanks,