How to display only active alarms in Vista or Diagrams for export in PME 7 & 8?
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
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
需要協助？
產品選型工具
快速輕鬆地為您的應用找到合適的產品和附件。
取得報價
立即線上提交您的銷售需求，專業團隊將主動聯繫您。
購買地點
輕鬆在您所在地區找到最近的施耐德電機經銷商。
支援中心
在同一位置找到滿足您所有需求的支援資源。