MASTER YOUR CASTLE with your new build or reno project
Enter competition

What quantities are logged in the ION_Data database for Alarm Web configuration?

FA210335

18/01/2019

Issue
PME8 Alarm Web Configuration does not show digital inputs or Alarms created from digital inputs do not populate within Web Applications

Product Line
ION Enterprise
Power Monitoring Expert 7.x.x
StruxureWare Power Monitoring Expert 8.x

Environment
SQL Server Management Studio

Cause
The DI 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: