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.
If you enable the Event Monitor service, you can also view the following types of usage statistics:
- •Number of searches in Unison and query API for a facet over a period of time.
- •Frequently used keywords to search for objects in Unison over a period of time.
- •Most searched for objects in Unison over a period of time.
- •Users who conducted the most searches in Unison over a period of time.
- •Number of quick searches over a period of time.
- •Most viewed object in a facet over a period of time.
- •Number of change requests created by a user over a period of time.
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.3.1, the usr_login_stats table does not display any data.
Number of Searches in Unison For a Facet
In the searches_for_<facet name>_in_180d and the guest_searches_for_<facet name>_in_180d tables, you can view the number of searches in Unison for a facet. Specify the name of facet the in the <facet name> field to retrieve data that is relevant to the facet. For example, to retrieve the number of searches in Unison for the System facet, see the searches_for_system_in_180d and the guest_searches_for_system_in_180d tables.
The following table lists the fields and descriptions of the searches_for_<facet name>_in_180d table:
Field | Datatype | Description |
|---|
searchterm | String | The search term used to initiate the search in Unison. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
The following table lists the fields and descriptions of the guest_ searches_for_<facet name>_in_180d table:
Field | Datatype | Description |
|---|
searchterm | String | The search term used to initiate the search in Unison. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
Frequently Used Keywords to Search for Objects in Unison
In the searches_in_180d and the guest_searches_in_180d table, you can view the frequently used keywords to search for objects in Unison.
The following table lists the fields and descriptions of the searches_in_180d and guest_searches_in_180d table:
Field | Datatype | Description |
|---|
searchterm | String | The search term used to initiate the search in Unison. |
date | Date | Date on which search is made. |
fullname | Varchar | Fullname of the user. |
role | Varchar | Role of the user. |
Most Searched For Objects in Unison
In the top_25_unison_searches_in_180d and the guest_top_25_unison_searches_in_180d tables, you can view the most searched for objects in Unison.
The following table lists the fields and descriptions of the top_25_unison_searches_in_180d table:
Field | Datatype | Description |
|---|
facet_name | String | The name of the facet. |
searchterm | String | The search term used to initiate the search in Unison. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
The following table lists the fields and descriptions of the guest_top_25_unison_searches_in_180d table:
Field | Datatype | Description |
|---|
facet_name | String | The name of the facet. |
searchterm | String | The search term used to initiate the search in Unison. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
Users Who Conducted the Most Searches
In the users_who_conducted_the_most_searches_in_180d table, you can view the Axon users who conducted the most searches.
The following table lists the fields and descriptions of the users_who_conducted_the_most_searches_in_180d table:
Field | Datatype | Description |
|---|
username | String | The name of the Axon user. |
hit_count | Number | The number of searches conducted with a search term. |
Number of Quick Searches
In the quick_searches_in_180d and the guest_quick_searches_in_180d tables, you can view the number of quick searches. This also includes searches that you initiate using the Axon Quick Look browser extension.
The following table lists the fields and descriptions of the quick_searches_in_180d table:
Field | Datatype | Description |
|---|
searchterm | String | The search term used to initiate the quick search. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
The following table lists the fields and descriptions of the guest_quick_searches_in_180d table:
Field | Datatype | Description |
|---|
searchterm | String | The search term used to initiate the quick search. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which a search was conducted. |
Note: These do not include searches conducted using the Axon Quick Look desktop application.
Most Viewed Object in a Facet
In the most_viewed_objects_in_<facet name>_in_180d and the guest_ most_viewed_objects_in_<facet name>_in_180d tables, you can view the most viewed object in a facet. Specify the name of the facet in the <facet name> field to retrieve data that is relevant to the facet. For example, to retrieve the most viewed object in the System facet, see the most_viewed_objects_in_<facet name>_in_180d and the guest_ most_viewed_objects_in_<facet name>_in_180d tables.
The following table lists the fields and descriptions of the most_viewed_objects_in_<facet name>_in_180d table:
Field | Datatype | Description |
|---|
facet_name | String | The name of the facet. |
object_name | String | The name of the facet object that is accessed. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which the object was viewed. |
The following table lists the fields and descriptions of the guest_ most_viewed_objects_in_<facet name>_in_180d table:
Field | Datatype | Description |
|---|
facet_name | String | The name of the facet. |
object_name | String | The name of the facet object that is accessed. |
hit_count | Number | The number of searches conducted with a search term. |
date | Date | The latest date on which the object was viewed. |
Note: The Regulatory facet and the Geography facet are not available to guest users. Therefore you cannot create materialized views for data pertaining to guest users for these facets.
Number of Change Requests Created by a User
In the change_requests_created_by_user_in_180d table, you can view the number of change requests created by Axon users.
The following table lists the fields and descriptions of the change_requests_created_by_user_in_180d table:
Field | Datatype | Description |
|---|
date | Date | Latest date on which the change request was created. |
hit_count | Number | Number of change requests created by the user. |
name | String | Name of the Axon user. |