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 Belgium

Users group

Discuss this topic with experts

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

Need help?

Need help?

Get a Quote

Get a Quote

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

Where to buy?

Where to buy?

Easily find the nearest Schneider Electric distributor in your location.

Help Center

Help Center

Find support resources for all your needs, in one place.

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