- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2014 05:11 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2014 11:56 AM
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2014 06:18 AM
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)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2014 02:07 PM
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)?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2014 08:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2014 08:12 AM
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?