{"searchBar":{"inputPlaceholder":"Cari berdasarkan kata kunci atau ajukan pertanyaan","searchBtn":"Cari","error":"Masukkan kata kunci pencarian"}}

Selamat datang di Situs Web Schneider Electric

Selamat datang di situs web kami.

Pilih lokasi Anda

Welcome the the Schneider Electric French website. It looks like you are located in the United States, would you like to change your location?

Traduisez en francais
{"support":{"yesButton":"Ya","noButton":"Tidak","feedback":{"title":"Apa yang dapat kami lakukan untuk menjadi lebih baik?"},"submitButton":"Kirim","successMessage":"Terima kasih atas umpan balik Anda","title":"Apakah ini bermanfaat?","feedbackPercentLabel":"orang merasa bahwa ini bermanfaat","captcha":{"error":"Silakan centang kotak"}}}
FAQ Pencarian

How to Change the Comment on an Acknowledged Alarm In SPM or PME

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

Power monitoring expert (PME) 7.2.x, 8.x
Struxureware Power Monitoring (SPM) 7.0.x

SQL Server Management Studio

*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,
FROM EventLog2 WITH (NOLOCK) LEFT JOIN EventAcknowledgement WITH (NOLOCK) ON EventLogID=ID

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.