Our Brands

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

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
Question: How can I get a list of points linked to a particular email action within my Geo SCADA Database?

You can retrieve this information using a SQL query. Here's how:

The Query:

SELECT

O.ID,

O.FULLNAME,

R.ACTION1ID->FULLNAME

FROM

CALARMREDIRECTIONLIST AS R

JOIN

CDBOBJECT AS O ON R.ID = O.ID

WHERE

R.ACTION1ID = 5347 -- Replace 5347 with the actual Email Action ID

ORDER BY

"FullName" ASC

Note: As per the highlighted section above, replace the number 5347 with the object ID number of the email action object.

Schneider Electric Ireland

Users group

Discuss this topic with experts

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

Need help?

  • Product Selector

    Quickly and easily find the right products and accessories for your applications.

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Help Centre

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

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Find our Offices
  • Where to buy
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings