Question

7
Replies
2150
Views
HARIKUMAR_ALAMPURU Member since 2011 39 posts
TATA CONSULTANCY SERVICES
Posted: 5 years ago
Last activity: 3 years 7 months ago
Closed
Solved

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 ?

Moderation Team has archived post
Share this page LinkedIn