I want to query for all reports associated to a Dashboard/Dashboard Tab

[art_anderson2]

From which table to I query to find all reports/widgets associated to a dashboard/dashboard tab?

Thank you,
Art

[art_anderson2]

Okie dokie...

I poked around in our system a little more; I think I finally found what I'm looking for.

I have not yet made all of the field associations, essentially followed this trail...

pa_dashboards    -- Already had a handle on this

pa_m2m_dashboard_tabs    -- Already had a handle on this

pa_tabs    -- Already had a handle on this

sys_portal_page    -- This was my missing link

Brought me to: sys_portal

Which brought me to: sys_portal_preferences

I'm still looking at this to make sure I'm on the right track, my end here is to  be able to make a database view to make it easy for me when folks ask me to update report owners against a Dashboard or Dashboard tab.

Thanks,

Art

[Muhammad Khan]

Hi art,

Following blog might be helpful for you to know what Reports are on what Dashboards;

https://community.servicenow.com/community?id=community_blog&sys_id=c3ecf2351bfbdc90d2ccea89bd4bcb82

Hopefully you will get a direction from it.

[art_anderson2]

Hi Muhammad,

Yes indeed, in fact after I completed building my own database view, one of my peers sent me this very same article.  The database view I created is incredibly similar to this article except I included the base dashboard and did not include stats.  I'll see if my customer needs stats in this as well.  Our next step will be looking at widgets to include in the view.  So far so good.

Thank you,

Art