{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
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 India

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.