How to Change the Comment on an Acknowledged Alarm In SPM 7.0.X or PME 7.2.X & 8.X

Issue
User wants to change the comments assigned to an acknowledged alarm in the Active Alarm Viewer

Product
Struxureware Power Monitoring (SPM) 7.0.x

Power monitoring expert (PME) 7.2.x,

Power monitoring expert (PME) 8.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 triple x,yyy,zzz with the list of eventlog IDs found in step 3 (Triple x written due to format restrictions.)
Where eventlogId in (triple x,yyy,zzz)

5) Change the remark field to the desired message.

Publicado para: Schneider Electric Portugal