Question

Query to know installed Hotfixes

Can you please inform what will be the best way to verify count of installed hotfixes? I am not confident of the below query:

select PYPRODUCTID from prpcrules.pr_data_products where PYPRODUCTID like 'HFIX%';

In AIT environment this query is returning 76 Hotfixes, but in same AIT environment the scan result in Hotfix manager is showing 79 committed Hotfixes.

This query is showing 3 less.

Pega 7.2 Platform.

Correct Answer
January 18, 2019 - 11:06am

Can you please try this?

select * from [rules_schema].pr_data_scanner order by pxCreateDateTime

Comments

Keep up to date on this post and subscribe to comments

January 18, 2019 - 11:06am

Can you please try this?

select * from [rules_schema].pr_data_scanner order by pxCreateDateTime

January 21, 2019 - 1:05am
Response to ARVINDMALAV

Thanks. This query gave the same count as shown in Hotfix Manager scan result. I want to compare Hotfixes present in AIT and UAT and only the difference (if any) of counts will not be sufficient. I need the exact name of Hotfix in the output of query to identify which hotfix is not present.