Database view creation on sys_history_set and sys_history_line table

busireddy
Tera Contributor

Hi All, Could any one help me to join the following two tables sys_history_set and sys_history_line in database view so that we can able to full the report out of those two tables into single report.

1 REPLY 1

Musab Rasheed
Tera Sage
Tera Sage

Hello Busireddy,

This should not be done to avoid performance issue, Please go through below thread.

https://community.servicenow.com/community?id=community_question&sys_id=21354f6ddbd8dbc01dcaf3231f96195a

Also, I see you had asked similar question few months back to which reply was same. Mark my answer as correct if that helps.

https://community.servicenow.com/community?id=community_question&sys_id=c8017e631b504150d01143f6fe4bcbbc

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab