New Topic

Category Dashboards

Product Version 8.0

Which DB table has information regarding Dashboards

Sameer Patil shared this question 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.

The same question

Replies (7)

Paul Thornton ●

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

Reply URL

Sameer Patil ●

Hi Paul,

Thank You for the information.

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

Regards,

Sameer

Reply URL

Paul Thornton ●

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

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

Reply URL

Paul Thornton ●

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

Reply URL

Paul Thornton ●

Hi Sameer,

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

Thank you,

Paul

Reply URL

Sameer Patil ●

HI Paul,

Please close this ticket.

Regards,Sameer

Reply URL

Paul Thornton ●

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

Reply URL