Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
You will need to remove the references to the old report subscriptions from the ION_Network database.
Create a backup of the ION_Network database before proceeding
Within the ION_Network database you will find references to the old report subscriptions in the following tables
The RPT_Subscription table contains a reference to each report subscription and the associated "SubscriptionID"
The EVT_EventWatcherActionSubscription table contains the association between the "SubscriptionID" and the "EventWatcherActionID"
The EVT_EventWatcherAction table contains the association between the "EventWatcherActionID" and the "EventWatcherID"
In order to fully remove the old report subscriptions you will need to delete the references from the three tables listed above.
In the example above one would need to run the following queries in SQL against the ION_Network database.
Delete from RPT_Subscription where SubscriptionID IN(1)
Delete from EVT_EventWatcherActionSubscription where SubscriptionID IN(1)
Delete from EVT_EventWatcherAction where EventWatcherActionID IN(1)
Be sure to only delete entries associated with the old report subscriptions you wish to remove.