We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

How to fetch CMDB audit logs via Table API - which tables to query?

gurwindersi
Tera Contributor

I need to retrieve CMDB-related logs programmatically using the Table API.
I'm looking for guidance on:

  1. Which tables contain CMDB audit/change logs?
  2. What's the correct API endpoint structure?
1 REPLY 1

mmanneru
Tera Contributor

To retrieve CMDB-related logs programmatically using the ServiceNow Table API, you're essentially looking to query the tables that store audit and change history for CMDB records.

Table Names:

Sys_audit

sys_history_line

sys_history_set

cmdb_ci

Note: Audit must be enabled for the relevant CMDB tables/fields to populate sys_audit.

To retrieve all changes made to CMDB records in the last 7 days:

GET /api/now/table/sys_audit?sysparm_query=document_table=cmdb_ci^sys_created_on>=javascript:gs.daysAgoStart(7)