[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-3042: ------------------------------------ [~shawkins] I can't see a dependency of a view on either foreign or virtual procedures. For models like: {code:xml} <model name="source" type="PHYSICAL"> <source name="source" translator-name="h2" connection-jndi-name="java:/h2-ds"/> <metadata type="DDL"> <![CDATA[ CREATE FOREIGN TABLE t1 (t1col string); CREATE FOREIGN PROCEDURE p2(id integer) returns table (p2col string); ]]> </metadata> </model> <model name="insideVirtualModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v1 (v1col string) AS SELECT 'a' UNION ALL SELECT 'b'; CREATE VIEW v2 (v2col string) AS SELECT v1col||'b' FROM v1; CREATE VIRTUAL PROCEDURE p1() RETURNS (p1col string) AS BEGIN SELECT v2col FROM v2; END CREATE VIEW v7 (v7col string) AS SELECT p1.p1col FROM (CALL p1())AS p1; ]]> </metadata> </model> <model name="dependentOnPhysicalModel" type="VIRTUAL"> <metadata type="DDL"> <![CDATA[ CREATE VIEW v3 (v3col string) AS SELECT t1col||'b' FROM t1; CREATE VIEW v4 (v4col string) AS SELECT p.p2col FROM (CALL p2(1)) AS p; ]]> </metadata> </model> {code} I don't get any entries in SYSADMIN.Usage for both v4 and v7 views. Shouldn't this be tracked also? The reverse relationship is tracked, I get entries for p1, referencing v2 view and column. -- This message was sent by Atlassian JIRA (v7.5.0#75005)