Issue
User wants to change the comments assigned to an acknowledged alarm in the Active Alarm Viewer
Product
Power monitoring expert (PME) 7.2.x, 8.x
Struxureware Power Monitoring (SPM) 7.0.x
Environment
SQL Server Management Studio
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.*
1) Launch SQL Server Management Studio (SSMS) and connect to the PME instance with a user able to modify tables
2) In the object explorer navigate to Databases ->ION_Data -> Tables -> EventAcknowledgement
3) a) If user knows what eventIDs need to be modified right click on the table and select edit top 200
3) b) if user does not know the eventIDs use the query below then right click on the table and select edit top 200
Use ION_Data
SELECT TimestampUTC,
(SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=CauseID) AS cause_ion,
(SELECT String From EventString WITH (NOLOCK) WHERE ID=CauseValueID) AS cause_value,
(SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=EffectID) AS effect_ion,
(SELECT String From EventString WITH (NOLOCK) WHERE ID=EffectValueID) AS effect_value,
EventAcknowledgement.remark
FROM EventLog2 WITH (NOLOCK) LEFT JOIN EventAcknowledgement WITH (NOLOCK) ON EventLogID=ID
ORDER BY TimestampUTC DESC OPTION (FAST 50)
4) Open the SQL Pane (Ctrl+3) and add the following line in the end replacing xxx,yyy,zzz with the list of eventlog IDs found in step 3
Where eventlogId in (xxx,yyy,zzz)
5) Change the remark field to the desired message.
User wants to change the comments assigned to an acknowledged alarm in the Active Alarm Viewer
Product
Power monitoring expert (PME) 7.2.x, 8.x
Struxureware Power Monitoring (SPM) 7.0.x
Environment
SQL Server Management Studio
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.*
1) Launch SQL Server Management Studio (SSMS) and connect to the PME instance with a user able to modify tables
2) In the object explorer navigate to Databases ->ION_Data -> Tables -> EventAcknowledgement
3) a) If user knows what eventIDs need to be modified right click on the table and select edit top 200
3) b) if user does not know the eventIDs use the query below then right click on the table and select edit top 200
Use ION_Data
SELECT TimestampUTC,
(SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=CauseID) AS cause_ion,
(SELECT String From EventString WITH (NOLOCK) WHERE ID=CauseValueID) AS cause_value,
(SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=EffectID) AS effect_ion,
(SELECT String From EventString WITH (NOLOCK) WHERE ID=EffectValueID) AS effect_value,
EventAcknowledgement.remark
FROM EventLog2 WITH (NOLOCK) LEFT JOIN EventAcknowledgement WITH (NOLOCK) ON EventLogID=ID
ORDER BY TimestampUTC DESC OPTION (FAST 50)
4) Open the SQL Pane (Ctrl+3) and add the following line in the end replacing xxx,yyy,zzz with the list of eventlog IDs found in step 3
Where eventlogId in (xxx,yyy,zzz)
5) Change the remark field to the desired message.