What quantities are logged in the ION_Data database for Alarm Web configuration?
Issue
PME Alarm Web Configuration does not show digital inputs or Alarms created from digital inputs do not populate within Web Applications
Product Line
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0+
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Environment
SQL Server Management Studio
Cause
The digital input needs to map to a measurement that PME can resolve.
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.*
The following query returns all the quantities being logged, including the ones in VIP.
USE ION_Data
SELECT s.Name SOURCE_NAME, r.Label RECORDER_NAME, c.Label CHANNEL_NAME, q.Name QUANTITY_NAME
FROM Source s INNER JOIN Recorder r
ON s.ID = R.SourceID INNER JOIN Channel c
ON r.ID = c.RecorderID INNER JOIN Quantity q
ON c.QuantityID = q.ID
order by s.Name, r.Label, c.Label
Below is a sample of the result set:
Publikováno pro: Schneider Electric Česká republika




Potřebujete pomoc?
Nástroj pro výběr produktů
Rychle a snadno vyhledávejte správné produkty a příslušenství pro vaše aplikace.
Získejte nabídku
Poptejte se nás online a náš lokální specialista se s vámi spojí!
Kde nakoupit?
Jednoduše najděte nejbližšího distributora výrobků Schneider Electric ve vašem okolí.
Centrum nápovědy
Zdroje podpory pro všechny své potřeby najdete na jednom místě.