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
  • 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 Catalog
  • Industries
  • Partners
  • Schneider Electric Community
  • Events
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings