How to join sys_history_line table with sc_task

[Gintarelissss98]

I get no results 

[Tony Chatfield1 · Accepted solution]

Hi, can you clarify your use case\business requirement, as I would suspect reporting on system audit\history data in this manner could result in performance issues.
Also, I would not recommend sys_history_set as a suitable reference for reporting, as this is not the intention of the data\table.

History sets - How are they generated - Support and Troubleshooting (servicenow.com)

What exactly are you trying to do and why?

[Gintarelissss98]

I have a request from a stakeholder to see the history of assignee changes on the catalog task tickets in the one-time report 

[Tony Chatfield1]

Hi, I would look at tracking assignee changes as a metric.

Metrics (servicenow.com)

Then if you really need to deliver details of historical assignment, run a 1 off script to populate metric instances from historical sys audit data.