Dashboard URL

Question

Hi,

I am creating a dashboard using swql query. I want if someone click on node down and Custom Properties "server_category" it should redirect me to a filtered list on nodes on manage nodes. Can that be achieved?

SELECT COUNT(1) as TheCount, '/apps/ncm/nodes/status/1' as Link
FROM Orion.Nodes N
WHERE N.CustomProperties.Environment LIKE '%Prod%' and N.CustomProperties.server_category = 'Critical Server' and N.Status = 1

Thanks in advance.

zap123 · Answer

Hi chad,

i am not using the filters on a chart or a table. It just show application status as down and up of nodes and the url should direct to the up or down status devices of a specific application which is a custom property.

chad.every · Answer

This is what I've done in my environment. I leverage Global Filters in Modern Dashboards.

This requires two dashboards.

* A dashboard with the summary data (The widget you want to drill into)
* A dashboard with only a single Table Widget (The data you want to see after drilling into the widget from #1)

For item #1, Create a SWQL query that appends the URL link with Global Filters. This will then be referenced in the Widget configuration link.

For item #2, Make sure to reference the dashboard ID in the SWQL query from #1.

Example: Proportional Widget (Modern Dashboard)

Example SWQL to build widget

SELECT Count( NodeID) as [Count] 
, S.StatusName as [Device Status]
, '/apps/platform/dashboard/52?filters=0_Orion.Nodes_Status:eq:'+TOSTRING(N.Status) as [Link]
FROM Orion.Nodes N
JOIN orion.StatusInfo s on s.StatusId=N.Status
Group by N.Status, S.StatusName

For each Node Status, the SWQL updates the URL with the appropriate Global Filter. In this case 0_Orion.Nodes_Status. Hovering over the statuses in the widget will reflect the different Status IDs.

.../apps/platform/dashboard/52?filters=0_Orion.Nodes_Status:eq:14
.../apps/platform/dashboard/52?filters=0_Orion.Nodes_Status:eq:2

Clicking one of the statuses on that widget will take me to item #2 (from the beginning of this post) to that second table dashboard. You can see the Global Filters are applied in the URL.

zap123 · Answer

I tried that but it is not redirecting me to the correct page or Link the count is perfect. I am using below filter for Link

/Orion/Nodes/Default.aspx?AdvancedFilters=CustomProperties.server_category=Critical Server AND Status=1 AND CustomProperties.Environment = Prod