In SAS® Fraud Management Rules Studio, you can view the Rule History. The versions of the rule that you select are displayed.
Here is an example:
However, there are two scenarios where some deployment information might be missing from the Rule History.
To get the complete rule history, you can run a query in the FCMCORE database. Below is an example of getting the history of the 50100 rule in the Oracle database.
select * from
(
select r.rule_name,
r.rule_version_nbr,
r.base_rule_id,
r.rule_id,
n.note_type,
n.note_text,
n.create_user,
n.create_timestamp
from fcm_rule_note n inner join fcm_rule r on n.rule_id=r.rule_id
where base_rule_id= 50100 and r.logical_del_ind='0'
union
select r.rule_name,
r.rule_version_nbr,
r.base_rule_id,
bp.rule_id,
'Deployed' as note_type,
'Deployed to package #'|| b.build_id as note_text,
bp.create_user,
bp.create_timestamp
from fcm_build b, fcm_build_package bp, fcm_rule r
where bp.rule_id = r.rule_id and b.build_id = bp.build_id and r.base_rule_id = 50100
)
order by create_timestamp desc;