2 Replies Latest reply on Feb 9, 2016 9:18 PM by bwilson55

    Query for all Excluded Attributes

    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