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 - top 25 Errors & Discards Today

Hello, could you tell me how to add to modern dashboard this widget with links to node or interface ? I would like to see it in this form:

Find more posts tagged with

Accepted answers

All comments

stuartd

You need to ensure you have the xxx.DetailsUrl record in your select statement - where xxxx. = nodes or interfaces accordingly.

Then in the edit box for the relevant section, ensure it looks something like:

KwiQ

thanks for repply, i have already did it by swql:

SELECT TOP 100 n.InterfaceCaption,n.InErrorsToday,n.OutErrorsToday,n.DetailsUrl
FROM Orion.NPM.Interfaces n

But is any chance to filter this outputs to node caption or snmp community ? I would like to show errors ony on one type of devices.

stuartd

[quote userid="287227" url="~/product-forums/network-performance-monitor-npm/f/forum/97879/modern-dashboard---top-25-errors-discards-today/308139#308139"]But is any chance to filter this outputs to node caption or snmp community ? I would like to show errors ony on one type of devices. [/quote]

I'm sorry but I don't understand your query - can you rephrase it please as I have clearly misunderstood your request?

KwiQ

sure, sorry if i was not clear enough. I have a query that displays all interfaces with errors (from all nodes), is it possible to limit this query to specific nodes only ? For example, I would like to display errors on device interfaces which have "nc-" in the node caption.

stuartd

Ahh right ... in which case you just need to edit your WHERE query...

So something like:

WHERE InterfaceCaption LIKE '%nc-%'

KwiQ

thanks but i'm affraid not. I already did it. I would like to have in query

"where nodeCaption like "nc-"

but Nodes Data is different database table so it should be joined somehow to interface table.

jm_sysadmin

@stuartd Was pointing you in the right direction, you just need to apply it to your case. I changed the alias of N to I since this is the interface view, later if you cut and paste from old queries, I find that it helps to name them the same way each time, and in a way that you know that n.displayname is from nodes, and I.displayname is from interfaces, or whatever other table you query. Also, I used the linked tables to get to the node properties, much easier than using JOIN statements. If you install the SDK you get a SWQL studio, and it will show you the built in relationships.

SELECT TOP 100 I.InterfaceCaption,I.InErrorsToday,I.OutErrorsToday,I.DetailsUrl
FROM Orion.NPM.Interfaces I
Where I.Node.Caption like '%nc-%' or I.Node.Community like 'secretcommunity'

jm_sysadmin

One more thing you grabbed the top 100, you might want to sort it to get the 100 you care about.

Something like
Order by I.InErrorsToday DESC

Just add it after the where

KwiQ

ok thanks, its almost all what i need. Is possible to get "node" column in this widget like in older one ?

stuartd

In the select line you need to add the table for node caption, then it will appear in your results so that you can add the column.

It should look like this:

SELECT TOP 100 I.Node.Caption, I.InterfaceCaption,I.InErrorsToday,I.OutErrorsToday,I.DetailsUrl

KwiQ

Awesome, its exactly what i need. Thank You.