View Usage Statistics
You can access reports on Axon usage statistics, such as resolved change requests, top change request creators, and user login activity. For example, a data governance officer can monitor Axon performance by viewing the number of users logged in to Axon and the number of change requests that are resolved every day. You can use external visualization applications, such as Tableau, Power BI, and ClickView, to view the usage reports.
After you install or upgrade Axon, you need to create materialized views to access the Axon usage statistics. After you enable materialized views, a scheduled job is triggered every night to collect the updated data.
You can view the following types of usage statistics:
- •Number of resolved change requests and the duration of resolved change requests.
- •Number of change requests created and edited for an object over a period.
- •Status and count of change requests.
- •Number of created, edited, or deleted objects for a facet over a period of time.
- •Creators of top 10 change requests.
- •Number of created and deleted users.
- •Number of automatic and manual change requests.
- •Login activity of users.
The date values are in the UTC time zone.
Create Materialized Views for Usage Statistics
To view usage statistics, you must create materialized views of the database. Statsuser is a predefined user that can access materialized views. To create the statsuser profile, you must provide a password. With the statsuser credentials, you can access the usage statistics reports. After you install Axon, you can run the matviewenable.sh script to create materialized views. A user with the SuperAdmin or Admin profile can perform these tasks.
1. In the Linux environment, navigate to the following directory:
<INSTALLATION_DIR>/scripts
2. To create materialized views, run the sh matviewenable.sh command.
3. Enter 1.
The materialized views are created.
4. To create the statsuser profile, enter 1 and type a password. Confirm the password.
The statsuser is created.
5. Run the sh matviewenable.sh command again. Choose one of the following options:
Option | Description |
|---|
Refresh | Refresh the instance of materialized views. |
Drop and Recreate | Discard the materialized views and create a fresh instance of materialized views again. |
6. If you want to create the statuser profile before you enable materialized views or if you did not choose to create the statsuser earlier, run the matview_user_creation.sh command and enter the password to create the statsuser.
7. To disable materialized views, run the sh matviewdisable.sh command.
Resolved Change Requests
You can view the average number of change requests that are resolved every day in the cr_resolution_stats table.
The following table lists the fields and description of the cr_resolution_stats table:
Field | Datatype | Description |
|---|
rsltn_date | Date | Date on which the change request is resolved. |
avg_rsltn_dur | String | Average resolution time for a change request. |
rsltn_cnt | Number | Number of change requests resolved per day. |
min_rsltn_dur | String | Minimum resolution time for a change request. |
max_rsltn_dur | String | Maximum resolution time for a change request. |
The following table shows a sample data that you can view in the cr_resolution_stats table:
rsltn_date | rsltn_cnt | avg_rsltn_dur | min_rsltn_dur | max_rsltn_dur |
|---|
2/25/2021 | 1 | 00:00:12.259 | 00:00:12.259 | 00:00:12.259 |
2/24/2021 | 1 | 00:19:58.916 | 00:19:58.916 | 00:19:58.916 |
2/23/2021 | 2 | 00:08:45.223 | 00:07:31.142 | 00:09:59.304 |
2/22/2021 | 5 | 00:31:48.4034 | 00:02:48.556 | 00:46:33.246 |
2/21/2021 | 1 | 00:10:22.066 | 00:10:22.066 | 00:10:22.066 |
Created and Edited Change Requests for Facets
You can view the daily created and edited change requests for each facet in the cr_facet_stats table.
The following table lists the fields and description of the cr_facet_stats table:
Field | Datatype | Description |
|---|
date | Date | Date on which the change requests that are created or edited. |
obj_cnt | Number | Number of objects that contain change requests. |
cr_create_cnt | Number | Number of automatic change requests that are created when you create an object. |
cr_edit_cnt | Number | Number of automatic change requests that are created when you edit an object. |
cr_mnl_cnt | Number | Number of manual change requests. |
facet_nm | String | Name of the facet. |
The following table shows a sample data that you can view in the cr_facet_stats table:
date | obj_cnt | cr_create_cnt | cr_edit_cnt | cr_mnl_cnt | facet_nm |
|---|
2/24/2021 | 1 | 2 | 1 | 2 | policy |
2/23/2021 | 1 | 0 | 2 | 1 | project |
2/23/2021 | 1 | 3 | 0 | 1 | process |
2/11/2021 | 1 | 1 | 1 | 1 | dataset |
Change Request Status
You can view the count of change request statuses in the cr_status_stats table.
The following table lists the fields and description of the cr_status_stats table:
Field | Datatype | Description |
|---|
date | Date | Date on which the change requests are created, updated, or deleted. |
create_cnt | Number | Number of created change requests. |
rsltn_cnt | Number | Number of resolved change requests. |
in_prgrs_cnt | Number | Number of change requests that are in progress. |
rjctd_cnt | Number | Number of rejected change requests. |
The following table shows a sample data that you can view in the cr_status_stats table:
date | create_cnt | rsltn_cnt | in_prgrs_cnt | rjctd_cnt |
|---|
1/8/2021 | 2 | 1 | 1 | 0 |
1/9/2021 | 3 | 0 | 3 | 1 |
1/10/2021 | 6 | 2 | 4 | 3 |
1/11/2021 | 23 | 1 | 24 | 2 |
1/12/2021 | 1 | 0 | 16 | 9 |
Facet Objects
You can view the number of created, updated, and deleted objects for a facet in the obj_facet_stats table.
The following table lists the fields and description of the obj_facet_stats table:
Field | Datatype | Description |
|---|
date | Date | Date on which the objects are created, updated, or deleted. |
create_cnt | Number | Number of created objects for a facet. |
upd_cnt | Number | Number of updated objects for a facet. This count is updated only when the Last Updated value changes in the Summary tab of an object. |
del_cnt | Number | Number of deleted objects for a facet. If a delete operation does not apply to a facet or an object is permanently deleted from a database, the "NaN" value appears. |
facet_nm | String | Name of the facet. |
The following table shows a sample data that you can view in the obj_facet_stats table:
date | create_cnt | upd_cnt | del_cnt | facet_nm |
|---|
2/18/2021 | 0 | 1 | 0 | people |
2/24/2021 | 2 | 1 | NaN | changerequest |
2/24/2021 | 1 | 0 | NaN | role |
2/20/2021 | 2 | 0 | 0 | dataset |
2/19/2021 | 3 | 1 | 1 | glossary |
Top 10 Change Request Creators
You can view the top 10 users that created the maximum number of change requests in the cr_top_creators table. You can see a maximum of 100 rows in the cr_top_creators table depending on the number of users that created maximum change requests. For example, consider that 10 users created 10 change requests each and five users created five change requests each. The users that created 10 change requests are ranked as "1", and the users that created five change requests are ranked "2". You can see that 15 rows are populated in the cr_top_creators table.
The following table lists the fields and description of the cr_top_creators table:
Field | Datatype | Description |
|---|
name | String | Name of the user that created the change requests. |
email | String | Email address of the user that created the change requests. |
role | String | Profile of the user that created the change requests. Axon has WebUser, Admin, and SuperAdmin user profiles. |
cr_cnt | Number | Number of change requests that the user created. |
rank | Number | Rank of the change requests. |
The following table shows a sample data that you can view in the cr_top_creators table:
name | email | role | cr_cnt | rank |
|---|
WebUser1 | wu1@infa.com | WebUser | 1 | 3 |
John Admin | jadmin@informatica.com | SuperAdmin | 3 | 2 |
InfAdmin | infadmin@infa.com | Admin | 4 | 1 |
Created and Deleted Users
You can view the number of created and deleted users in the usr_sync_stats table.
The following table lists the fields and description of the usr_sync_stats table:
Field | Datatype | Description |
|---|
date | Date | Date on which the users are created or deleted. |
usr_create_cnt | Number | Number of users that are created. |
usr_del_cnt | Number | Number of users that are deleted. |
The following table shows a sample data that you can view in the usr_sync_stats table:
date | usr_create_cnt | usr_del_cnt |
|---|
1/11/2021 | 0 | 1 |
1/10/2021 | 2 | 0 |
1/9/2021 | 1 | 0 |
1/8/2021 | 2 | 1 |
Manual and Automatic Change Requests
You can view the number of manual and automatic change requests in the cr_initiator_stats table.
The following table lists the fields and description of the cr_initiator_stats table:
Field | Datatype | Description |
|---|
date | Date | Date on which the change requests are created. |
usr_initiated_cnt | Number | Number of manual change requests. |
sys_initiated_cnt | Number | Number of automatic change requests. |
The following table shows a sample data that you can view in the cr_initiator_stats table:
date | usr_initiated_cnt | sys_initiated_cnt |
|---|
2/26/2021 | 1 | 0 |
2/25/2021 | 0 | 10 |
2/24/2021 | 2 | 5 |
2/23/2021 | 3 | 0 |
User Login Activity
You can view the login activity for Axon users in the usr_login_stats table.
The following table lists the fields and description of the usr_login_stats table:
Field | Datatype | Description |
|---|
date | Date | Latest date on which the user logged in. |
login_cnt | Number | Number of times the user logged in. |
name | String | Name of the user that logged in. |
role | String | Profile of the user that logged in. Axon has WebUser, Admin, and SuperAdmin user profiles. |
email | String | Email address of the user. |
The following table shows a sample data that you can view in the usr_login_stats table:
date | login_cnt | name | email | role |
|---|
3/4/2021 | 1 | John Admin | admin@informatica.com | SuperAdmin |
3/2/2021 | 53 | John Admin | admin@informatica.com | SuperAdmin |
3/2/2021 | 2 | Perf First Name 1 Perf Last Name 1 | p1@informatica.com | WebUser |
3/1/2021 | 60 | John Admin | admin@informatica.com | SuperAdmin |
Note: If you upgrade to Axon 7.2, the usr_login_stats table does not display any data.