Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
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

Schneider Electric Egypt and North East Africa

Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:

Need help?

  • Start here!

    Find answers now. Search for a solution on your own, or connect with one of our experts.

  • Contact Support

    Reach out to our customer care team to receive more information, technical support, assistance with complaints and more.

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Search FAQs

    Search topic-related frequently asked questions to find answers you need.

  • Contact Sales

    Start your sales inquiry online and an expert will connect with you.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Center
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.