Production Deployment Query

This post will help me to identify the missing rules and rulesets in Production after the deployment / Migration.

Run the Query and Put the results One below another in Excel sheet and mark duplicates.

The row which are not highlighted are the culprits!!

Use case	Ruleset and count of rules
Query	select concat(pyruleset, pyrulesetversion), count(pzinskey) from pegrule.pr4_rule_vw where pyRuleSet like 'ORG%' group by pyruleset, pyrulesetversion;

Use case	Rulename,pzinskey With Op Name to compare the rules migrated
Query	select concat(pyruleset, pyrulesetversion,pyRuleName), pzInsKey,pxUpdateOpName from pegrule.pr4_rule_vw where pyRuleSet like 'ORG%' and pxUpdateDateTime>'20230101' AND pxUpdateOpName='John Doe';