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.
Released for: Schneider Electric Ireland
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.