Question
TATA CONSULTANCY SERVICES
IN
Last activity: 7 Mar 2017 20:29 EST
Regular and Occassional Users data OOTB from pr_usage_summary
Hi,
Pega OOTB stores Regular and Occassional Users information Monthly Wise in the OOTB Table pr_usage_summary. But we need the data of Regular and Occasional Users of our Application Hourly Basis.
SELECT
"PC0".PYSUMMARYTYPE AS "pySummaryType" , "PC0".PYPERIODSTARTS AS "pyPeriodStarts" , "PC0".PYPERIODENDS AS "pyPeriodEnds" , "PC0".PYPERIODASOF AS "pyPeriodAsOf" , "PC0".PYDISTINCTUSERSSPORADIC AS "pyDistinctUsersSporadic" , "PC0".PYDISTINCTUSERSOCCASIONAL AS "pyDistinctUsersOccasional" , "PC0".PYDISTINCTUSERSREGULAR AS "pyDistinctUsersRegular" , "PC0".PYINVOCATIONSWEBUSERS AS "pyInvocationsWebUsers" , "PC0".PYINVOCATIONSSERVICES AS "pyInvocationsServices", "PC0".PYPERIODSTARTS as "pxInsHandle"
FROM
XX.pr_usage_summary "PC0"
ORDER BY "PC0".PYPERIODENDS DESC
Is there any way to get that data ?
Accepted Solution
Pegasystems Inc.
US
pr_hourly_usage and pr_daily_usage tables should give you that info.
Pegasystems
IN
When I read - https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm - it does mention the following
The License Compliance facility provides a flexible framework for collecting usage data that in summary can provide evidence about past usage of a production Pega 7 Platform system. A background process known as the License daemon logs statistics each hour, which are automatically summarized at the start of each day, and further summarized for a month, quarter, or other period. Standard reports are available for each level.
Reports and compliance monitoring
To view summary statistics at the period level — typically a month — Select one of the four menu options within the Designer Studio> System >License menu on the Designer Studio.
Did you see the above reports?
Updated: 21 Oct 2015 7:58 EDT
TATA CONSULTANCY SERVICES
IN
Hi Rajiv,
Yes, have already seen that. It just provides monthly wise summary. Is there any way to get Dailywise/Hourlywise Summary ?
Thanks
Hari Kumar Alampuru
JP Morgan
US
Hi ,
Can you please tell me what service invocations are taken into account in this report? "pyInvocationsServices" - What does this count specify. (Soap calls, Http calls)
TATA CONSULTANCY SERVICES
IN
Is there any way to get "Regular and Occassional Users" Count Dailywise/Hourlywise Summary ?
TATA CONSULTANCY SERVICES
IN
Thanks Kevin Zheng for the reply ! Let me look at the Tables data.
Virtusa
AU
Hello Kevin,
Using the summary report I'll able to get the count of regular and occasional users but is there any chance that i'll be able to get the operator ids of those regular and occasional users?
Cheers,
Satyakanth