Issue:
A user would like to know where the sources are stored for the Alarm Configuration tool within PME.
Product Line:
Power Monitoring Expert 8.0
Power Monitoring Expert 8.1
Environment:
Alarm Configuration tool
Resolution:
The alarm sources are stored within the Application Modules database and can be viewed through SQL Management Studio using the query below. It is recommended to modify the source and measurement selection only through the Alarm Configurator tool. Modifying the database table entries directly within SQL Management Studio can produce unexpected behavior and, potentially, render the system inoperable.
SELECT * FROM [ApplicationModules].[Configuration].[ConfigurationSettings] WHERE ItemType = 'Data Processor' AND Item = 'Alarm Rule'
*Note: After PME 8.1 the way this data is stored in SQL has been restructured and this query will no longer be applicable
A user would like to know where the sources are stored for the Alarm Configuration tool within PME.
Product Line:
Power Monitoring Expert 8.0
Power Monitoring Expert 8.1
Environment:
Alarm Configuration tool
Resolution:
The alarm sources are stored within the Application Modules database and can be viewed through SQL Management Studio using the query below. It is recommended to modify the source and measurement selection only through the Alarm Configurator tool. Modifying the database table entries directly within SQL Management Studio can produce unexpected behavior and, potentially, render the system inoperable.
SELECT * FROM [ApplicationModules].[Configuration].[ConfigurationSettings] WHERE ItemType = 'Data Processor' AND Item = 'Alarm Rule'
*Note: After PME 8.1 the way this data is stored in SQL has been restructured and this query will no longer be applicable
Released for:Schneider Electric Ireland
Issue:
A user would like to know where the sources are stored for the Alarm Configuration tool within PME.
Product Line:
Power Monitoring Expert 8.0
Power Monitoring Expert 8.1
Environment:
Alarm Configuration tool
Resolution:
The alarm sources are stored within the Application Modules database and can be viewed through SQL Management Studio using the query below. It is recommended to modify the source and measurement selection only through the Alarm Configurator tool. Modifying the database table entries directly within SQL Management Studio can produce unexpected behavior and, potentially, render the system inoperable.
SELECT * FROM [ApplicationModules].[Configuration].[ConfigurationSettings] WHERE ItemType = 'Data Processor' AND Item = 'Alarm Rule'
*Note: After PME 8.1 the way this data is stored in SQL has been restructured and this query will no longer be applicable
A user would like to know where the sources are stored for the Alarm Configuration tool within PME.
Product Line:
Power Monitoring Expert 8.0
Power Monitoring Expert 8.1
Environment:
Alarm Configuration tool
Resolution:
The alarm sources are stored within the Application Modules database and can be viewed through SQL Management Studio using the query below. It is recommended to modify the source and measurement selection only through the Alarm Configurator tool. Modifying the database table entries directly within SQL Management Studio can produce unexpected behavior and, potentially, render the system inoperable.
SELECT * FROM [ApplicationModules].[Configuration].[ConfigurationSettings] WHERE ItemType = 'Data Processor' AND Item = 'Alarm Rule'
*Note: After PME 8.1 the way this data is stored in SQL has been restructured and this query will no longer be applicable
Released for:Schneider Electric Ireland
