Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Modern Dashboard Help. Separate widgets showing all Routers and Firewalls

Hello,

I've never created a modern dashboard. I'm trying to get a simple, but not to me, big numbers dashboard for management. We have our groups in this order. Routers/State/City/Node. The same goes for Firewalls, Firewalls/State/City/Node. I'm not putting the location due to security but our Data Center is group like this. Data Center A/Routers/Nodes, Data Center A/Switches/Nodes, Data Center A/Firewalls/Nodes, Data Center B/Routers/Nodes, Data Center B/Switches/Nodes, Data Center B/Firewalls/Nodes. I'm trying to group them all separately to show the number that is Down, Critical, Warning, UP for a total of 8 different Widgets. Not sure if this will help but we do also have custom properties Node_Category. Then we we put if it is n "Office Router", "Office Firewall" "Data Center A Router" etc. I have a screen shot of what I'm looking for.

Any help will be much appreciated.

Find more posts tagged with

Accepted answers

All comments

adam.beedell

I'm not sure of the specific thing you're looking to output, but each block would be a query, and your queries are probably selecting from the Nodes table. You can either use the UI, or write the queries by hand. Writing by hands means these probably include a COUNT(ID) ... GROUP BY STATUS or something. Having a number per status and type means they'll include some combination of two WHEREs

WHERE Status = x
AND n.customproperties.Node_Category like 'Office Router'

etc

randy7073

I apologize for not being very clear. Thank you for the Response. I'm trying to do a basic count of all the Office Routers that are Down, Critical, Warning, and Up. Then a separate widget for the all the Office FW's that are Down, Critical, Warning, and Up. Then separate widget for DATA Center A Routers, DATA Center A FW, and DATA Center A Switches then the same for Data Center B for a total of 8 different widgets. We have over 200 routers and 200 FWs. Everything I tried is lumping all the nodes together. I will try to play with it some more.

adam.beedell

You want a WHERE condition or several

Are you happy exploring the UI?

Am I correcting in thinking you want 4 KPI numbers per section (Down/Critical/Warning/up) and 8 sections (Office routers, Office FWs, DC A x3, DC B x3) for a total of 32 numbers?
(If so, seems like a lot, could do 3 Pie charts?)

randy7073

Sorry if I'm mistaken. Not necessary 8 Sections. I can do with 8 separate widgets. One widget for "Office Routers" another widget for "Office FW" and so on. I'm not familiar with the UI or the SWQL. I will be open to using pie charts.

randy7073

Should have put this early but basically all I got is "SELECT Count (Status) as value FROM Orion.Nodes WHERE (Status = 1). Every time I try to modify it I get this error "Provided SWQL query is not valid. Details: RunQuery failed, check fault information. no viable alternative at input 'Office Routers' in Where clause" below it I've tried

AND n.customproperties.Node_Category = 'Office Routers'

AND n.customproperties.Node_Category = 'Office.Routers'

AND n.customproperties.Node_Category 'Office Routers'

AND n.customproperties.Node_Category 'Office.Routers'

lol literally just guessing. I'll see if support will be willing to help me with this.