SQL query to list Layout references within Controls

The SQL query below will list the references between Controls and Layouts. The query can be run from the SQL console or directly against the Assure database.

1. Control Entity name
2. Control Point name
3. Layout name

SELECT f."CONTROL ENTITY", f."CONTROL POINT", n2.DISPLAYNAME as "LAYOUT"
FROM "RULE" n 
INNER JOIN (
SELECT DEPENDSONRULEFK, r.* 
FROM RULEDEPENDENCY rd INNER JOIN (
SELECT p.RULEFK, e.NAME as "CONTROL ENTITY", p.NAME as "CONTROL POINT" 
FROM ASSURECONTROL e 
INNER JOIN ASSURECONTROLPOINT p ON ASSURECONTROLPK=CONTROLFK
) r ON rd.RULEFK = r.RULEFK
) f on n.RULEPK = f.DEPENDSONRULEFK 
INNER JOIN RULEDEPENDENCY d on n.RULEPK = d.RULEFK
INNER JOIN "RULE" n2 on d.DEPENDSONRULEFK=n2.RULEPK
WHERE n2.RULETYPEFK = 16