sys_db_object table response

rna
Kilo Explorer

List of tables API

        https://<InstanceName>/api/now/v1/table/sys_db_object  

This returns all the list of tables, But I have noticed some tables being repeating like, Label - "Import Log" , though the internal names are different, like

<name>import_log0005</name> , <name>import_log0006</name>

I checked on the "REST API Explorer" provided with my instances, But it has only 1 "Import Log" table showing in the dropdown list.

Which one of the internal table does this refer to?

And the response given by "sys_db_object" API, contains junk records? I mean if some records are to be ignored, then how do we do it?

3 REPLIES 3

Kalaiarasan Pus
Giga Sage

These are not junk records and are infact rotated tables.



Table Rotation - ServiceNow Wiki


Any field which tells me in the "sys_db_object" API response, that this table is a rotation table?


People more knowledged about this can guide you better but as per my knowledge, I dont think so there is anything on the response to indicate the rotated tables...