Regular and Occassional Users data OOTB from pr_usage_summary
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.
"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"
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.