List of Information Steward rules from repository
Here’s the query that lists all the rules and the associated projects , tables and dimensions within the Information Steward repository.It also provide the rule created date.
Information Steward 4.2.5
SQL server 2012
select distinct t5.technical_name as Project_name ,t1.business_name as Rule_name ,t2.value as Quality_dimension ,t4.technical_name as Table_name ,t1.effective_dt as Rule_created_Date from MMT_Rule t1 join MMT_Custom_Field_Value t2 on t1.rule_id = t2.[object_id] and t2.is_current_Version = 'Y' join MMT_Relationship t3 on t1.rule_id = t3.[object_id] and user_flag1 is null and t3.relationship_subtype_cd in ( 'PRRB' ) and t3.is_current_Version = 'Y' join MMT_Data_Group t5 on t5.data_group_id = t3.container_id and t5.is_current_version = 'Y' join MMT_Data_Group t4 on t4.data_group_id = t3.related_object_id and t4.is_current_version = 'Y' where t1.is_current_Version = 'Y'