Demystifying Table cleanup sys_auto_flush - removing unwanted data

[tiagomacul]

Demystifying Table cleanup sys_auto_flush / Desmistificando a limpeza da tabela sys_auto_flush

How to use 'Table Cleanup' to delete unwanted data in ServiceNow? / Como usar 'Table Cleanup' para excluir dados indesejados no ServiceNow?

• The Table cleaner does not impact performance as it cleans the data in batches.
• • O table cleanup não afeta o desempenho, pois limpa os dados em lotes.
• Table cleanup are accessible from: ATF, Instance Scan, System Maintenance

Table Cleanup Fields

• Tablename: Identify Table Name to be cleaned / Identifique o nome da tabela a ser limpa
• Matchfield: Field based on which records will be cleaned e.g. sys_created_on
• • Campo com base no qual os registros serão limpos, por exemplo sys_created_on
• Age in seconds (age): How old records to be deleted - Enter the number in seconds - 2592000 for 30 days old records. Enter 0 in seconds if you want to delete all the records for specified condition as specified in 'Conditions'
• • Quantos registros antigos a serem excluídos - digite o número em segundos - 2592000 para registros de 30 dias. Insira 0 em segundos se desejar excluir todos os registros para a condição especificada conforme especificado em 'Condições'
• Active: Check the checkbox to active
• • Seleção de registro ativo ou inativo
• Application (sys_scope): Application scope / escopo da aplicação
• Cascade delete (cascade_delete): Check the check box to delete cascade relationships to the table
• • Delete registros relacionados
• Conditions: Add the specified filter condition or do not add it if all the records related of certain age needs to be deleted as specified in 'Age in seconds'
• • Condição de seleção dos registros, utilize o campo Age in seconds em condições de idade dos registros.

Image	Description
	01. >> System Maintenance > Table Cleanup
	alternatively 01. >> Instance Scan >Table Cleanup
	alternatively  01. >> ATF > Administration > Table cleanup
	alternatively 01. sys_auto_flush.list
	02. Click on 'New'
	03. Based upon the clean up requirements fill in the following fields accordingly
	04. Click Submit

Sample 01: syslog the last 90 days

Sample 02: wf_context the last 180 days where actice is false

Months	Days	Secs
	1	86,400
	7	604,800
	15	1.296.000
	20	1.728.000
01	30	2 592 000
03	90	7,776,000
06	180	15,552,000
12	365	31,536,000

summary

How to: Use "Table cleaner" to remove unwanted data

Increasing Service Portal log (sp_log) to more than 90-day default

Steps to mitigate the rapid growth of the table: Call Chains [sys_call_chain]

A script to automatically clean up sys_audit_delete and sys_audit_relation records

upgrades

ServiceNow versions

Demystifying table rotation, extension, and table cleaner

All the logs in ServiceNow