Tables
The driver models the data in ServiceNow into a list of tables that can be queried using standard SQL statements.
Generally, querying ServiceNow tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for ServiceNow Tables
| Name | Description |
| ast_contract | The ServiceNow table ast_contract. |
| ast_license_base | The ServiceNow table ast_license_base. |
| change_request | The ServiceNow table change_request. |
| cmdb_ci | The ServiceNow table cmdb_ci. |
| cmdb_metric | The ServiceNow table cmdb_metric. |
| cmn_building | The ServiceNow table cmn_building. |
| cmn_context_help | The ServiceNow table cmn_context_help. |
| cmn_cost_center | The ServiceNow table cmn_cost_center. |
| cmn_department | The ServiceNow table cmn_department. |
| cmn_location | The ServiceNow table cmn_location. |
| cmn_map_page | The ServiceNow table cmn_map_page. |
| cmn_notif_device | The ServiceNow table cmn_notif_device. |
| cmn_notif_device_variable | The ServiceNow table cmn_notif_device_variable. |
| cmn_notif_grmember | The ServiceNow table cmn_notif_grmember. |
| cmn_notif_group | The ServiceNow table cmn_notif_group. |
| cmn_notif_message | The ServiceNow table cmn_notif_message. |
| cmn_notif_service_provider | The ServiceNow table cmn_notif_service_provider. |
| cmn_other_schedule | The ServiceNow table cmn_other_schedule. |
| cmn_relative_duration | The ServiceNow table cmn_relative_duration. |
| cmn_schedule | The ServiceNow table cmn_schedule. |
| cmn_schedule_blackout | The ServiceNow table cmn_schedule_blackout. |
| cmn_schedule_condition | The ServiceNow table cmn_schedule_condition. |
| cmn_schedule_maintenance | The ServiceNow table cmn_schedule_maintenance. |
| cmn_schedule_page | The ServiceNow table cmn_schedule_page. |
| cmn_schedule_span | The ServiceNow table cmn_schedule_span. |
| cmn_timeline_page | The ServiceNow table cmn_timeline_page. |
| cmn_timeline_page_style | The ServiceNow table cmn_timeline_page_style. |
| cmn_timeline_sub_item | The ServiceNow table cmn_timeline_sub_item. |
| diagrammer_action | The ServiceNow table diagrammer_action. |
| expert_panel | The ServiceNow table expert_panel. |
| incident | Usage information for the operation incident.rsd. |
| item_option_new | The ServiceNow table item_option_new. |
| question | The ServiceNow table question. |
| sc_category | The ServiceNow table sc_category. |
| sc_cat_item | The ServiceNow table sc_cat_item. |
| sla | The ServiceNow table sla. |
| sysauto | The ServiceNow table sysauto. |
| sysauto_script | The ServiceNow table sysauto_script. |
| syslog | The ServiceNow table syslog. |
| sysrule | The ServiceNow table sysrule. |
| system_db_object | The ServiceNow table system_db_object. |
| system_dictionary | The ServiceNow table system_dictionary. |
| system_documentation | The ServiceNow table system_documentation. |
| system_import_set_row | The ServiceNow table system_import_set_row. |
| system_script_client | The ServiceNow table system_script_client. |
| system_ui_policy | The ServiceNow table system_ui_policy. |
| system_ui_policy_action | The ServiceNow table system_ui_policy_action. |
| task | The ServiceNow table task. |
| v_field_creator | The ServiceNow table v_field_creator. |