Clean-up of Subscription [sn_actsub_subobject_stream] Table

[Erik Nelson]

I've recently run into some issues with subscription notifications (example - "A new version of KB####### has been published") not triggering properly. I have a case open already trying to find a root cause and have continued to dig on my own. This has led me to diving into the Subscription table and it looks like there isn't anything that "cleans" up the data. For example, entries stay for inactive Subscribers or for no longer published versions of KB Articles.  Right now I'm working through some scheduled Flows to get at least some initial cleanup done, but is anyone aware of anything out-of-the-box that should be doing this already? Alternatively, does anyone have any best practices to share of how they're also accomplishing this?

Thanks,

Erik

[Tanushree Maiti]

Hi @Erik Nelson 

To clean up the sn_actsub_subobject_streamtable in ServiceNow, you can use the out-of-the-box Table Cleaner to automate data purging, or execute a Fix Script / Background Script for immediate, one-time bulk deletion.

BUT, as this table tracks live platform subscriptions and can accumulate historical or orphaned stream records, make sure before doing any clean up, you are doing proper impact analysis and if you delete, set proper criteria or rule condition.