Which DB table has information regarding Dashboards

Sameer Patil shared this question 4 months ago
Answered

Customer has deleted view by mistake, now they want to restore dashboards + reports.


We have DB backup available and can see reports in ReportHeader table, however we are not able to find any table which will have information regarding Dashboards.


Please let me know which table has details related to Dashboards.

Comments (7)

photo
1

Hi Sameer,

You should be able to find the information you are looking for in reportgroup.

Please let me know if you need anything else.

Regards,

Paul

photo
1

Hi Paul,


Thank You for the information.


Just wanted to know how we can check details regarding private dashboard from DB.


Regards,

Sameer

photo
1

Hi Sameer,

You could do something like the following, then fine tune the columns to what you need. You could then also use the person table to get the user name.

SELECT * FROM reportgroup b
inner join accesslevel a on (a.entityid = b.groupid)
WHERE b.accesscode = 'ACCESSLEVEL' AND b.statuscode = 'OPEN';
Let me know if this helps. Regards,

Paul

photo
1

Hi Sameer,

Just checking in on this to see if you need anything else or if you are happy for me to close this off? I you can get back to me, that would be great.

Thank you,

Paul

photo
1

Hi Sameer,

Just checking in on this ticket to see if you need any more help?

Thank you,

Paul

photo
1

HI Paul,

Please close this ticket.

Regards,Sameer

photo
1

Hi Sameer,

Thanks for getting back to me. Closing off this ticket as requested. If you need anything else, please keep in touch.

Regards,

Paul