Report on sys_history_line table

[Maria DeLaCruz]

Hi,

Is there a way to create a report on the sys_history_line table?   I do not see this option in the list of tables.

We have a custom table that has auditing turned on, and we'd like to have a report that shows who updated what fields on the records.

Thanks,

Maria

[Pradeep Sharma]

Hi Maria,

Please refer below link for more info.

Reporting on System Tables - ServiceNow Wiki

[Chuck Tomasi · Accepted solution]

Here's a little trick Maria...

Go to the table and right click on one of the columns and select "Bar chart" or "Pie chart".

That starts the report engine. From there you can customize and configure the report as you need.

[Maria DeLaCruz]

Thanks!

[Robert_Cartwrig]

I'm trying to do the same thing, but this trick doesn't seem to work any longer...

Got any new tricks?

Thanks,

Robert