How to increase the data retention for em_alert table from OOB 90 days?

Pavandeep Saini
Tera Contributor

‎01-26-2023 06:17 AM

As I understand OOB data retention for the alerts table is 90 days after the alert is closed.

 

I would like to increase that data retention for that to something like 180 days for our use case. I do understand the recommendation is to keep it 90 days so there is no performance impact.

 

Our instance does not have that many alerts and should be able to handle them for longer than 90 days.

 

Under event management properties i see options to increase the data retention for em_alert_history and em_impact_status tables but nothing for em_alerts table.

 

I also looked at the following documentation

https://docs.servicenow.com/en-US/bundle/tokyo-it-operations-management/page/product/event-managemen...

 

When i check under Automated Test Framework > Administration > Table Cleanup>em_alerts I see the Age in seconds is set to 10,368,000 which comes to roughly 120 days.

 

 

Not sure where i should be making the change to change the OOB retention for Alert table to 180 days.

  • 1,433 Views
2 REPLIES 2

Denise Taylor2
Tera Guru

‎08-08-2023 10:02 AM

You're in the right spot.  OOB, data retention for em_alert is 90 days (7,776,000 seconds).  If you want 180 days, just double that to 155,520,000 and make sure Active is set to true.

DeniseTaylor2_0-1691514000536.png

 

0 Helpfuls

Community Alums
Not applicable

‎12-12-2024 02:24 AM

@Pavandeep Saini 
Believe you have figured out the solution, though instead of increasing rendition value for property [

evt_mgmt.impact_calculation.cleanup_age_seconds.em_alert_history] and [evt_mgmt.impact_calculation.cleanup_age_seconds.em_impact_status] it would be better if you consider archival of data .

SN Docs: https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/database-rotat...

Using Data Management Policy

  1. Navigate to All > System Data Management > Data Management Policies.
  2. Select the data management policy for the table with records that you want to archive.
  3. In the Archive Rules related list, select New.

Using the Archive Rules module

  1. Navigate to All > System Archiving > Archive Rules.
  2. Select New.