MS Dynamics AX 2012 R2 :: Determine which model(s) an element is in.

GetAxElementModelInfo.sql

use AX2012Db_Model
go

select l.Name LayerName
, mm.Name ModelName 
, me.Name ElementName
from Model m
inner join Layer l on l.Id = m.LayerId
inner join ModelManifest mm on mm.ModelId = m.Id
inner join ModelElementData med on med.ModelId = m.id
inner join ModelElement me on me.ElementHandle = med.ElementHandle
where me.Name = 'VendTable'
and me.ELEMENTTYPE in 
(
	select ElementType 
	from ElementTypes 
	where TreeNodeName = '\Data Dictionary\Tables'
)