CIS-ITSM · Question #164
Given the class structure shown below which types of CIs will be included in a report run against the cmdb_ci_computer table?
The correct answer is C. Cls defined directly in cmdb_ci_compulet and all child classes. Due to ServiceNow's table inheritance model, a report on cmdb_ci_computer includes CIs from that table and all of its child/extension tables.
Question
Given the class structure shown below which types of CIs will be included in a report run against the cmdb_ci_computer table?
Exhibit
Options
- ACls defined directly in cmdb_ci_computer and all parent classes
- BJust GIs defined directly in cmdb_cl_computer
- CCls defined directly in cmdb_ci_compulet and all child classes
How the community answered
(59 responses)- A5% (3)
- B2% (1)
- C93% (55)
Why each option
Due to ServiceNow's table inheritance model, a report on cmdb_ci_computer includes CIs from that table and all of its child/extension tables.
Reports run against a table include child class records, not parent class records - querying upward to parent classes is not how ServiceNow table inheritance works for reporting.
Querying only records defined directly in cmdb_ci_computer without child class records would miss the majority of computer CIs stored in extending tables due to table inheritance.
ServiceNow uses table inheritance where child tables extend parent tables and share their records. When a report targets cmdb_ci_computer, it retrieves records stored directly in that table as well as records in all tables that extend it (child classes such as cmdb_ci_win_server or cmdb_ci_linux_server), because child table records are accessible through the parent table's view.
Concept tested: ServiceNow table inheritance impact on CMDB reporting
Source: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/table-administration/concept/c_TableHierarchy.html
Topics
Community Discussion
No community discussion yet for this question.
