User Tracking Tables

SELECT * FROM homepage_search  LIMIT 1 \G

MariaDB [dashboard]> select * from homepage_search  limit 1 \G

*************************** 1. row ***************************

homepage_search_id: 1

user_id: 18

search_text: Sales_&_Gross_Profit (Version 2)

search_time: 2019-03-20 21:46:42

time_performed: 1

results_count: 1

filters: NULL

2. Table "user_stats"

SELECT * FROM user_stats LIMIT 1 \G

MariaDB [dashboard]> select * from user_stats limit 1 \G

*************************** 1. row ***************************

user_id: 3

last_login_time: 2019-06-21 11:24:50

last_ldap_sync_time: NULL

3. Table "dashboard_element_view_log_detail"

SELECT * FROM dashboard_element_view_log_detail LIMIT 1 \G

MariaDB [dashboard]> select * from dashboard_element_view_log_detail  limit 1 \G

*************************** 1. row ***************************

element_id: 10

segment_value_id: 1

user_id: 1

view_time: 2015-08-04 09:25:19

api_access_ind: N

email_sent_date: NULL

email_type: NULL

4. Table "user_page_view_log"

SELECT * FROM user_page_view_log LIMIT 1 \G

MariaDB [dashboard]> select * from user_page_view_log  limit 1 \G

*************************** 1. row ***************************

 user_id: 1

 page: admin/alertpreferencetemplate/index

first_view_time: 2018-02-05 13:49:59

 last_view_time: 2018-02-05 13:49:59

total_view_count: 1

5. Table "user_portal_page_view"

SELECT * FROM user_portal_page_view LIMIT 1 \G

MariaDB [dashboard]> select * from user_portal_page_view  limit 1 \G

*************************** 1. row ***************************

user_portal_page_view_id: 4

user_id: 50

portal_page_id: 12

is_start_page_ind: N

created_on: 2018-09-24 20:10:33

created_by: sam