RFC table having change details

RashitkumarP
Kilo Contributor

Hi All - I am looking to create a report to list out the RFC ( Request for Change ) along with change request details. I am currently using u_RFC table and its giving the required details along with Change number (Change request ) field alone. But I am interested to get Change  status, Planned Implementation Date / Time and Actual Implementation Data / time also to be displayed. So, can anyone let me me if there is any such table exist and I can reference. If not at least how can join these two table to get the desired fields in my report output. Many thanks in advance.

1 REPLY 1

stevemarkovick
Tera Contributor

When I needed to track detailed change info in ServiceNow, I found the change_request table helpful, especially when joined with task_ci and cmdb_ci for impacted CIs. For more granular logs, I also check sys_audit and sys_journal_field. A custom report pulling from these sources gave me the full lifecycle of RFCs, including approvals and implementation steps.