Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Power BI Connector 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. |