How to Get Dashboard Activities in Bold BI

In some cased you may want detailed log of dashboard activities. This includes information about who is viewing the dashboard, when they are viewing it, and which dashboard they are viewing.

In Bold BI, this information can be obtained from the boldbi_itemlog table. The following SQL query can be used to retrieve the necessary data:

SELECT
  "boldbi_itemlog"."modifieddate" AS "Activity Date",
  "boldbi_itemlogtype"."name" AS "Activity Type",
  "boldbi_item"."id" AS "resource id",
  "boldbi_item"."name" AS "Resource Name",
  "boldbi_item"."ispublic" AS "ispublic",
  "boldbi_item"."isdraft" AS "isdraft",
  "boldbi_user"."displayname" AS "displayname",
  "boldbi_user"."email" AS "email",
  "boldbi_itemtype"."name" AS "Resource Type"
FROM
  "public"."boldbi_itemlog" AS "boldbi_itemlog"
  INNER JOIN "public"."boldbi_itemlogtype" AS "boldbi_itemlogtype" ON "boldbi_itemlog"."itemlogtypeid" = "boldbi_itemlogtype"."id"
  INNER JOIN "public"."boldbi_item" AS "boldbi_item" ON "boldbi_itemlog"."itemid" = "boldbi_item"."id"
  INNER JOIN "public"."boldbi_user" AS "boldbi_user" ON "boldbi_itemlog"."updateduserid" = "boldbi_user"."id"
  INNER JOIN "public"."boldbi_itemtype" AS "boldbi_itemtype" ON "boldbi_item"."itemtypeid" = "boldbi_itemtype"."id"
  INNER JOIN "public"."boldbi_source" AS "boldbi_source" ON "boldbi_itemlog"."sourcetypeid" = "boldbi_source"."id"

This query will return a table with the following columns:

Usage Analytics Dashboard

In Bold BI, there are three dashboards that display the overall activities:

1. Dashboard Usage analytics: The usage analytic dashboard is predefined and enables you monitor dashboard activity to better understand how users are interacting with dashboards.
   

   

2. Query performance tracking dashboard: This dashboard showcases all the executed query times based on each instance of dashboard widgets through a tracking ID.
   

   

3. Performance monitoring dashboard: This dashboard demonstrates the overall query execution time taken to render the topmost, slow dashboard widget and its data across all tenants.
   

   
   
   These dashboards provide a comprehensive view of the activities and usage in Bold BI, helping administrators to monitor and manage the system effectively.