ATK_USER_ACTIVITY_FREQ_V

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
USER_NAME ACTIVITY_CODE ACTIVITY_NAME ACTIVITY_DESCRIPTION FREQUENCY

Query

SQL_Statement
select user_NAME, activity_code,activity_name, activity_description, count(activity_code) FREQUENCY from atk_usage_logs_V group by user_NAME, activity_code ,activity_name, activity_description