Question

3
Replies
1766
Views
SudheerC2995 Member since 2015 4 posts
AIG
Posted: 4 years ago
Last activity: 3 years 1 month ago
Closed
Solved

How to calculate Usage Summary using data from pr_daily_usage table

For some reason Usage Summary data is showing zeros, so we want to know how to calculate data like "Regular Users","Occasional Users", "Service invocations" and "Web User Invocations".

Following is the sample data that I see in "pr_daily_usage" table when I execute below query.

SELECT pzInteractionCount,pzInvocationCount,pzMayCheckOutRules,pzModifiedRulesCount,pzNoInvocationFlowCount,pzNoInvocationUserCount,pzUserType,pzUsageDay,pzUsageHoursCount,

pzUserAdditionalInfo,pzUserId FROM pr_daily_usage WHERE pzUsageDay >= '2016-03-01' and pzUsageDay <= '2016-03-31';

In this data I see there are four unique values to "pzUserType" column

H --> users login through Browser
W --> has userID as "GUEST:noName"
A --> has UserID as "WEB"
S --> has UserID as "Service"

With this data present in "pr_daily_usage", how can I calculate "Regular Users","Occasional Users", "Service invocations" and "Web User Invocations".

Also what is the meaning of "pzInteractionCount", "pzInvocationCount", "pzNoInvocationFlowCount", "pzNoInvocationUserCount", I do not see any help or explanation related to these columns.

If anybody has any clue on this please respond. Thanks.

UsageStat-Numbers.png

Message was edited by: Marissa Rogers - Added Category

Case Management
Moderation Team has archived post
Share this page LinkedIn