How to create a report from the Record History table

[karlo_goit]

Hi Team,

I want to build a report for Incidents, i need to show the transitions of Incident_Status

For all the incidents that were created in 2018

This is the information I want to get in the Report (In a single query for all incidents)

And I need to know how long it was in each incident_status

[Mike Patel]

You will not see table name in report since it’s blocked by purpose. It’s not recommended to run reports in history table.

[karlo_goit]

So how can I get the query I want?

any suggestions?

[Prabjoth Saimbh · Accepted solution]

Try this;

https://<your_instance>.service-now.com/sys_history_line_list.do?sysparm_query=fieldSTARTSWITHincident_state%5Esys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()&sysparm_first_row=1

That is a filtered view but you can modify it.

If you right click one of the columns you can create a bar chart or pie chart and then modify the type of report and build your own.

Thanks,

Prabz

[Vijay Baokar]

Hi Prabjoth,

This was really helpful but how can we do the same for users whose city changed from A to B.