cmdb database tables

[tanya71]

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?

[DarkAvenger]

You can use the Dictionary to list the fields and their types for a table, like shown in below screen shot.

[eican]

On which release are you? In Calgary a new version of the Schema map was added which gives way more insight.

[tanya71]

we are not in calgary.   Dark, I have used dicitionary for tables and field attributes before, but did not see any menu option to export the dicitionary (table structure) or schema map as excel report .

[DarkAvenger]

In that Dictionary Entries list shown in my screen shot you can export the list to Excel as in other lists.

The steps to export a list to Excel is:

1. right-click on any column header in the list (in my screen shot it would be the red area listing the column names)

2. select Export > Excel

At least Berlin and newer versions provide this option - not sure about any earlier versions.  

[jduchock69]

Not sure if we are knocking on the same door or not, but try looking at the SYS_DB_OBJECT table either via ODBC connection or by typing it in the box above the left nav.   If you use the left nav, you have to type "SYS_DB_OBJECT.LIST"

This should give you a list of tables, their proper names, extensions, etc.  

The columns you may want put on this view before exporting it to Excel would be

- Label - common name for the table

- Name - table name as viewed by the database

- Extends Table - identifies tables that were extended

- App File - Identifies the ServiceNow application that (commonly) uses the table.

i hope this helps you get what you are looking for...