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

troyp
Giga Contributor

I know this discussion is old, but I thought this may be helpful for others trying to explore and understand the tree of extended tables in ServiceNow.   I've written a scoped application that will visually represent either the extended tables, or the referenced tables from different classes.



It is called Platform Visualization on ServiceNow Share


If you right click on filled in classes, you will see a pop-up of fields defined at that level.   Bold nodes can be clicked to expanded the extended tables from it.   And the app supports regular expression searching.