Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home New York Now Platform Administration Now Platform administration Data management

    Data management

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Data management

    Data in your instance is stored and managed according to a principled structure that administrators can view and configure. Data management functions include importing, exporting, and archiving database data and configuring fields and tables.

    Database structure

    All of the information in the instances is stored in tables, which consist of a series of records. The record in turn holds a series of fields that hold the individual bits of data and can be viewed either as a list or a form.

    Tables can be related to each other in the following ways:
    Extensions
    A table can extend another table. The table doing the extending (child class) includes all of the fields of the other table (parent class) and adds its own fields. For instance, the Incident [incident] table has all of the Task [task] table fields (because an incident is a special form of task) and has its own incident-specific tasks.
    One-to-Many
    Within a table, a field can hold a reference to a record on another table. There are three types of one-to-many relationship fields:
    • Reference Field: allow a user to select a record on a table defined by the reference field. For instance, the Caller field on the Incident table allows the user to select any record on the User table.
    • Glide List: allows a user to select multiple records on a table defined by the glide list. For instance, the Watch list field on the Incident table allows the user to select records on the User table.
    • Document ID Field: allows a user to select a record on any table in the instance. These fields are much less common, but one example is the Document field on the Translated Text [sys_translated_text] table.
    Many-to-Many
    Two tables can have a bi-directional relationship, so that the related records are visible from both tables in a related list.
    Database Views
    Two tables can be joined virtually with Database Views to enable reporting on data that might be stored over more than one table.

    Data management tools

    There are a number of tools that can help manage data within the instance.

    Schema map

    The Schema Map displays the relationships between tables visually, helping to navigate through the database structure.

    The Schema Map provides an interface for viewing the relationships between tables. The inter-table relationships it captures include many-to-many relationships, tables that extend other tables, and tables that reference other tables through reference fields.

    Data dictionary tables

    Data dictionary tables holds information that defines the database and can be accessed for information on the database schema.

    These tables hold important information on the database and its structure:

    • Tables [sys_db_object]: contains a record for each table.
    • Dictionary Entries [sys_dictionary]: contains additional details for each table and the definition for every column on each table. Each row represents either a column on a table or a table.
    • Field Labels [sys_documentation]: contains the human-readable labels and language information.
    Table cleaner

    Table cleaner automatically deletes records on certain tables to prevent data growing exponentially. Records are automatically deleted from specific tables after a specific time to deletion. Deleting these records automatically prevents the tables from growing to an unmanageable size.

    The time before a record is deleted begins on the date and time value in the tracked field. The Table Cleaner scheduled job runs the table cleaner every hour. To view the list of tables that are auto-cleaned, in the Navigator filter, type: sys_auto_flush_list.do. All records with [MatchField < (current_time - Age in seconds)] are deleted.
    • The MatchField field represents a Date/Time column in the table that you are trying to clean up.
    • The Age in seconds field represents a value in seconds.
    You can set up multiple table cleaner entries for a particular table. Performance depends on the size of the table and the conditions used. For example, if you use a custom column in a very large table that has no index on, performance is severely degraded. Performance also depends on the number of rows to be deleted.
    Note: TableCleaner does not call DBDelete.setWorkflow(). This means DBDelete objects run with workflow=false (false is the default value for a Java boolean), hence Delete business rules and workflows are not triggered.
    Table 1. Cleaned tables
    Table Tracked field Time to deletion
    sys_poll sys_created_on 1 day
    cmdb_metric sys_created_on 2 days
    ecc_agent_metric sys_created_on 30 days
    v_transaction sys_created_on 1 day
    wf_context ended 180 days
    sys_cache_flush sys_created_on 1 hour
    sys_replication_queue sys_created_on 1 day
    sysevent sys_created_on 7 days
    ecc_queue sys_created_on 30 days
    syslog sys_created_on 90 days
    sys_querystat sys_created_on 30 days
    plan_execution sys_created_on 30 days
    sys_user_session last_accessed 1 day
    sys_user_preference sys_updated_on 1 day
    sys_history_set sys_updated_on 30 days
    label_history sys_created_on 30 days
    ts_search_summary sys_created_on 30 days
    sys_cluster_message sys_created_on 1 day
    cmdb_tcp_connection sys_updated_on 30 days
    cmdb_running_process sys_updated_on 30 days

    Data management plugins

    Plugin Description
    Data Archiving Provides the ability to archive records to minimize performance issues.
    Database Rotations Provides tools for managing large tables to minimize performance issues.
    Many to Many task relations Provides the ability to define many-to-many relationships between task tables.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Data management

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Data management

      Data in your instance is stored and managed according to a principled structure that administrators can view and configure. Data management functions include importing, exporting, and archiving database data and configuring fields and tables.

      Database structure

      All of the information in the instances is stored in tables, which consist of a series of records. The record in turn holds a series of fields that hold the individual bits of data and can be viewed either as a list or a form.

      Tables can be related to each other in the following ways:
      Extensions
      A table can extend another table. The table doing the extending (child class) includes all of the fields of the other table (parent class) and adds its own fields. For instance, the Incident [incident] table has all of the Task [task] table fields (because an incident is a special form of task) and has its own incident-specific tasks.
      One-to-Many
      Within a table, a field can hold a reference to a record on another table. There are three types of one-to-many relationship fields:
      • Reference Field: allow a user to select a record on a table defined by the reference field. For instance, the Caller field on the Incident table allows the user to select any record on the User table.
      • Glide List: allows a user to select multiple records on a table defined by the glide list. For instance, the Watch list field on the Incident table allows the user to select records on the User table.
      • Document ID Field: allows a user to select a record on any table in the instance. These fields are much less common, but one example is the Document field on the Translated Text [sys_translated_text] table.
      Many-to-Many
      Two tables can have a bi-directional relationship, so that the related records are visible from both tables in a related list.
      Database Views
      Two tables can be joined virtually with Database Views to enable reporting on data that might be stored over more than one table.

      Data management tools

      There are a number of tools that can help manage data within the instance.

      Schema map

      The Schema Map displays the relationships between tables visually, helping to navigate through the database structure.

      The Schema Map provides an interface for viewing the relationships between tables. The inter-table relationships it captures include many-to-many relationships, tables that extend other tables, and tables that reference other tables through reference fields.

      Data dictionary tables

      Data dictionary tables holds information that defines the database and can be accessed for information on the database schema.

      These tables hold important information on the database and its structure:

      • Tables [sys_db_object]: contains a record for each table.
      • Dictionary Entries [sys_dictionary]: contains additional details for each table and the definition for every column on each table. Each row represents either a column on a table or a table.
      • Field Labels [sys_documentation]: contains the human-readable labels and language information.
      Table cleaner

      Table cleaner automatically deletes records on certain tables to prevent data growing exponentially. Records are automatically deleted from specific tables after a specific time to deletion. Deleting these records automatically prevents the tables from growing to an unmanageable size.

      The time before a record is deleted begins on the date and time value in the tracked field. The Table Cleaner scheduled job runs the table cleaner every hour. To view the list of tables that are auto-cleaned, in the Navigator filter, type: sys_auto_flush_list.do. All records with [MatchField < (current_time - Age in seconds)] are deleted.
      • The MatchField field represents a Date/Time column in the table that you are trying to clean up.
      • The Age in seconds field represents a value in seconds.
      You can set up multiple table cleaner entries for a particular table. Performance depends on the size of the table and the conditions used. For example, if you use a custom column in a very large table that has no index on, performance is severely degraded. Performance also depends on the number of rows to be deleted.
      Note: TableCleaner does not call DBDelete.setWorkflow(). This means DBDelete objects run with workflow=false (false is the default value for a Java boolean), hence Delete business rules and workflows are not triggered.
      Table 1. Cleaned tables
      Table Tracked field Time to deletion
      sys_poll sys_created_on 1 day
      cmdb_metric sys_created_on 2 days
      ecc_agent_metric sys_created_on 30 days
      v_transaction sys_created_on 1 day
      wf_context ended 180 days
      sys_cache_flush sys_created_on 1 hour
      sys_replication_queue sys_created_on 1 day
      sysevent sys_created_on 7 days
      ecc_queue sys_created_on 30 days
      syslog sys_created_on 90 days
      sys_querystat sys_created_on 30 days
      plan_execution sys_created_on 30 days
      sys_user_session last_accessed 1 day
      sys_user_preference sys_updated_on 1 day
      sys_history_set sys_updated_on 30 days
      label_history sys_created_on 30 days
      ts_search_summary sys_created_on 30 days
      sys_cluster_message sys_created_on 1 day
      cmdb_tcp_connection sys_updated_on 30 days
      cmdb_running_process sys_updated_on 30 days

      Data management plugins

      Plugin Description
      Data Archiving Provides the ability to archive records to minimize performance issues.
      Database Rotations Provides tools for managing large tables to minimize performance issues.
      Many to Many task relations Provides the ability to define many-to-many relationships between task tables.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login