Activity Logs Field

[Ralton Stewart]

Hello All, is there is a table in ServiceNow that stores case activity history

[Chaitanya ILCR]

Hi @Ralton Stewart ,

if audit is enabled on the case table

if you want to check the history you can go to sys_audit where "documentkey=sys_id of the case record"

or click on form header-->history --> list(only available if audit on table is enabled)(sys_history_set table)

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Ralton Stewart]

is it possible to create a report on this?

[Chaitanya ILCR]

Hi @Ralton Stewart ,

What kind of report?
what is the requirement?

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Ankur Bawiskar]

@Ralton Stewart 

Since the table is audited it's stored in sys_audit

Remember reporting on system table is not recommended as it leads to performance issue as the tables are huge in size

You can use metrics for this and use that in reporting

Metrics 

if you still want then check this link on how to allow system table for reporting

Reporting on system tables 

add "sys_audit" table to system property "glide.ui.permitted_tables"

If my response helped please mark it correct and close the thread so that it benefits future readers.