Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Data Retention, Rotation, Cleanup and Instance Size - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Data Retention, Rotation, Cleanup and Instance Size
KB0780216

Data Retention, Rotation, Cleanup and Instance Size


39897 Views Last updated : Nov 30, 2023 public Copy Permalink English (Original)
  • English (Original)
  • Japanese
KB Summary by Now Assist

Issue

How long is record data kept within a ServiceNow Instance?
Would there be any difference between the tables such as Incident, Changes, Problems, etc.

Release

All Versions

Cause

Not applicable

Resolution

Retention and Table Rotation
Data retention and cleanup within a ServiceNow instance is managed by your instance administrators.
Records remains within the instance until removed by users or admins, either individually or in bulk via an integration / job etc.

Some tables are defined to remove data by default, on a weekly or monthly basis via 'table rotation'.
Tables using table rotation are meant to only hold a subset of transient data over time, before 'rotating' away on a pre-defined basis. Records rotated away are deleted from the instance.

System transactional (syslog) data is considered transient and removed over time to keep a rolling 8 weeks.
System Events (sys event) deletes data on a daily basis, maintaining a rolling one week of data.

Table rotation will remove data based on a defined rotation schedule.
There is another feature called 'table extension', however that retains data and auto extends data into new (smaller) table shards in the interests of performance.

You can view your table rotations (and extensions) via, Navpage > System Definition > Table Rotations
* Direct at https://__INSTANCE__.service-now.com/sys_table_rotation_list.do
* For more information see https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/platform-performance/concept/c_TableRotation.html
* Modifications to table extension and rotation can be potentially impacting.
* It is recommended to discuss any modifications with ServiceNow prior to any change.

 

 

 

Table Cleaner Removal
Data can be removed from your instance by users removing records, either individually or in bulk via filtered list etc.
ServiceNow provides a 'Table Cleaner' job that runs out of the box, removes records from a number of tables by matching filter criteria to a set of pre-defined rules.

Instance Admins can also create their own Table Cleaner rules to remove records from any table after a particular period of time - 30, 60, 90+ days and matching a set of user defined criteria.

You can view and configure Table Cleaner rules via Navpage > System Maintenance > Table Cleanup
* Direct at https://__INSTANCE__.service-now.com/sys_auto_flush_list.do
* For more information see https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/managing-data/concept/table-cleaner.html

 

 

 

 

Instance Size
Around the discussion of data retention and cleanup, is the amount of data that your instance retains.

To check on how much data your instance retains, visit Navpage > Instance Usage > Application Usage Overview.
* Within this page is 'Primary DB Size (MB) / Primary DB size of this Instance (in MB).
(Divide this number by 1000 to obtain the value in GB, or divide by 1,000,000 to obtain the amount of data consumed in TB.)
* Direct at https://__INSTANCE__.service-now.com/home.do?sysparm_view=usage_overview

There is also a service catalogue item in HI 'Database Footprint' which can be used to return the total database size & top 10 tables.

Failing the above, you can also reach out to ServiceNow Customer Support at any time to provide information on data usage within the instance (total, per table, etc).



Service Catalog for Instance Storage Usage

ServiceNow has created an automated workflow to allow customers to request the list of production and sub-production instances in a customer’s account along with storage consumption for each of the instance.

You can view this report by following these steps:

1. Navigate to the Now Support

2. Select Automation Store

3. Click on Service Catalog on the left navigation

4. Enter “Cloud” in the Search bar, and see option 'Cloud usage request'

5. Click on “Request”

For more information also see KB1532026

 


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.