Where is the list of subscribers for Report subscription in PME?
Issue:
Unable to find the list of subscribers for Report Subscription in PME
Product Line:
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment:
Power Monitoring Expert Report Subscription
SQL Server Management Studio
Cause:
Unable to find the list of subscribers for Report Subscription in Power Monitoring Expert (PME)
Resolution:
*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.*
To find the list of subscriber for report subscription, open SQL Management Studio, connect using Windows Authentication
Follow the steps below as shown on the screenshot.
1. Expand Databases
2. Expand ION_Network
3. Expand Tables
4 Find the dbo.RPT_Subscription table, right click and select top 1000 rows.