Report of HR Case Reassignment from and To

[Ariel Aharon]

Hi

I need List view should show "Reassigned from" and "Reassigned to" groups in a historical view, is that possible? I've been trying to get historical data, found audit but all I get is sys_id rather than the display value.

BUT I found a table name sys_history_line, but I cannot access it from Reports

Any help please?, thanks in advance!

[Mohith Devatte]

Hello @Ariel Aharon ,

System tables are, by default, restricted from the Reporting module.

These tables include, but are not limited to:

• Sys audit [sys_audit]
• Log [syslog]
• Transaction Log [syslog_transaction]
• Attachment [sys_attachment]
• Email [sys_email]

The reason for this is because sys_audit is typically the largest table in any instance. It is not unusual for the audit table, in even a mid-sized instance, to be several gigabytes. In a large installation, this table can be 50GB or more.

Refer this link 

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportO...

Hope this helps 

Mark my answer correct if this is helpful to you 

Thanks

[Ariel Aharon]

Thank you for taking the time to answer!

I wasn't able to use the other db's you suggested. As well I need to create a List view that looks like this:

---------------------------------------------------

=================================

|  Reassigned from    |    Reassigned To          |

----------------------------------------------------

|         HR Tier 1         |           HR Tier 2           |

|      Payroll Dept       |       HR Service Desk   |

----------------------------------------------------

Do you know if that possible in Report of List view? what table should I use for that?

[Mohith Devatte]

@Ariel Aharon i am doubting that if we can do this because if you are trying to build a report on this you might want to report on the existing cases records too and future records .So all the history of field changes are stored in sys_history_line table ans you cant report on it.

[Ariel Aharon]

@Mohith Devatte 

Is it possible to create and report over a Database View that relies on sys_history_line or sys_audit and try and do the required report?