cmdb database tables

tanya71
Kilo Explorer

experts ,

help please

We are trying to map and integrate from ucmdb database CIs to ServiceNow ci tables .   what   other snow database tables we need to choose. The snow table I am reviewing currently are cmdb_ci_db_instance, cmdb_ci_db_ora_instance(for oracle) ?   what is the purpose of cmdb_ci_db_ora_catalog?

Can sysid be used as unique identifier instead of ci name for mapping in snow database tables? we use globalid on ucmdb extracts as unique key? Can sysid be used to update CI attributes of a particular CI?

1 ACCEPTED SOLUTION

Aye...   in my dev instance, i have a good 23 roles applied (10 of which are "admin" type accounts) with several of them custom, so i am not sure which role/privilege allows you to have more or less selectable columns in a list view...


View solution in original post

15 REPLIES 15

jduchock69
Giga Contributor

The Database Catalog represents an actual database within the instance.   Think of the Instance as being the "installation of Oracle" or the "installation of MSSQL" and think of the catalog as the "databases hosted by" either oracle or SQL.



A typical BSM view would look like this (REQUIRES CMDB_REL_CI TABLE USE)



DB_BSM.png



and if you wanted to do an ODBC connection query, you could start with the following:



SELECT cmdb_ci_db_catalog.name, cmdb_ci_db_catalog.sys_id, cmdb_ci_db_catalog.database_instance, cmdb_ci_db_instance.name


FROM SCHEMA.OAUSER.cmdb_ci_db_catalog cmdb_ci_db_catalog, SCHEMA.OAUSER.cmdb_ci_db_instance cmdb_ci_db_instance


WHERE cmdb_ci_db_instance.sys_id = cmdb_ci_db_catalog.database_instance



Notice that the table join uses the SYS_ID of CMDB_CI_DB_INSTANCE against the DATABASE_INSTANCE field of CMDB_CI_DB_CATALOG.



Hope this helps !



John


thank you.   how can I view all the fields in these extendable tables? looking via system definition , tables and columns also does not provide me an easier way to select , just need to scroll through the whole list . And although I am able to view from the   dictionary entry which shows multiple times the table name   , is there a view   to just look up all the fields in that table say , cmdb_ci_webserver and the field names and datatypes?


Also is there a cmdb table for active directory CI type ?   and a cmdb table for apachetomcat , I saw one table for apache only (cmdb_ci_apache)?


Go to Tables and columns, select the table you want and click on Schema map.


Once you are on the BSM map page, click on the checkboxes you see at the top.



Capture.PNG


I do not see any of those above mentioned menu options - reference tables or extended tables . I only got the schema map and zoom % option. Is there anyway we can just type the tablename somewhere and pull up the field names and field types and export it to excel?