{}

我們的品牌

Impact-Company-Logo-English Black-01-177x54

歡迎造訪施耐德電機全球網站

歡迎訪問我們的網站
搜尋常見問題
Is there a quick way to remove all the alarm rules I have configured in the alarm configuration tool in Power Monitoring Expert 8?
Issue:
An user has several alarm rules configured in the alarm configuration tool, but does not wish to remove each alarm one by one.

Product Line:
Power Monitoring Expert 8.0

Environment:
Power Monitoring Expert Alarm Configuration Tool

Cause:
There is no option to delete all the alarm rules in one single click in the alarm configuration tool.

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. Close the Alarm Configuration Tool if you have it open.
2. Navigate to SQL Server Management Studio and log in using credentials that have the ability to modify the Application Modules database
3. Click on New Query and enter the following query:

USE ApplicationModules
Delete FROM [Configuration].[ConfigurationValue]
WHERE [ConfigurationKeyId] IN
(SELECT [Id]
FROM [Configuration].[ConfigurationKey]
WHERE [ConfigurationItemId]=
(SELECT [Id]
FROM [Configuration].[ConfigurationItem]
WHERE [ItemIdentifier]='Alarm Rule') );

Delete FROM [Configuration].[ConfigurationKey]
WHERE [ConfigurationItemId]=
(SELECT [Id]
FROM [Configuration].[ConfigurationItem]
WHERE [ItemIdentifier]='Alarm Rule');
GO
4. Reopen the Alarm Configuration Tool to find no alarm rules that are configured.

施耐德電機Taiwan

探索更多
系列:
可能有幫助的文章
探索更多
系列: