How can we fetch Service Timeout Count for last 1 Year
We need to fetch Service Call Timeout say Event (PEGA0011 - Service Total Time) for last 1 year and if possible, monthly
HCA Healthcare
US
@PriyeshTo fetch the Service Timeout Count (PEGA0011 - Service Total Time) for the last year, you can query the pr_perf_stats table in the Pega database. Use a SQL query that filters records where eventname is 'PEGA0011' and the starttime is within the last year, grouping the results by year and month while counting the occurrences. If direct database access is not available, you can create a Report Definition in Pega under the Log-Performance class, filter by EventName as 'PEGA0011', and set the date filter for the last year. Group the results by month and year while counting the events. If using PDC (Predictive Diagnostic Cloud), navigate to the Event Viewer > Performance Metrics > PEGA0011, filter for the last year, and export the data. This will provide a monthly count of service timeouts over the past year
Ernst & Young LLP
IN
@Sairohith Thanks for the response,
I was checking on pr_perf_stats table, couldn't find any column as event name.
can you please provide any link you have of pega documentation or any other details?
Also, I couldn't find any option as Performance Metrics in Event Viewer, and also PDC only has data of last 2 weeks (14 days) isn't it?
Thanks! Priyesh A
HCA Healthcare
US
@PriyeshYou’re right! The pr_perf_stats table doesn’t have a direct eventname column. The service timeout details for PEGA0011 events are generally logged in the pr_log_usage table, where the pxEventType column captures event types. For details you can reference Pega Documentation. Regarding PDC, you're correct that it typically retains data for the last 14 days. For historical data beyond two weeks, you would need to export logs regularly or set up a custom report in Pega by creating a Report Definition in the Log-Performance class, filtering for the PEGA0011 event and summarizing monthly counts. Let me know if you need help setting up the report
Ernst & Young LLP
IN
I was not able to find Log-Performance Class in the system. can you please help with that? any screenshot abt this?
also the Pega Link above is not working. can u please share the full link.
Thanks! Priyesh A
Pegasystems Inc.
CA
If you have enabled Service Monitoring, you can get the results from the Invocation history.
You can pull the data from alert logs, assuming you have a history of alert logs for over a year. However, it's a time-consuming process.
Thanks,
Ramesh
Ernst & Young LLP
IN
@RameshSangiliThanks for the response.
we don't have service monitoring enabled.
Also, coming to PEGA alert logs, yes it will be huge and difficult to find the required details, as we are looking for a particular service timeout counts, say a particular case id from PDC under PEGA0011 Events.
Thanks! Priyesh A