List of Information Steward rules from repository

[mageshwaran_subramanian]

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.

Environment

Information Steward 4.2.5

SQL server 2012

Query

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'