Question

7
Replies
2195
Views
Close popover
Satya Venkata Hari Kumar Alampuru (HARIKUMAR_ALAMPURU)
TATA CONSULTANCY SERVICES
SYSTEM ENGINEER
TATA CONSULTANCY SERVICES
US
HARIKUMAR_ALAMPURU Member since 2011 39 posts
TATA CONSULTANCY SERVICES
Posted: October 21, 2015
Last activity: March 7, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.