AnsweredAssumed Answered

Query for all Excluded Attributes

Question asked by bwilson55 on Feb 8, 2016
Latest reply on Feb 9, 2016 by bwilson55

I am looking to query the AF model for all attributes that have been "Excluded" using the properties dropdown within Explorer.  I am using OLEDB Enterprise/SQL Commander to build the query. I cannot locate what field within AF will contain the "Excluded" property.  Currently, I have this query and need to add to it.  Anyone have any ideas?  Thanks


SELECT eh.Path, eh.Name as ElementName, ea.Name as AttributeName, ea.configstring

FROM [MER-DEV].[Asset].[ElementHierarchy] eh

INNER JOIN [MER-DEV].[Asset].[ElementAttribute] ea ON ea.ElementID = eh.ElementID