SWQL for building modern dashboard with region as custom property

Hello Experts,

I am trying to build one modern dahsboard KPI dashboard which helps me to get number of down devices region wise. We are using "Region" as custom property to update the device region details.

The requirement is that we want to see number of down devices in recent times not all the down devices (Devices went down in past 5 mins only) . The entire agenda is that we have alerts and incidents in place to trigger for any alert after 5 mins, so we want to capture device down details before we get alert & incident to act proactively and reduce our incident count.

I am able to get one query but when i click on it, it is not redirecting me to the list of down devices and i am getting only the down number from the entire region. And i couldn't build the query related to timeline as recent down (in 5 mins). Any help on this would be very helpful.

Below is the query that i tried:

SELECT COUNT(1) as TheCount, '/apps/platform/dashboard/26' as Link
FROM Orion.Nodes n
INNER JOIN Orion.NodesCustomProperties cp ON cp.NodeID = n.NodeID
WHERE n.Status = 2 and cp.region = 'emea'

In the above query, Link is not working as i couldnt build it properly to show the EMEA down devices :-( and time period details to be updated in query.

Please help.

Thank you.

Find more posts tagged with

swql query

Modern Dashboards

Custom Query

npm

Dashboards

content_exchange

Accepted answers

adam.beedell

Interesting one. So the link is what you're putting in in the link field, any clickthrough issue is there. What you need is something to link to that displays the down devices right away. A few options come to mind

1) Build a complex URL

- Stuff like perfstack and moderndashboards can have filters and attributes applied in the URL. If you fed in the devices or something there it could work. This is the hardest option

2) Link to a dashboard with elements that filter for that region and down

3) Make dynamic groups for that region's down devices, generate the "down stuff details URL" from the SWQL. Perhaps right join against the list of groups.

I dont have an element to give you mind. 2 is probably the easiest option. There's probably other options too. Something in this space would be a good feature.

All comments

adam.beedell

- Stuff like perfstack and moderndashboards can have filters and attributes applied in the URL. If you fed in the devices or something there it could work. This is the hardest option

2) Link to a dashboard with elements that filter for that region and down

3) Make dynamic groups for that region's down devices, generate the "down stuff details URL" from the SWQL. Perhaps right join against the list of groups.

I dont have an element to give you mind. 2 is probably the easiest option. There's probably other options too. Something in this space would be a good feature.

phanisai

Hi Adam,

thanks for your response. Any other inputs related to time period that i am looking for.. we want to look at devices down in last mins only.. any device whose down time is greater than 5 mins should no be displayed here.

adam.beedell

You probably want to go with option 2 then, creating a report-type page with that time condition in the where, and repeating for each region

phanisai

Hi Adam, thank you.

Can i get a help to understand how to create hyperlink and add into the SWQL . And as suggested, if i want to create report type page this needs to done by SWQL only right? or directly from existing options we cn do? Please help.