Where does dashboard data exist in YF config db?

Dillon Hoefener shared this question 5 months ago
Answered

I'm looking to create some admin audit reports against the YF config db.

What table does the dashboard metadata (name, associated reports, etc) exist in the YF db? I assumed it was the "content" table, but no records are returned from queries against this. I see a "contentlink" mapping table where there are parent / link UUID's, but trying to get to the data related to dashboards to join to "reportheader" to get a report about dashboard dependencies.

Thanks

Best Answer
photo

Hi Dillon,

I was able to see a report id defined in the reportgroupentity table for a dashboard tab that included the report - here was my process -

Made a dashboard with TEST report - reportid - 104743

cd95a25def9c06f1b00221a790ac627b


This dashboard is in the reportgroup table - subtab groupid - 1047660b42639dae41b5166bac11afcf88c3cd


In reportgroupentity I can see report 104743 defined as an "entity" of groupid 104766 -

b9266409e355324da2f324917234a96e


Perhaps it's as simple of looking up the subtab versus the main dashboard groupid in this case? Let me know if I'm missing something here.

Thanks,

Eric

Comments (5)

photo
1

Hi Dillon,

Thanks for reaching out to support with your question.

You can find the dashboard data in the reportgroup table. I believe you can llink reports up to this table via the reportgroupentity table.

Hope this helps!

Thanks, Eric

photo
1

Hi Eric,

Based on your comment, my expectation of what is stored in reportgroupentity doesn't align with what I'm seeing.

I have a dashboard (group id = 142767), that contains a single entity id in reportgroupentity (id = 142768). This dashboard contains a report (report id = 142665).

I don't see anything I can use in reportgroupentity to join to reportheader to ultimately get from reportgroup --> reportheader. Is there another mapping table for entities I need to use? Naming-wise, I don't see anything that sticks out in the db.

Thanks

photo
1

Hi Dillon,

I was able to see a report id defined in the reportgroupentity table for a dashboard tab that included the report - here was my process -

Made a dashboard with TEST report - reportid - 104743

cd95a25def9c06f1b00221a790ac627b


This dashboard is in the reportgroup table - subtab groupid - 1047660b42639dae41b5166bac11afcf88c3cd


In reportgroupentity I can see report 104743 defined as an "entity" of groupid 104766 -

b9266409e355324da2f324917234a96e


Perhaps it's as simple of looking up the subtab versus the main dashboard groupid in this case? Let me know if I'm missing something here.

Thanks,

Eric

photo
1

Hi Dillon,

Just wanted to check in to see how you made out on this?

Thanks,


Eric

photo
1

Hi Dillon,

I'm going to go ahead and mark this question as Answered due to inactivity at this time. Feel welcome to reach out in the future.

Thanks,

Eric