Question
2
Replies
338
Views
Infosys
Posted: April 2, 2017
Last activity: April 5, 2017
Closed
Regular and occasional users
Hi All,
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?
I got below post related to this but i couldn't get what i wanted -
Cheers,
Satyakanth
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.
Posted: 4 years ago
In addition to Shanthini Charles.
you can get the PZUSERID from pr_hourly_usage.
Report Generation tables: pr_hourly_usage, PR_DAILY_USAGE, PR_USAGE_SUMMARY
Procedure: SPPR_AGGREGATE_USAGE
Should be able to achieve this by modifying the Store procedure "SPPR_AGGREGATE_USAGE " which aggregates the data and inserts to PR_USAGE_SUMMARY and the respective column have to be added.
Hi Satyakanth,
As per the article shared by you - you can get the PZUSERID from pr_hourly_usage.
Are you expecting to get these details in a report?
Regards,
Shanthini Charles