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.
- Control Entity name
- Control Point name
- 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
Comments
0 comments
Please sign in to leave a comment.