jellobones ✭✭✭✭✭

You can just add all the other fields you need in your report but you could start with something like this SELECT n.Caption FROM Orion.Nodes n WHERE n.Status = 2 AND n.NodeID NOT IN (SELECT ID FROM Orion.AlertSuppression)

Sorry had a typo on ContainerMemberDefinitions, please try it now. Select SQL.

Try this: Nodes.Caption NOT LIKE 'SWITCH1%' AND (Interfaces.Caption NOT LIKE '%Core%' OR Interfaces.Caption NOT LIKE '%Dist%')

Can someone clarify that please... With NAM, APEs are free up to 100K elements? Is that correct?

gd.Expression is a field with the filter/condition value that actually builds your dynamic query. If you do not need to see that then you can just run this: SELECT g.Name, gd.Name FROM Containers g INNER JOIN ContainerMemberDefinitions gd ON g.ContainerID=gd.ContainerID WHERE FromClause IS NULL ORDER BY g.Name

Been there done that... the module versions I believe are current... offline/online installer seems unusable at this point. Opened a case with support and they can't figure it out either. I went as far as removing everything and reinstalling everything and still ended up with this.

general purpose... to remove or update a module...

Fantastic!

* Remote Collector - New, agent based collector for distributed environments and hybrid deployments Is this going to be like a mini Additional Poller?

So you just wanna chart any interface that hit 90% utilization correct? How many interfaces are we talking about? Depending on the number of interfaces that could be reporting a 90% utilization, this may not be legible in the chart at all. You may be better of reporting on a table. Getting your timestamped utilization per…

I have something similar. It loads up but does not seem to have any data.

Just so I'm understanding this correctly, you want an alert to trigger when a ticket is created in whatever system you are using? If so, wouldn't your ticketing system already have the ability to generate such an alert? If the gaol is to maybe associate a ticketed incident to an event in Solarwinds like an outage of some…

There are several ways you can do this. You can create a group called 'TEAM' Settings > All Settings > Manage Groups (Under Node and Group Management section) Click on ADD A NEW GROUP | Specify TEAM as your group name Under Available object, Select Nodes (Show Only) and select Nodes1-6 OR create a dynamic query | Create…

Had a client who required that the provider edge interfaces are monitored for latency. The only way I was able to do it was to create ICMP only monitors on the interfaces and tagged them with a value that I could later JOIN ON to associate the node object(interface IP) to the interface object. So if you call the ICMP only…

I personally would just add the interface in the group. Changing the node's status to Warning via an alert due to an interface going down would add another unnecessary layer. So let's say the alert did not trigger and of course that's never happened bafore . Then you're back to square one. Second scenario is let's say…

Hope this helps... added the gd.Expression just in case you need to see the actual filter. Simply remove it if you don't need it. SELECT g.Name, gd.Name, gd.Expression FROM Containers g INNER JOIN ContainerMemberDefinitions gd ON g.ContainerID=gd.ContainerID WHERE FromClause IS NULL ORDER BY g.Name

You're going to have to alert on Nodes using a Custom SQL Alert: Where NodeID in (SELECT n.NodeID FROM (Select NodeID, Status FROm Nodes) n INNER JOIN ContainerMemberSnapshots gm ON n.NodeID=gm.EntityID INNER JOIN Containers g ON gm.ContainerID=g.ContainerID WHERE g.name = 'Radios' AND n.Status = 2)

This alert will trigger on the node. You should be able to use the standard variables to build your alert content. If you need to create custom SQL queries as a variable, you can key those off using ${N=SwisEntity;M=NodeID} Create a Custom SQL Alert to trigger on Nodes: --- cut & paste --- WHERE Nodes.NodeID IN (SELECT…