Articles in this section
Category / Section

Recovering a Deleted Dashboard and Identifying Who Deleted It in Bold BI.

Published:

When managing dashboards in Bold BI, it’s important to know how to recover a deleted dashboard and identify who was responsible for its deletion. This article provides a step-by-step guide on how to perform these tasks.

Recovering a Deleted Dashboard

The Below steps mentioned for Server Site Datasource

To recover a deleted dashboard in Bold BI, follow these steps:

  1. Check the Tenant site server database (DB) name in the settings. If you have utilized the Common DB for both IMDB and server database, Refer to the image below.image.pngIf you have not used the Common DB for both IMDB and the server database, maintaining separate databases for the server and IMDB will result in displaying the server database name on the UMS page of the specific site details. Only administrators are allowed to access the UMS site in order to edit and review the site details. * Edit the specific site where you require the server database information.  * You will get the database name of the site. Refer to the image below.
  2. Once you have the database name, open your database server and use the following SQL Query to retrieve  the deleted dashboard. You need to know the Name or DashboardID of the dashboard you want to recover. In the example below, we use ‘Sales Analysis Dashboard’ as the dashboard name.

    SQL Server

    Sample:
    
    SELECT TOP (1000) [Id]
      FROM [Database _Name].[dbo].[BOLDBI_Item] where [Name] or [ID] = 'Dashboard Name or Dashboard ID' and [ItemTypeId] = 2
     
      update [bold_servicesiiuh].[dbo].[BOLDBI_Item] set [IsActive] = 1 where  [Name] or [ID] = 'Dashboard Name or Dashboard ID'
    
    Example using Dashboard Name:
    
    SELECT TOP (1000) [Id]
      FROM [bold_servicesiiuh].[dbo].[BOLDBI_Item] where [Name] = 'Sales Analysis Dashboard' and [ItemTypeId] = 2
     
      update [bold_servicesiiuh].[dbo].[BOLDBI_Item] set [IsActive] = 1 where  [Name] = 'Sales Analysis Dashboard'
    
    Example using Dashboard ID:
    
    SELECT TOP (1000) [Id]
      FROM [bold_servicesiiuh].[dbo].[BOLDBI_Item] where [ID] = '7451c34e-2dbd-4532-be4e-34f972f031aa' and [ItemTypeId] = 2
     
      update [bold_servicesiiuh].[dbo].[BOLDBI_Item] set [IsActive] = 1 where  [ID] = '7451c34e-2dbd-4532-be4e-34f972f031aa'

    MySQL

    Using Dashboard Name:
    
    SELECT `Id`
    FROM `Database_Name`.`BOLDBI_Item`
    WHERE `Name` = 'Sales Analysis Dashboard' AND `ItemTypeId` = 2
    LIMIT 1000;
    
    UPDATE `Database_Name`.`BOLDBI_Item`
    SET `IsActive` = 1
    WHERE `Name` = 'Sales Analysis Dashboard';
    
    Using Dashboard ID:
    
    SELECT `Id`
    FROM `Database_Name`.`BOLDBI_Item`
    WHERE `ID` = '7451c34e-2dbd-4532-be4e-34f972f031aa' AND `ItemTypeId` = 2
    LIMIT 1000;
    
    UPDATE `Database_Name`.`BOLDBI_Item`
    SET `IsActive` = 1
    WHERE `ID` = '7451c34e-2dbd-4532-be4e-34f972f031aa';

    PostgreSQL

    Using Dashboard Name:
    
    SELECT id
    FROM public.boldbi_item
    WHERE name = 'Sales Analysis Dashboard' AND itemtypeid = 2
    LIMIT 1000;
    
    UPDATE public.boldbi_item
    SET isactive = 1
    WHERE name = 'Sales Analysis Dashboard';
    
    Using Dashboard ID:
    
    SELECT id
    FROM public.boldbi_item
    WHERE id = '7451c34e-2dbd-4532-be4e-34f972f031aa' AND itemtypeid = 2
    LIMIT 1000;
    
    UPDATE public.boldbi_item
    SET isactive = 1
    WHERE id = '7451c34e-2dbd-4532-be4e-34f972f031aa'

Notes:

  • In MySQL, backticks ` are used to enclose database, table, and column names to avoid conflicts with reserved keywords.

Adjust Database_Name to your actual database name in each query.

Identifying Who Deleted the Dashboard

To determine the individual responsible for deleting a dashboard, please follow these steps:

  1. After successfully recovering the dashboard, click on the More Options tab on the dashboard. 
  2. Select Version History.
  3. Choose the File Logs option to view the user who deleted the dashboard.


Related Links:

By following these steps, you can effectively recover deleted dashboards and identify the responsible parties, ensuring better management and security of your Bold BI environment.

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
TF
Written by Thoulathul Fahmeetha
Updated
Comments (0)
Please  to leave a comment
Access denied
Access denied