Views
The provider exposes the ServiceNow database views as views only if the IncludeDatabaseViews connection property is set to True.
The metadata for the views in ServiceNow is obtained during runtime based on a number of predefined schemas from ServiceNow and your unique ServiceNow account information. The following list is a sample of the views available in the ServiceNow development environment, which models the core ServiceNow system.
The following data dictionary tables define the structure of the database views:
- system_db_view: This contains information about each view, one row per view.
- sys_db_view_table: This defines all source tables that each view contains.
- sys_db_view_table_field: This defines all source table fields exposed for each view.
- system_dictionary: This defines every table field in the system.
- system_documentation: This contains the human-readable labels and language information for every field of every view in the database.
CData ADO.NET Provider for ServiceNow Views
| Name | Description |
| application_on_servers | Lists applications deployed across servers, helping track software distribution and server utilization in ServiceNow. |
| app_engine_v1_ct_role_user | Shows user-role assignments within the App Engine, identifying which users hold specific contextual roles. |
| assoc_roles | Displays associations between users and roles to support access management and role-based permissions analysis. |
| change_request_metric | Aggregates performance metrics for change requests, such as resolution times and Service Level Agreement (SLA) compliance. |
| change_request_sla | Tracks Service Level Agreement (SLA) performance for change requests to measure timeliness and service quality. |
| change_task_metric | Provides statistics for change tasks, including completion times and workflow efficiency indicators. |
| change_task_sla | Displays Service Level Agreement (SLA) data for individual change tasks to help monitor compliance and response speed. |
| change_task_time_worked | Logs the amount of time spent by technicians or teams on change tasks for performance tracking. |
| cmdb_multisource_diff_query_view | Highlights discrepancies between configuration data from multiple sources to support data reconciliation. |
| cmdb_multisource_view | Consolidates configuration data from multiple sources into a unified view for analysis and reporting. |
| cmdb_task_chg | Links Configuration Management Database (CMDB) tasks to related change requests to track dependencies and assess impact. |
| cxs_relevant_doc_task | Links customer experience documents with related tasks to help users locate relevant materials. |
| dashboard_w_permission | Displays dashboards with their associated user permissions for visibility management. |
| diagnostics_result_view | Provides diagnostic results from system health checks and performance tests. |
| flow_report_chunk | Contains segmented flow reporting data that supports partial aggregation of workflow metrics. |
| incident_metric | Provides metrics for incidents, including resolution times, reopen rates, and Service Level Agreement (SLA) performance. |
| incident_sla | Tracks Service Level Agreement (SLA) compliance for incidents to ensure response and resolution targets are met. |
| incident_time_worked | Logs time spent by support agents on incidents to measure workload and efficiency. |
| Items | Lists all catalog items available in the Service Catalog (SC), including names, categories, and availability. |
| kb_feedback_task_metric | Summarizes feedback metrics for Knowledge Base (KB) tasks, such as helpfulness ratings and response counts. |
| licensable_table | Identifies tables that require licensing to help monitor usage across licensed ServiceNow apps. |
| licensed_app_usage | Reports usage statistics for licensed applications, including active users and consumption patterns. |
| license_details_assoc_roles | Links license details to associated roles to evaluate access eligibility and compliance. |
| notification_category_api | Provides notification categories in an API-friendly structure for external integration. |
| pa_widgets_stats | Provides statistics for Performance Analytics (PA) widgets used in dashboards and reports. |
| priv_command_mid_server | Lists privileged commands executed on Management, Instrumentation, and Discovery (MID) Servers for audit and compliance tracking. |
| problem_metric | Summarizes metrics for problem records, including resolution times and recurring issue trends. |
| problem_sla | Tracks Service Level Agreement (SLA) compliance for problem records to ensure service-level targets are achieved. |
| quarantined_file | Lists quarantined files identified as security risks or containing harmful content. |
| query_based_service_basic_view | Displays basic details about query-based services, including source queries and configurations. |
| query_based_service_mapping | Maps query-based services to their related components or dependencies. |
| release_feature_metric | Aggregates metrics for release features, including delivery progress and success rates. |
| release_project_metric | Provides performance indicators for release projects, such as milestone achievement and completion status. |
| release_task_metric | Presents performance metrics for release tasks, including completion speed and workflow efficiency. |
| release_task_sla | Tracks the Service Level Agreement (SLA) compliance for release tasks to ensure timely delivery and quality control. |
| report_home_details | Displays report home page configurations, including layout, ownership, and accessible reports. |
| sc_request_metric | Aggregates metrics for service requests, including completion rates and fulfillment times. |
| sc_request_sla | Monitors Service Level Agreement (SLA) compliance for service requests to verify adherence to target delivery times. |
| sc_req_item_metric | Tracks metrics for individual request items, such as processing duration and approval time. |
| sc_req_item_sla | Displays Service Level Agreement (SLA) compliance details for request items in the Service Catalog (SC). |
| sc_task_metric | Provides task performance metrics for Service Catalog (SC) requests, highlighting efficiency and workload. |
| sc_task_sla | Tracks Service Level Agreement (SLA) adherence for Service Catalog (SC) tasks to ensure timely completion and quality. |
| security_acl_detail | Displays details about security Access Control List (ACL) rules, including permissions, conditions, and assigned roles. |
| sn_bm_client_recommendation_view | Provides client recommendation insights for benchmarking and process improvement. |
| sp_page_widgets | Lists widgets used on Service Portal (SP) pages to help manage and optimize content layout. |
| subscribed_users_with_role | Identifies subscribed users and their roles to support access and licensing analysis. |
| task_assessment_detail | Displays details for task assessments, including evaluator feedback and scoring criteria. |
| upgrade_history_update_xml | Lists XML updates applied during system upgrades to help track configuration changes. |
| user_has_license_role | Displays user-license role mappings to verify license allocation and compliance. |
| user_role_license_role | Maps user roles to corresponding license roles for entitlement analysis. |
| u_jhb_database_view | Provides a custom database view for Johannesburg-specific ServiceNow configurations. |
| wf_activity_context | Displays workflow activity contexts, showing relationships between workflow steps and runtime data. |