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 New Zealand
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.