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?

[tanya71]

I used sys_db_object.list in the navigation window, but I only got two columns - table class and superclasse did not get label , name or extends table or app file as available menu column names   in the the view . Probably I will need to get the tables and field name information from the actual database?

[jduchock69]

Tanya:

After bringing up the sys_db_objects list, click the little gear in the upper right corner of the list.   This provides you with the ability to add columns to your list before exporting it to .PDF or .XL.   Once you have the list collector form up, simply move items from Available to Selected with either a double click, or highlight them and hit the arrow (shift+click selects a running list, control+click selects multiple items)

Let me know if this helps or not !

John

[jduchock69]

**   I meant upper left corner (not enough coffee this morning)

[tanya71]

thanks.should have included this in my post earlier. yes I tried personalize list column earlier, but our system did not have appfile, label , name ,extends table as listed columns under "Available" section . we only had updated by , created by and provider class as columns in that section. looks more like access or role issue, probably going to view sysdbobjects in odbc.

[jduchock69 · 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...