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
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.