I have added a audit history from related list in incident form. I want to know the table name of this audit history as i need to use this table to fetch report to check complete history of a incident

[servicenow begi]

I have added a audit history from related list in incident form. I want to know the table name of this audit history as i need to use this table to fetch report to check complete history of a incident

[Chris M3]

What you are seeing on the record is the sys_history_set table.   However, it's not that simple.

This table is simply a cache of the audit history.   It's built up for records that have been viewed.   It collects its data from multiple places, but mostly from sys_auditXXXX tables.

You can not report off of these tables, and you can not report of sys_history_set as unless someone has recently viewed the record in the UI, there would be nothing there.

Can you describe more about your requirement so that we may suggest a different solution?

[Chris M3]

Sorry, as someone pointed out, it's the sys_history_line table.   sys_history_set is the parent table.   Both are still a temporary cache of recently viewed records.

[Rashmi Bansal]

Hi Shikha,

Table name is sys_history_line.

Please mark my answer correct if it solves your issue.

Thanks,

Rashmi

[Gaurav Bajaj]

Hi,

May I know the issue here? Are you not able to proceed with it?

Thanks

Gaurav