The CData Excel Add-In 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 add-in 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.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating or updating schemas, managing attachments, and managing OAuth tokens.