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

[Robert_Cartwrig]

I stand corrected...I used the URL you provided when I saw a different URL in my address bar...

I do now see the chart references, but they are grayed out...

[Pradeep Sharma]

Can you try on a different column? Forex can you try on Label column

[Robert_Cartwrig]

W00t...guess I could have done that.  Just didn't occur to me that the column I clicked on would make a difference.

Of course, since posting an hour ago, I followed up with my alternate plan (custom field auto-popped with nowDateTime, and then reported on)...and I see what appears to be subsequent history tables being created, so I'd have only been reporting on one table anyhow.

But I'll try this next time I have a need...

Thanks for the help!

Regards,

Robert

[Jeffrey Siegel]

I'm looking to do the same, report on this table, but I cannot get it via direct reporting, or via the trick outlined here, i even navigated to the table using the url: https://YOURINSTANCENAME.service-now.com/sys_history_line_list.do?sysparm_query=  and i've clicked on many column headers and don't see chart options... 

[Pradeep Sharma]

The Screenshot you referred earlier was pointing to the table columns on "sys_history_line" which points to the dictionary table. That is the reason I mention you to navigate to the table directly and not table columns. I hope this helps 🙂