Tables

The connector models the data in ServiceNow as a list of tables in a relational database that can be queried using standard SQL statements.

CData Power BI Connector for ServiceNow Tables


Name	Description
ast_contract	Stores contract records for managed assets, including start dates, vendors, and terms of agreement.
ast_license_base	Maintains software license information such as license types, entitlements, and usage limits.
change_request	Tracks change requests, including their approval workflows, implementation details, and completion status.
cmdb_ci	Stores configuration item (CI) records representing hardware, software, and services managed in the Configuration Management Database (CMDB).
cmdb_metric	Captures metrics assessing the accuracy, completeness, and health of configuration items in the Configuration Management Database (CMDB).
cmn_building	Stores information about buildings or facilities, including addresses and related location details.
cmn_context_help	Holds context-sensitive help content that provides user guidance within ServiceNow applications.
cmn_cost_center	Manages cost center records used for tracking budgets, expenses, and departmental spending.
cmn_department	Stores departmental information such as department names, hierarchies, and assigned managers.
cmn_location	Maintains location records for offices, sites, and branches within the organization.
cmn_map_page	Defines pages used for map-based visualizations to display geographical or asset-related data.
cmn_notif_device	Stores user notification device details, such as email addresses and mobile endpoints.
cmn_notif_device_variable	Defines variables that configure notification device behavior for personalized delivery.
cmn_notif_grmember	Manages group membership for notification delivery, defining which users belong to each group.
cmn_notif_group	Stores details about notification groups used to send alerts to multiple recipients.
cmn_notif_message	Contains notification message templates, including subjects, bodies, and formats.
cmn_notif_service_provider	Stores details about external providers used for sending notifications, such as SMS or email gateways.
cmn_other_schedule	Maintains non-standard schedules, such as maintenance or on-call availability calendars.
cmn_relative_duration	Defines relative duration values used in workflow calculations and Service Level Agreement (SLA) timing.
cmn_schedule	Stores schedules that represent business hours, on-call rotations, or maintenance windows.
cmn_schedule_blackout	Defines blackout periods when scheduled activities such as maintenance or deployments cannot occur.
cmn_schedule_condition	Specifies conditions that determine when certain schedules apply based on context.
cmn_schedule_maintenance	Stores planned maintenance schedules for systems and services managed in ServiceNow.
cmn_schedule_page	Defines schedule pages that organize related schedules or calendar segments for easier management.
cmn_schedule_span	Records specific time spans within schedules, such as working hours, holidays, or exceptions.
cmn_timeline_page	Defines timeline pages used to display events or workflows along a visual timeline.
cmn_timeline_page_style	Stores style configurations for timeline pages, including color schemes and layout settings.
cmn_timeline_sub_item	Maintains sub-items displayed in timeline views, supporting nested visualization of activities.
diagrammer_action	Stores diagram actions that define transitions or behaviors within process flow diagrams.
expert_panel	Maintains expert panel data, including participant details and assigned review cases.
incident	Tracks incidents that document issues, service disruptions, or user-reported problems.
item_option_new	Defines configuration options for catalog items, enabling customized orders or service requests.
question	Stores survey or catalog questions that collect user input for requests or feedback forms.
sc_category	Defines Service Catalog (SC) categories used to group catalog items for easier navigation.
sc_cat_item	Stores catalog items offered through the Service Catalog (SC), such as products or services.
sla	Defines Service Level Agreements (SLAs) that measure and enforce service delivery commitments.
sysauto	Stores scheduled job definitions that automate recurring processes and system tasks.
sysauto_script	Contains scripted scheduled jobs that execute automated actions at defined intervals.
syslog	Logs system events, errors, and informational messages for auditing and troubleshooting.
sysrule	Stores rule definitions that drive automated logic and system behaviors.
system_db_object	Stores metadata for database objects, including tables and views in the ServiceNow schema.
system_dictionary	Contains dictionary entries that describe fields, attributes, and relationships in the data model.
system_documentation	Holds documentation text and help information for ServiceNow fields and tables.
system_import_set_row	Records data rows imported via import sets, including staging and transformation details.
system_journal_field	Stores journal entries for field-level updates, allowing audit tracking of changes over time.
system_script_client	Contains client-side script definitions that control dynamic behavior in the ServiceNow interface.
system_ui_policy	Defines user interface (UI) policies that determine field visibility, read-only status, and mandatory settings.
system_ui_policy_action	Specifies actions triggered by user interface (UI) policies, such as showing or hiding form elements.
system_user	Stores user account details, including credentials, roles, and contact information.
task	Tracks generic task records used by multiple ServiceNow applications, including incidents, problems, and changes.
v_field_creator	Stores metadata about field creation, including associated tables and data types.