Skip to main content
Question

FSM notification_log table housekeeping

  • December 2, 2024
  • 1 reply
  • 20 views

Forum|alt.badge.img+7

The notification_log table in our databse is the largest table at 4.3GB. It has been logging all notifications since 2014.

We only need perhaps 6 months of transactions in here. Does the application have any means to purge this table or is it something we would need to do in SQL?

Thanks,

Barry

1 reply

roklde
Superhero (Employee)
Forum|alt.badge.img+25
  • Superhero (Employee)
  • 735 replies
  • December 2, 2024

Hi Barry,

we have an app param to clean up the integration log. For the notification log you might either use the FSM Archive feature or use some manual clean up. More Information on the FSM Archive functionality is available in the FSM Reference Guide (under help > documentation in the Web client, for example).


Best regards
Roman​​​​​​​


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings