How to generate a list of objects with alarm redirection enabled

It might be helpful, for maintenance purposes, to have a list of objects that have the “Alarm Redirection” option enabled. Below is a query that can be used to generate such list:

SELECT

O.ID, O.FULLNAME

FROM

CALARMREDIRECTIONLIST AS R JOIN CDBOBJECT AS O ON R.ID = O.ID

ORDER BY

"FullName" ASC

Released for: Schneider Electric USA