Question
Areteans Technology Solutions Australia Pty Ltd.
IN
Last activity: 19 Jul 2024 12:25 EDT
In which Table Pega Stores the Rules details which runs in runtime
We need to check the list of the rules which ran during running an applcation.Does Pega stores in some table?
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 19 Jul 2024 12:25 EDT
Pegasystems Inc.
GB
@Ambrish510 The solution will be a custom reporting implementation involving reporting on the audit trail. Pega Platform maintains statistics during operation which are written to the Pega Platform database for later review and analysis during application server shutdown. These statistics cover all requestors of every type, with cumulative statistics since startup. This can be helpful in identifying the most frequently and least frequently executed rules (for those rule types that are assembled using rules assembly). However, the specific table name where this information is stored is not mentioned in the provided context.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Rule usage snapshots > How it works
Note: the moderators have chased the original poster multiple times to update this post but to no avail.
If you need further help I would suggest that you contact a Pega Consulting team via your account manager for further discussion.
Aaseya IT Services Pvt Ltd
SA
pr4_rule Db contsins all the pega rules
Areteans Technology Solutions Australia Pty Ltd.
IN
This is Compile time Table entry , actually need to table name of the sequence of Pega Rules executed Runtime, Say you are running a case type.
Tata Consultancy Services
IN
Hi @CHANDANPAN,
Many of the rules stored in the pr4_rule table. Some of the rules stored in other tables too,
Could you please go throw below links, so that you will get an idea.
PegaRULES database — Tables for rules
I hope this will hle you
Thnaks,
Ashok
Updated: 11 Jan 2024 6:40 EST
Aaseya IT Services Pvt Ltd
SA
@Bhumireddy Yes, But we will have all the rules here only. There are other table like pr4_rule_xml - Which contains XML format of the rule and pr4_rule_Property which contains Propert rule.
Areteans Technology Solutions Australia Pty Ltd.
IN
Thanks, these table are used when we are creating a Rule at , need to get table name of the sequence of Pega Rules executed Runtime..
JPMorgan Chase & Co.
IN
Did you get the solution for your problem? If yes, would love to have discussion on the solution. Please let me know
Accepted Solution
Updated: 19 Jul 2024 12:25 EDT
Pegasystems Inc.
GB
@Ambrish510 The solution will be a custom reporting implementation involving reporting on the audit trail. Pega Platform maintains statistics during operation which are written to the Pega Platform database for later review and analysis during application server shutdown. These statistics cover all requestors of every type, with cumulative statistics since startup. This can be helpful in identifying the most frequently and least frequently executed rules (for those rule types that are assembled using rules assembly). However, the specific table name where this information is stored is not mentioned in the provided context.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Rule usage snapshots > How it works
Note: the moderators have chased the original poster multiple times to update this post but to no avail.
If you need further help I would suggest that you contact a Pega Consulting team via your account manager for further discussion.