Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.