Notifications

260 views

Description

Overview

While working with Database discovery, we can observe the application navigator have 3 visibilities for Database  

  • Navigator >> Configuration >> Database Servers 
  • Navigator >> Configuration >> Database Instances  
  • Navigator >> Configuration >> Database Catalogs

Once after a successful discovery, the expectation is to have the Database entries to "Database Servers" respective to their classification as below.

Clicking any of the types of databases listed in the image above (for example "Navigator >> Configuration >> Database Servers >> MSSQL") will take you to "cmdb_ci_database"  and might not contain records even after a successful Discovery.

Cause

The "cmdb_ci_database"  table is a legacy table and is not populated by Discovery or Service Mapping. It is one of the original tables which was initially created during the creation of the concept of CMDB for the platform.

After adopting the ITIL procedure, ServiceNow used the concept of "Database instances" and not "Database Servers"

Instead you will see the data in the following tables below:

  • cmdb_ci_db_instance
  • cmdb_ci_db_db2_instance
  • cmdb_ci_db_mysql_instance
  • cmdb_ci_db_mssql_instance
  • cmdb_ci_db_syb_instance 

Additional Information

  • "cmdb_ci_database" can be used for customization(If required).
  • To derive the information about the data collected and the tables populated during database discovery you can refer the Database Discovery documentation.

Article Information

Last Updated:2019-08-02 20:46:48
Published:2019-07-13
Pasted image.jpgPasted image.jpg