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:
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:
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.
I'm sorry but I don't understand your query - can you rephrase it please as I have clearly misunderstood your request?
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.
Ahh right ... in which case you just need to edit your WHERE query...
So something like: WHERE InterfaceCaption LIKE '%nc-%'
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.
@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.DetailsUrlFROM Orion.NPM.Interfaces IWhere I.Node.Caption like '%nc-%' or I.Node.Community like 'secretcommunity'