Notifications

68 views

Description

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

Release or Environment

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 and a list of default tables using table rotation see
https://docs.servicenow.com/bundle/newyork-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/newyork-platform-administration/page/administer/managing-data/concept/c_DataManagement.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

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).

 

 

 

Article Information

Last Updated:2020-02-07 03:43:01
Published:2019-09-27