ServiceNow Report who changes the state

Rairai31
Giga Guru

‎08-29-2023 12:47 AM

Hi All,

 

Is it possible in ServiceNow reporting to show who has moved a ticket from New for any time period and ignore any system actions? Table is customerservice case.

 

Looking forward to all your responses. Thank you very much.

0 Helpfuls
  • 292 Views
1 REPLY 1

Karthiga S
Kilo Sage

‎08-29-2023 03:01 AM

Hi @Rairai31 

 

The table called "sys_history_line" will store all the historical changes made to data for any records. Old value, New value, and everything. You can create a report on the History line OOB table to achieve the same.

 

Also, you will not see the History line table directly in reports. Consider following the below steps:

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

KarthigaS_0-1693303214339.png

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

 

Please mark it Correct and Hit Like if you find this helpful!

 

Regards,

Karthiga

0 Helpfuls