Skip to main content
sarah_couch
Contributor ⭐️⭐️⭐️⭐️
January 22, 2016
Question

Is there a way to report on the rules in the rules engine?

  • January 22, 2016
  • 21 replies
  • 314 views
I need to create a comprehensive report on active rules in the rules engine including what actions will result in the rule running and when the rule is scheduled. Is there a way to create such a report? I think I have to do this manually but would love it if that was not the case. 

21 replies

manu_mittal
Gainsight Employee ⭐️
Gainsight Employee ⭐️
January 22, 2016
Hi Sarah,

You can build such a report using the "Automated Alert Rules" object (Sample below). The trigger criteria is available, but the format is a tad hard to read.



Thanks,
Manu
sarah_couch
Contributor ⭐️⭐️⭐️⭐️
January 22, 2016
Thank you, Manu!
darkknight
Expert ⭐️
February 9, 2016
Where is the Rule Name? I cannot find this field in the Automated Alert Rules object.  Kinda meaningless report if I cannot display the name.
Jeff Kirkpatrick
sarah_couch
Contributor ⭐️⭐️⭐️⭐️
February 9, 2016
Hi Jeff, I couldn't find Rule Name. I ended up making my own .xls to track our rules. It was cumbersome but worth it in the end.
darkknight
Expert ⭐️
February 15, 2016
This reply was created from a merged topic originally titled Reports 2.0: Need Rule Name to be associated with Automated Alert Rules object.

Our rules database is getting difficult to keep track of, so I want to be able to run a report of all Rules that we can export.
This Community post says that the Automated Alert Rules object is the one to use, but there appears to be no 'Rule Name' field.https://community.gainsight.com/gainsight/topics/is-there-a-way-to-report-on-the-rules-in-the-rules-engine

I opened up a support ticket on this and they confirmed Rule Name is not available and the following workaround was suggested:  "For what its worth, I am in there looking at it right now and the only workaround I can see aside from creating an .xls would be if you copy and pasted the rule name to start off the description. i.e. Rule Name - Description. Still would be cumbersome though"

Cumbersome indeed.  I rather feel this to be a bug because in other objects such as Playbook, CTA, Task, the Name or Subject is available - without them you would have no idea on which instance of each you are reporting. The same should be true of every object - the field that provides the name of the object instance should be reportable.
Jeff Kirkpatrick
sundar
Expert ⭐️
February 15, 2016
Jeff & Sarah,

Am sorry that report on Automated Alert Rule object is not usable. The reason being, the object was modelled to store the part of rule info in a JSON and dump in a field. This was never designed to be a first class citizen in SFDC but just a bin of Rule info. The other part of the rule is stored in Action Templates where the config of each action is stored. We are planning to move the rule 

Bottomline, For better manageability of rules you would need an export of snapshot of all the active rules. On this, we have a enhancement in roadmap to export the snapshot of the active rules into a doc or HTML and send it via email. 

Will this enhancement address your requirement? 
darkknight
Expert ⭐️
March 12, 2016
If it includes the rule name, trigger criteria, setup action details and schedule, then yes.

Would there be a way to include information on calculated fields?
Jeff Kirkpatrick
sundar
Expert ⭐️
March 14, 2016
Yeah it would have. 

I would say the same format you see on the calc fields in verbal format will be there in the exported doc,
sundar
Expert ⭐️
May 19, 2016
You have two new fields in Automated Alert rule by the name "Last Rule Updated By" & "Last Rule Updated Date" which will have the values of who modified the rule last. Let me know if that helps. 

Context - Last modified fields gets updated whenever the scheduled rule runs so that can't be used in a meaningful way.
sundar
Expert ⭐️
October 18, 2016
To pave way for more robust and manageable rules we are moving the Rules definition from "AutomatedAlertRules" Object to MDA with our next release. Do you have any reports configured on this object and any other process dependent on this object?