Lists of pre-Helsinki Extended CMDB plugin tables - Support and Troubleshooting

Lists of pre-Helsinki Extended CMDB plugin tables Summary .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } The attached lists on this KB are simply to help Tech Support Engineers understand what they are seeing on older instances that had the obsolete Extended CMDB plugin installed prior to the Helsinki version, when it was made obsolete.

The following attached spreadsheets are exports of the sys_db_object table, listing tables, and the tables they extend from. Most also include the Scope/Application and Package columns.

Geneva sys_db_object.xls This is an out-of-the-box install of Geneva Patch 11, with the Extended CMDB plugin. This was the last GA release this could be installed on.

Extended CMDB plugin (1.1, com.snc.extended_cmdb) installed. Helsinki upgrade sys_db_object.xlsx then upgraded to Helsinki Patch 12a. This shows that all the Extended CMDB tables do still remain as they were, even though a new Helsinki instance would not be able to install this plugin any longer. Helsinki plugins added sys_db_object.xlsx then install the 4 replacement Extended CMDB Plugins .

CMDB Mainframe (1.1, com.snc.cmdb.mainframe) CMDB Radio Category (1.1, com.snc.cmdb.radio.category) CMDB Telecom Category (1.1, com.snc.cmdb.telecom.category) CMDB Test Equipment (1.1, com.snc.cmdb.test.equipment) Jakarta Upgrade TPP sys_db_object.xlsx then upgraded to Jakarta Patch 10. This upgrade applies the Table-Per-Partition (TPP) flattening to the CMDB. Newyork upgrade sys_db_object.xlsx then upgrade to New York Patch 10. Newyork store apps sys_db_object.xlsx then install Discovery, and the 2 store applications that add extra CMDB tables.

Discovery and Service Mapping Patterns (1.0.71) CMDB CI Class Models (1.18.0) Paris upgrade sys_db_object.xlsx then upgrade to Paris Patch 4. Related Links .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } There is not much in the documentation, and it may not remain much longer, so is copied below:

CMDB and Extended CMDB (Geneva version) https://docs.servicenow.com/bundle/geneva-it-service-management/page/product/configuration_management/reference/r_CMDBAndExtendedCMDB.html

"...The separate Extended CMDB plugin includes a collection of modules for specialized configuration items, such as radio hardware, test equipment, and voice system hardware.

The Configuration Management (CMDB) plugin is automatically active for all instances. You must activate the Extended CMDB plugin to see the modules for specialized configuration items."

Configuration Management Database (CMDB) release notes (Helsinki version) https://docs.servicenow.com/bundle/helsinki-release-notes/page/release-notes/it-operations-management/r_CMDBRN.html

Extended CMDB (com.snc.extended_cmdb) plugin : Updated various table definitions to allow categorization of various extended CMDB tables within new and existing CMDB plugins. The following CMDB plugins were added:

CMDB Mainframe (com.snc.cmdb.mainframe) CMDB Radio Category (com.snc.cmdb.radio.category) CMDB Telecom Category (com.snc.cmdb.telecom.category) CMDB Test Equipment (com.snc.cmdb.test.equipment) Many of the tables from the Extended CMDB plugin were added to the core Configuration Management (CMDB) (com.snc.cmdb) plugin, or to one of the newly added plugins. The following table lists those changes: Table Label Table Name Change in Helsinki Personal Hardware cmdb_ci_personal_hardware Deleted Circuits cmdb_ci_circuits Deleted Computer Display Monitor cmdb_ci_display_monitor Deleted Personal Hardware cmdb_ci_personal_hardware Deleted Circuits cmdb_ci_circuits Deleted Computer Display Monitor cmdb_ci_display_monitor Deleted Router Hardware cmdb_ci_router_network Deleted Switch Hardware cmdb_ci_switch_network Deleted Desktop PC cmdb_ci_desktop_pc Deleted Laptop PC cmdb_ci_laptop_pc Deleted PC Peripherals cmdb_ci_peripherals_pc Deleted Rugged Laptop PC cmdb_ci_rugged_laptop_pc Deleted Workstation PC cmdb_ci_workstation_pc Deleted Converged Personal Data Assistant cmdb_ci_converged_pda_personal Deleted Personal Data Assistant cmdb_ci_pda_personal Deleted Service Account cmdb_ci_service_account Deleted IHS Web Site cmdb_ci_ihs_alias Deleted IIS Web Site cmdb_ci_iis_alias Deleted ODBC Data Source cmdb_ci_odbc_dsn Deleted Oracle Alias cmdb_ci_oracle_alias Deleted Account cmdb_ci_account Deleted CICS Region cmdb_ci_cics Deleted File Share cmdb_ci_file_share Deleted Process cmdb_ci_process Deleted Resource Bundle cmdb_ci_resource_bundle Deleted Started Task cmdb_ci_started_task Deleted Server Rack cmdb_ci_rack_server Deleted Server Terminal cmdb_ci_terminal_server Deleted High End Plotter cmdb_ci_high_end_plotter Deleted Standard Plotter cmdb_ci_standard_plotter Deleted Color Printer cmdb_ci_color_printer Deleted Standard Printer cmdb_ci_standard_printer Deleted Server Hostname cmdb_ci_server_hostname Deleted UNIX Package cmdb_ci_unix_package Deleted Content Engine cmdb_ci_ce_network Deleted Content Services Switch cmdb_ci_css_network Deleted Network Interface Shelf cmdb_ci_interface_shelf_nw Deleted Network Probe Hardware cmdb_ci_network_probe_network Deleted Network Terminal Server cmdb_ci_terminal_network Deleted Access Server Hostname cmdb_ci_access_host Deleted Content Engine Hostname cmdb_ci_ce_host Deleted CSS Hostname cmdb_ci_css_host Deleted CSU/DSU Hostname cmdb_ci_csu_dsu_host Deleted Firewall Hostname cmdb_ci_firewall_host Deleted Hub Hostname cmdb_ci_hub_host Deleted Modem Hostname cmdb_ci_modem_host Deleted Network Probe Hostname cmdb_ci_nw_probe_host Deleted Router Hostname cmdb_ci_router_host Deleted Switch Hostname cmdb_ci_switch_host Deleted UPS Hostname cmdb_ci_ups_host Deleted Wireless Access Point Hostname cmdb_ci_wap_host Deleted Server Peripherals cmdb_ci_peripherals_server Deleted LINUX Hostname cmdb_ci_linux_host Deleted UNIX Hostname cmdb_ci_unix_host Deleted VMWare Hostname cmdb_ci_vmware_host Deleted Windows Hostname cmdb_ci_windows_host Deleted Z/OS Hostname cmdb_ci_z_os_host Deleted AIX Hostname cmdb_ci_ibm_aix_host Deleted HP UNIX Hostname cmdb_ci_hp_unix_host Deleted SUN UNIX Hostname cmdb_ci_sun_unix_host Deleted Alias cmdb_ci_alias Added to Core CMDB UNIX Cluster cmdb_ci_unix_cluster Added to Core CMDB Mainframe Hardware cmdb_ci_mainframe_hardware Added to Core CMDB Personal Computer cmdb_ci_pc_hardware Added to Core CMDB Batch Job cmdb_ci_batch_job Added to Core CMDB Display Hardware cmdb_ci_display_hardware Added to Core CMDB Imaging Hardware cmdb_ci_imaging_hardware Added to Core CMDB Scanner cmdb_ci_scanner Added to Core CMDB Firewall Hardware cmdb_ci_firewall_network Added to Core CMDB Intrusion Detection System cmdb_ci_ids_network Added to Core CMDB Modem Hardware cmdb_ci_modem_network Added to Core CMDB Wireless Access Point cmdb_ci_wap_network Added to Core CMDB Server Hardware cmdb_ci_server_hardware Added to Core CMDB Network Appliance Hardware cmdb_ci_net_app_server Added to Core CMDB Server Chassis cmdb_ci_chassis_server Added to Core CMDB Server Tape Unit cmdb_ci_tape_server Added to Core CMDB Printing Hardware cmdb_ci_printing_hardware Added to Core CMDB Multi-function Printer cmdb_ci_mfp_printer Added to Core CMDB Personal Printer cmdb_ci_personal_printer Added to Core CMDB Plotter cmdb_ci_plotter Added to Core CMDB Monitoring Equipment cmdb_ci_monitoring_hardware Added to Core CMDB Network Appliance Hostname cmdb_ci_net_app_host Added to Core CMDB Network Hostname cmdb_ci_network_host Added to Core CMDB Port cmdb_ci_port Added to Core CMDB CSU/DSU cmdb_ci_csu_dsu_network Added to Core CMDB FDDI Cards cmdb_ci_fddi_network Added to Core CMDB Hub Hardware cmdb_ci_hub_network Added to Core CMDB WAN Accelerator cmdb_ci_wan_accel_network Added to Core CMDB DNS Alias cmdb_ci_dns_alias Added to Core CMDB Logical Partition cmdb_ci_lpar Added to Core CMDB Mainframe Printer cmdb_ci_mainframe_printer Added to Mainframe Mainframe Controller cmdb_ci_controller_mainframe Added to Mainframe Mainframe CPU cmdb_ci_cpu_mainframe Added to Mainframe Mainframe DASD cmdb_ci_dasd_mainframe Added to Mainframe Mainframe Memory cmdb_ci_memory_mainframe Added to Mainframe Mainframe Peripheral cmdb_ci_peripheral_mainframe Added to Mainframe Mainframe Tape Unit cmdb_ci_tape_mainframe Added to Mainframe Mainframe Terminal cmdb_ci_terminal_mainframe Added to Mainframe Radio Hardware cmdb_ci_radio_hardware Added to Radio Category Antenna cmdb_ci_antenna_radio Added to Radio Category Conventional Radio cmdb_ci_conventional_radio Added to Radio Category Feed Line cmdb_ci_feedline_radio Added to Radio Category Microwave Radio cmdb_ci_microwave_radio Added to Radio Category Mobile Radio cmdb_ci_mobile_radio Added to Radio Category Multiple Address Systems Radio cmdb_ci_mas_radio Added to Radio Category Portable Radio cmdb_ci_portable_radio Added to Radio Category Radio Console cmdb_ci_console_radio Added to Radio Category Radio Control Station cmdb_ci_control_station_radio Added to Radio Category Repeater Radio cmdb_ci_repeater_radio Added to Radio Category Trunking Radio cmdb_ci_trunking_radio Added to Radio Category Unlicensed Microwave Radio cmdb_ci_unlicensed_radio Added to Radio Category Telecommunications Hardware cmdb_ci_telecom_hardware Added to Telecom Category Transport Hardware cmdb_ci_transport_hardware Added to Telecom Category Voice System Hardware cmdb_ci_voice_hardware Added to Telecom Category Fiber Optic Terminal Equipment cmdb_ci_fote_transport Added to Telecom Category Optical Multiplexer cmdb_ci_omux_transport Added to Telecom Category Channel Bank cmdb_ci_channel_bank_transport Added to Telecom Category Digital Access Cross Connects cmdb_ci_dacs_transport Added to Telecom Category Fiber Optic Equipment cmdb_ci_optical_transport Added to Telecom Category Frame Relay Access Device cmdb_ci_frad_transport Added to Telecom Category Multiplexer cmdb_ci_mux_transport Added to Telecom Category Transport Interface Shelf cmdb_ci_iface_shelf_transport Added to Telecom Category Transport Terminal Server cmdb_ci_terminal_transport Added to Telecom Category Key Telephone System cmdb_ci_key_system_voice Added to Telecom Category Private Branch Exchange cmdb_ci_pbx_voice Added to Telecom Category Voicemail cmdb_ci_voicemail_voice Added to Telecom Category Test Equipment cmdb_ci_test_eq_hardware Added to Test Equipment Audio Test Set cmdb_ci_audio_test_eq Added to Test Equipment Battery Analyzer cmdb_ci_battery_azer_test_eq Added to Test Equipment Bit Error Rate Test Set cmdb_ci_ber_test_eq Added to Test Equipment Communications Analyzer cmdb_ci_comm_anaylzer_test_eq Added to Test Equipment Data Error Analyzer cmdb_ci_data_anaylzer_test_eq Added to Test Equipment DS1 Test Set cmdb_ci_ds1_test_eq Added to Test Equipment DS1/DS3 Test Set cmdb_ci_ds1_ds3_test_eq Added to Test Equipment DS1/DS3/OC3 Test Set cmdb_ci_ds1_ds3_oc3_test_eq Added to Test Equipment DS3 Test Set cmdb_ci_ds3_test_eq Added to Test Equipment Frequency Counter cmdb_ci_freq_counter_test_eq Added to Test Equipment Frequency Selective Levelmeter cmdb_ci_freq_meter_test_eq Added to Test Equipment ISDN Test Set cmdb_ci_isdn_test_eq Added to Test Equipment Microwave Frequency Counter cmdb_ci_mw_freq_cntr_test_eq Added to Test Equipment Microwave Test Set cmdb_ci_mw_test_eq Added to Test Equipment Optical Time Domain Reflectometer cmdb_ci_otdr_test_eq Added to Test Equipment Oscilloscope cmdb_ci_oscilloscope_test_eq Added to Test Equipment Power Meter cmdb_ci_power_meter_test_eq Added to Test Equipment Signal Generator cmdb_ci_signal_gen_test_eq Added to Test Equipment Spectrum Analyzer cmdb_ci_spectrum_azer_test_eq Added to Test Equipment Time Domain Reflectometer cmdb_ci_tdr_test_eq Added to Test Equipment Transmission Test Set cmdb_ci_transmission_test_eq Added to Test Equipment Wattmeter cmdb_ci_wattmeter_test_eq Added to Test Equipment sdf