Data Model
The CData ADO.NET Provider for ServiceNow models ServiceNow data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures. Live connectivity to these objects means that any changes to your ServiceNow account are immediately available. You can use the provider to work with all the tables in your account, including custom tables.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your ServiceNow account.
Commonly used tables include:
| Table | Description |
| change_request | Tracks change requests, including their approval workflows, implementation details, and completion status. |
| change_request_sla | Tracks Service Level Agreement (SLA) performance for change requests to measure timeliness and service quality. |
| change_task_sla | Displays SLA data for individual change tasks to help monitor compliance and response speed. |
| cmdb_ci | Stores configuration item (CI) records representing hardware, software, and services managed in the Configuration Management Database (CMDB). |
| 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_schedule | Stores schedules that represent business hours, on-call rotations, or maintenance windows. |
| incident | Tracks incidents that document issues, service disruptions, or user-reported problems. |
| incident_sla | Tracks SLA compliance for incidents to ensure response and resolution targets are met. |
| problem_sla | Tracks SLA compliance for problem records to ensure service-level targets are achieved. |
| 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. |
| sc_request_sla | Monitors SLA compliance for service requests to verify adherence to target delivery times. |
| sla | Defines SLAs that measure and enforce service delivery commitments. |
| 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. |
| system_dictionary | Contains dictionary entries that describe fields, attributes, and relationships in the data model. |
| 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. |
| task_assessment_detail | Displays details for task assessments, including evaluator feedback and scoring criteria. |