Retaining 30 days of data on em_event table

[VarunArulmani]

Hi All,

I have a requirement to retain data on em_event table for more number of days. Currently we have only 5 days of data on em_event table. I am unable to find this configuration in ServiceNow. Any help is appreciated. Thanks.

I have already verified Administration -> Table cleanup. I don't see any entry for em_event table.  

Thanks,

Varun

[Vladimir Kobeti]

Hi Varun,

isn't this part of Table Cleanup procedure?

Purge status, events, and alert history

[VarunArulmani]

Nope. I have already checked it.I don't see em_event table there.

Procedure

1. Navigate to System Maintenance > Table Cleanup.
2. Shorten the retention period (in seconds) for records of the following tables:
   • Alerts [em_alert]
   • Alert History [em_alert_history]
   • Impact Status [em_impact_status]

[Vladimir Kobeti]

Do you have Data Archiving plugin active? It might happen as well that data is archived. If so, please have a look into the Archive rule table.

[VarunArulmani]

Thanks Vladimir. I just checked on our instance. Its not active

Data Archiving

1.0.0

Inactive

com.glide.auxdb