Exploring ServiceNow AI Platform tables

  • Release version: Xanadu
  • Updated August 1, 2024
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Exploring ServiceNow AI Platform tables

    The ServiceNow AI Platform® organizes data and processes using a table-based structure, essential for managing IT service management (ITSM) workflows like Incident, Problem, and CMDB. Tables can be extended to form parent-child hierarchies, enabling flexible data modeling. The platform includes pre-built tables with import and export capabilities in formats such as CSV and XML, facilitating seamless data management.

    Show full answer Show less

    Table Administration and User Roles

    Administrators play a key role in managing tables by creating custom tables, extending existing ones, and defining field properties. They also establish access controls to secure data, implement business rules, and manage table cleanup to maintain data hygiene. Administrators can view table relationships, extend core or custom tables, and handle data imports and exports to optimize platform data usage.

    Key Features

    • Table Creation and Extension: Allows creation of custom tables and extension of core or custom tables to meet specific business needs without altering original tables.
    • Access Controls: Enables restriction of table and record access to authorized users, enhancing data security.
    • Data Import/Export: Supports importing and exporting data in multiple formats for efficient data management and integration.
    • Data Dictionary and System Dictionary: Provides detailed metadata about tables, columns, and fields, helping administrators understand and manage instance data structures.
    • Table Relationships: Supports creation of references, many-to-many relationships, and database views for comprehensive data modeling and reporting.
    • Storage Aliases: Plays a role in data manipulation and field creation, important for effective data storage and retrieval.

    Benefits

    • Define complex models and entity relationships across multiple tables for robust data organization.
    • Visualize table relationships and extensions to better understand data structures.
    • Manage and maintain data efficiently by removing unused tables and creating indexes to speed data retrieval.
    • Enhance reporting capabilities by connecting tables and using database views.
    • Expand platform functionality through custom tables and applications tailored to unique business requirements.

    Next Steps

    Customers are encouraged to explore additional resources on managing tables and indexes, working with the Task table, and utilizing database views for reporting to fully leverage the capabilities of ServiceNow AI Platform tables.

    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

    Table 1. 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.

    Figure 1. Extending core tables and custom Tables
    Data can be exported and imported between Core Tables and Custom Tables. Admins define access controls to restrict access.
    1. An administrator views table relationships and learns how table extension works on the ServiceNow AI Platform®.
    2. The administrator creates a custom parent table and extends it by creating a custom child table.
    3. The administrator defines access controls to restrict access to each table.
    4. 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

    What to explore next

    To learn more about using table administration features, see: