{}

我們的品牌

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

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

歡迎訪問我們的網站
搜尋常見問題
How to display only active alarms in Vista or Diagrams for export
Issue
User wants a list of all current active alarms that can be exported to excel

Product
StruxureWare Power Monitoring (SPM) 7.0.x
Power Monitoring Expert (PME) 7.2.x, 8.x

Environment
Vista and Web Diagrams

Resolution

1) Open Vista and select a current diagram or create a new diagram

2) With the diagram toolbox open, drag and drop a new datalog viewer object

3) Setup the datalog viewer and edit the query and copy and paste the following query.

SELECT [SourceName]
,[SourceType]
,dbo.DateAsUnix(TimestampUTC)  AS timestamp
,[Priority]
,[Cause]
,[CauseValue]
,[Effect]
,[EffectValue]
,[AckTimeUTC]
,[AckUserName]
,[AckRemark]
FROM [ION_Data].[dbo].[vAlarmLog]
where endID is null and (not type = 0) and priority > 64
order by timestamputc desc

4) Save the diagram and open datalog viewer in Vista or web diagram

5) Copy the contents of the table to excel

施耐德電機Taiwan