Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for ServiceNow Views
| Name | Description |
| application_on_servers | The ServiceNow view application_on_servers. |
| app_engine_v1_ct_role_user | The ServiceNow view app_engine_v1_ct_role_user. |
| assoc_roles | The ServiceNow view assoc_roles. |
| change_request_metric | The ServiceNow view change_request_metric. |
| change_request_sla | The ServiceNow view change_request_sla. |
| change_task_metric | The ServiceNow view change_task_metric. |
| change_task_sla | The ServiceNow view change_task_sla. |
| change_task_time_worked | The ServiceNow view change_task_time_worked. |
| cmdb_multisource_diff_query_view | The ServiceNow view cmdb_multisource_diff_query_view. |
| cmdb_multisource_view | The ServiceNow view cmdb_multisource_view. |
| cmdb_task_chg | The ServiceNow view cmdb_task_chg. |
| cxs_relevant_doc_task | The ServiceNow view cxs_relevant_doc_task. |
| dashboard_w_permission | The ServiceNow view dashboard_w_permission. |
| diagnostics_result_view | The ServiceNow view diagnostics_result_view. |
| flow_report_chunk | The ServiceNow view flow_report_chunk. |
| incident_metric | The ServiceNow view incident_metric. |
| incident_sla | The ServiceNow view incident_sla. |
| incident_time_worked | The ServiceNow view incident_time_worked. |
| Items | Lists all catalog items. |
| kb_feedback_task_metric | The ServiceNow view kb_feedback_task_metric. |
| licensable_table | The ServiceNow view licensable_table. |
| licensed_app_usage | The ServiceNow view licensed_app_usage. |
| license_details_assoc_roles | The ServiceNow view license_details_assoc_roles. |
| notification_category_api | The ServiceNow view notification_category_api. |
| pa_widgets_stats | The ServiceNow view pa_widgets_stats. |
| priv_command_mid_server | The ServiceNow view priv_command_mid_server. |
| problem_metric | The ServiceNow view problem_metric. |
| problem_sla | The ServiceNow view problem_sla. |
| quarantined_file | The ServiceNow view quarantined_file. |
| query_based_service_basic_view | The ServiceNow view query_based_service_basic_view. |
| query_based_service_mapping | The ServiceNow view query_based_service_mapping. |
| release_feature_metric | The ServiceNow view release_feature_metric. |
| release_project_metric | The ServiceNow view release_project_metric. |
| release_task_metric | The ServiceNow view release_task_metric. |
| release_task_sla | The ServiceNow view release_task_sla. |
| report_home_details | The ServiceNow view report_home_details. |
| sc_request_metric | The ServiceNow view sc_request_metric. |
| sc_request_sla | The ServiceNow view sc_request_sla. |
| sc_req_item_metric | The ServiceNow view sc_req_item_metric. |
| sc_req_item_sla | The ServiceNow view sc_req_item_sla. |
| sc_task_metric | The ServiceNow view sc_task_metric. |
| sc_task_sla | The ServiceNow view sc_task_sla. |
| security_acl_detail | The ServiceNow view security_acl_detail. |
| sn_bm_client_recommendation_view | The ServiceNow view sn_bm_client_recommendation_view. |
| sp_page_widgets | The ServiceNow view sp_page_widgets. |
| subscribed_users_with_role | The ServiceNow view subscribed_users_with_role. |
| task_assessment_detail | The ServiceNow view task_assessment_detail. |
| upgrade_history_update_xml | The ServiceNow view upgrade_history_update_xml. |
| user_has_license_role | The ServiceNow view user_has_license_role. |
| user_role_license_role | The ServiceNow view user_role_license_role. |
| u_jhb_database_view | The ServiceNow view u_jhb_database_view. |
| wf_activity_context | The ServiceNow view wf_activity_context. |