2 weeks ago - last edited 2 weeks ago by Mercedes_O
I'm looking to create a report to list all the dashboards and the widgets on them.
I've found some of the information in tsysWebTabs, tsysreportpages and tsysreports, and have a basic linking of the dashboard names to the tabs assigned to them, but I can't find the widget tables to link these together.
Here's what I've got so far:
Select Top 1000000 tsysWebTabs.TabID,
tsysWebTabs.TabName,
tsysreportpages.HomepageQuery,
tsysreports.Reporttitle,
tsysreports.Reportquery
From tsysWebTabs
Inner Join tsysreportpages On tsysWebTabs.PageID = tsysreportpages.PageID
Inner Join tsysreports On
tsysreports.Reportquery = tsysreportpages.HomepageQuery
Order By tsysWebTabs.TabID
Some of the TabID's line up with the dashboard names, like Main page shown here, and some don't, like #2 Servers, which I don't have on my dashboard. The HomepageQuery and the Reporttitle are wrong too.
Is there a DB table for the Widgets?
Anyone else come across a solution for this?
Thursday
Users can customize their tabs so you have to add column for user's info:
Select Top 1000000 tsysWebTabs.TabID,
tsysWebTabs.TabName,
tsysreportpages.HomepageQuery,
tsysreports.Reporttitle,
tsysreports.Reportquery,
tsysWebUsers.Username
From tsysWebTabs
Inner Join tsysreportpages On tsysWebTabs.PageID = tsysreportpages.PageID
Inner Join tsysreports On
tsysreports.Reportquery = tsysreportpages.HomepageQuery
Inner Join tsysWebUsers On tsysWebUsers.PageID = tsysWebTabs.PageID
Order By tsysWebTabs.TabID
Thursday
It wouldn't have occurred to me to tie in the users to the report as I'm the only one that uses LS here. This gives me another thread to pull on.
Thank you for the tip @Mister_Nobody .
Friday
Try this report:
Select Top 1000000 tsysWebUsers.Username,
tsysWebTabs.TabName,
tsysWebControls.ControlName,
tsysWebControls.Path
From tsysWebUsers
Inner Join tsysWebTabs On tsysWebUsers.PageID = tsysWebTabs.PageID
Inner Join tsysWebTabControls On tsysWebTabs.TabID = tsysWebTabControls.TabID
Inner Join tsysWebControls On tsysWebTabControls.ControlID =
tsysWebControls.ControlID
Friday
Pretty close. Just needs tweaking the actual report/chart titles. But yes, closer than what I've been able to dig out. I'll have time next week to really dig deeper into this.
You are a superstar @Mister_Nobody 😁
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now