Adding field to a CMDB table

[Jamsta1912]

Hi all,

When adding a field to a CMDB table, such as cmdb_ci or cmdb_ci_netgear, I've noticed that multiple new records get created in the dictionary, one for the new field on the 'target' table and then one for a new field on each child table. But, when adding a new field to a TASK table, there is only one new entry in the dictionary, and each child table inherits use of the field on the parent. My question is, why is the behaviour different for CMDB tables?

Thank you

[Sonam Tiwari]

Hi @Jamsta1912 ,

Interesting question!
As per my knowledge, the answer is that CMDB tables are hierarchical in nature, it can have child tables. These child tables inherit the fields from the parent table. When you add a new field to a CMDB table, the new field is also added to all of the child tables and therefore you can see multiple new records in the dictionary.

For TASK tables, it works differently because TASK tables are not hierarchical so the new field is only added to the parent table. The child tables do not inherit the new field from the parent table.

[Sonam Tiwari]

Hi @Jamsta1912,

There might have been a bit of confusion in my previous comment, but I've now gained a better understanding of the concept. Big thanks to @Vigneshwaran S  for pointing out this article. Please take a look!


https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0723580