Recovering a Deleted Dashboard and Identifying Who Deleted It in Bold BI.
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:
- 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.
If 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.
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
- After successfully recovering the dashboard, click on the More Options tab on the dashboard.
- Select Version History.
- Choose the File Logs option to view the user who deleted the dashboard.
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.