Exploring ServiceNow AI Platform tables
Summarize
Summary of Exploring ServiceNow AI Platform tables
The ServiceNow AI Platform organizes data and processes using a robust table-based structure. It includes pre-built tables for common IT service management (ITSM) processes such as Incident, Problem, and CMDB. These tables can be extended to create parent-child relationships, allowing customization and flexibility without altering original tables. Data is fully importable and exportable in formats like CSV and XML, supporting integration and data management needs.
Show less
Table Administration and User Roles
Administrators play a critical role in managing tables by:
- Creating custom tables tailored to specific business requirements.
- Defining field properties, relationships, and access controls to secure data.
- Extending both core and custom tables while maintaining system integrity.
- Implementing business rules and cleanup policies to maintain table hygiene.
- Importing and exporting table data as needed.
Key Features and Benefits
- Model and entity relationships: Define complex data models across multiple tables.
- Data dictionary access: Visualize table structures, columns, and field labels for clarity.
- Table lifecycle management: Create, index, and delete custom tables to optimize instance data.
- Advanced relationships: Establish many-to-many relationships and join tables through database views for comprehensive reporting.
- Task data organization: Utilize the Task table to manage task-related records effectively.
Custom Tables and Extensions
Custom tables empower customers to extend the AI Platform’s functionality and develop tailored applications. Table extension allows child tables to inherit fields and records from parent tables, enabling efficient data sharing and modular design. Administrators and developers are enabled to create these extensions during table creation.
Additional Capabilities
- System dictionary: Provides a centralized view of all tables and columns in the instance, aiding in schema management.
- Storage aliases: Support data manipulation and field creation, enhancing database flexibility.
Practical Application
ServiceNow customers can leverage these capabilities to customize their data architecture, improve data governance through access controls, and facilitate complex reporting and integrations. The platform’s table management features enable scalable and maintainable data solutions aligned with organizational needs.
Applications use tables and records to manage data and processes, such as Incident, Problem, and CMDB. Tables can extend other tables, creating parent tables and child tables.
Table administration overview
The ServiceNow AI Platform® uses a table-based data structure to store and organize information. Pre-built tables are included for common IT service management (ITSM) processes, with their data fully importable and exportable in CSV, XML, or other formats.
Table administration users
| User | Description |
|---|---|
| Administrator | Admins can create custom tables for specific business requirements, define field properties, create relationships between tables, and extend existing tables without modifying the originals. Administrators also define access controls to allow only approved user access to records, business rules for various tasks, and table cleanup policies for unused and outdated records. |
Table administration workflow
This infographic depicts how an administrator can extend both core tables and custom tables.
- An administrator views table relationships and learns how table extension works on the ServiceNow AI Platform®.
- The administrator creates a custom parent table and extends it by creating a custom child table.
- The administrator defines access controls to restrict access to each table.
- The administrator exports and imports data to core and custom tables as needed.
Table administration benefits
| Benefit | Feature | Users |
|---|---|---|
| Define models and entity relationships across multiple tables. | Data dictionary tables | Admin |
| Access visual references for tables and their contents. | Viewing table references and extensions | Admin |
| Store records for your instance. | Create a table | Admin |
| Remove unneeded tables from your instance. | Deleting custom tables | Admin |
| Quickly find data stored in a table. | Create a table index | Admin |
| Connect a list to another list of multiple entries instead of a single field. | Create a many-to-many table relationship | Admin |
| Organize and store task-related data. | Working with the Task table | Admin |
| Connect tables for reporting purposes. | Working with database views for reporting | Admin |