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 USA

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?

Product Selector

Product Selector

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

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.

  • Help and Contact Center
  • Contact Sales
  • Find our Offices
  • Where to Buy
  • Tech Support: 877-342-5173
  • Careers
  • Company Profile
  • Investors
  • Newsroom
  • Report a Misconduct
  • Product Documentation
  • Software and Firmware
  • Product Selector
  • Product Replacement
  • DigestPLUS Online Catalogue
  • Blog
  • Events
  • Schneider Electric Community
  • Sustainability
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings