This is hopefully an easy one for you experts (SWQL) Dashboard

bootneck1111

I have created the clients 'Orion Home Summary' Dashboard (Modern), displaying some 'Node Status' widgets, one for each of their sites/studios in the US.

All I'm looking for now is to have a simple Table Widget on the Home Summary Dashboard listing the 7 Studios from top-to-bottom in the table/left-hand column, and these Studios have a 3-letter abbreviated code, for example, SFO (San Francisco)

The Studio Codes have been created via a Custom Property so that each node can be tagged with its studio code in the Node Properties. Simple.

But I would also like to have a URL/Link in the second column in the table which when clicked takes the User to a secondary Dashboard, presenting widgets for that specific Studio away from the Orion Home Summary.

This is what I'm using (SWQL) to present the 'Studio' Custom Property with a couple of other Custom Properties. The problem with this query is that it is searching for the TOP 100 entries where as all I want is to list the 7 x Studio Codes in the left hand column, and then have a URL in the righ-hand column for the user to click.

I cannot see any URL column in the 'Orion.NodesCustomProperties' table, but I'm sure it will be in another table somewhere.

Am I also going to have to Group/Order the query so that I only receive one row for each of the Studios?

It seems a simple request and maybe I'm looking too much into this :-)

SELECT TOP 100 City, Studio
FROM Orion.NodesCustomProperties

marcrobinson

Your second part of the response can be done via the following - list of modern dashboards with links. Generating the status - I would consider creating dynamic groups around your studio custom property, then showing the group status for the first column. Cleaner table. There are other ways, such as only listing down nodes per your studio property. OR down nodes based on group membership. Overall, SolarWinds is flexible enough to give you multiple ways to do this.

Try this out for the dashboard links: 

SELECT CONCAT ('<a href="','/apps/platform/dashboard/',dash.DashboardID,'">', (dash.DisplayName, ' '), '</a>') AS Studios FROM Orion.Dashboards.Instances dash

That will list all of your dashboards with html formatting.

You can filter based on dashboardID or displayname in the where clause. I am guessing on names and ID's.

Where dash.DisplayName LIKE '%Studio'  or Where dash.DashboardID in (49,50,23)

There is probably a better way to do this in modern dashboards though. Bear in mind I have not tested this in a table widget yet. Below is using a redundant column structure as you can set the Link property in a table widget when using custom swql in a modern dashboard. I use a variation of the above for classic views in a table widget. I have it list specific views using a where clause. I don't have that many modern dashboards to worry about yet...  

 

Select dash.displayname, CONCAT ('<a href="','/apps/platform/dashboard/',dash.DashboardID,'">', (dash.DisplayName, ' '), '</a>') AS Links FROM Orion.Dashboards.Instances dash

You see some system generated dashboards and even disabled ones. THe following where statements can remove them if you want a cleaner report in swql. This is also from the orion.dashbaords.instances entity.

where issystem = FALSE and isactive = TRUE

I will think about how to have the group and dashboard links match. Again there are a couple of things off the top of my head that might work, including a custom property to store the url and assigned to the group. Then report on group name, group status, and group customproperty for url or part of the url as I bet some of the special characters might cause problems. Then you are back to using the above concat command to build the url. There might be a better method to pull the url, but I cannot think of it right now. 

Good luck

Marc