The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as 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
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
*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.
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!