zackm ✭✭✭✭✭

This sounds like a good scenario to use a custom property. Can you define your group a little more? What constitues membership into the group? -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

i'd start with a verification that the data actually exists and is current: select n.nodeid ,n.caption ,cp.uniquename ,cps.status ,cps.datetime from nodes n join custompollerassignment cpa on cpa.nodeid = n.nodeid join custompollerstatus cps on cps.custompollerassignmentid = cpa.custompollerassignmentid join custompoller…

You should be able to setup a test node in NCM and then inject the configuration into the database (ConfigArchive table). I haven't tested this, so please backup your database before attempting. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems *…

Generally the recommendation would be to monitor the clustered services against the Cluster IP or VIP. This way, your application monitor is more reflective of the actual user experience. For instance: Cluster VIP - Added as an ICMP-only node to Orion and all application monitors are assigned here Server A/B - Added as…

If that's the data you've got in the "Message" field in the alert configuration (the text box on the trigger actions tab); you'll want to use the Orion.AlertActive.TriggeredMessage field. Otherwise I would recommend updating your alert names to be more descriptive perhaps. We use a naming standard similar to this so we can…

would it not be easier to use the GUI for this?

Warehouse your current DB. Do a fresh install of the 2 new environments (new discovery, new everything) and use SSRS for reporting with SQL across the 3 (2 new 1 warehoused) databases. The problem with splitting/joining any SolarWinds database is that there are unique IDs on a lot of important points that are not easily…

Use a "Custom Table" resource and build a report widget:

Here's a SWQL that should get you started in the right direction. There's not a "Between" function in SWQL, but there is the ability to "floor/truncate" and compare dates. SELECT TOP 10 r.NodeID ,MIN( r.DateTime ) AS [OldestRecords] ,MAX( r.DateTime ) AS [NewestRecords] FROM Orion.ResponseTime r WHERE ( r.DateTime <…

That doesn't look like a built-in report. You would need access to the report definition file or the Report Writer application on the server to get the SQL query from it. Alternatively, you could screenshot the entire report and place it here to see if we can replicate it for you. -ZackM Loop1 Systems: SolarWinds Training…

during the migration your additional pollers and web engines will be inaccessible. you can either leave them online and they will reconnect after the migration is completed or you can stop services on all of them and then restart them after you have the new primary polling engine fully operational. either way you should be…

try this: ${SQL:select case when ${nodeid} in (select nodeid from vim_virtualmachines) then 'VIRTUAL' else 'PHYSICAL' end from nodes} -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

If you are looking for nodes that have been set to be unmanaged starting in the future, you can use this: SELECT CAPTION AS 'DEVICE', IP_ADDRESS AS 'IP ADDRESS', UNMANAGEFROM AS 'BEGIN UNMANAGE', UNMANAGEUNTIL AS 'END UNMANAGE'FROM NODES WHERE UNMANAGEFROM > (GETDATE()) If you are trying to use SQL to set devices to be…

What are your products and versions that you are using?

Try removing the ORDER BY at the bottom; also, you might need to wrap your aliases in brackets [ ] instead of quotes " "

Can you provide the alert definition you are receiving false positives on? It would also be helpful if you could describe a little more detail. Are you only seeing these errors on certain models of devices? If so, are you using the most accurate OIDs to poll them? Etc etc.

If you are referring the the ICMP/SNMP status of the node (signified by a red icon next to the node name), then the most likely culprit is an ACL blocking ICMP and/or SNMP Port 161 communication between your SolarWinds polling engine and the target device. If you are referring to the guest status of the VM through the…

You cannot use a wildcard with SWQL queries. You'll need to explicitly request all of your columns by name. SolarWinds Knowledge Base :: How to use SolarWinds Query Language (SWQL) -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

I *think* that field is a dinosaur. I cannot recall ever seeing it populated. Though it might populate for active alerts (I don't have any active in this environment to verify right now) As for your second question: UPDATE AlertStatusSET AlertMessage = "Your Message Here"WHERE AlertDefID = 'AlertDefID-Here' With the caveat…

you would need to create multiple alerts and limit them to specific objects. usually this is done using custom properties. for instance: node custom property 'Team' Values: A, B Alert 1: Alert me when Node.Status = Down and Node.Team = A Alert 2: Alert me when Node.Status = Down and Node.Team = B Alert 3 (Catch-All): Alert…

Are you trying to find a way to put this data in a report? If so, it's just the standard bandwidth metric. Those custom values go into the same column as the SNMP-polled values in the database. You can verify by querying your database for any interfaces that have a custom value set: SELECT n.Caption 'Node' ,n.IP_Address…

SolarWinds Knowledge Base :: How to create a non-administrator user for SAM polling. Please take note of the first paragraph... You really should be using an administrator-level service account for best results, word is that the KB steps sometimes end up conflicting with existing GPOs and you end up where you started. But…

Node Name has changed relies on the 'Node.Caption' entity; which isn't the same as the SysName value which I think you're looking for. Basically, the node 'Caption' is created when you add a node based on the following: * SysName from WMI/SNMP/Agent * If no SysName, then DNS resolution from IP * If no DNS, then IP Address…

So what is the identifying metric for when a tunnel goes down? Alert me when A is B What is the A and B here? Once we have that it will be easier to assist you. Couple of questions/assumptions - djb232 wrote: I can pull the peer ip's with cikeTunRemoteValue and I can verify tunnels are going down with crasL2LNumSessions…

Luckily the built in alert object looks at a proper view with all the details you need. For an alert: SELECT VirtualMachinesView.VirtualMachineID, VirtualMachinesView.DisplayName FROM VirtualMachinesViewWHERE VirtualMachinesView.NodeID IS NULL For a report, you can see the following out of the same view: SELECT * FROM…

What version of NPM and NTA do you have installed?

1) Test fires don't count. (They actually just test the ability of SolarWinds to perform a trigger/reset action; they are not testing the trigger/reset conditions) 2) Check out your alert evaluation frequency for that specific alert. If it is > 60 seconds, you will be getting "delayed" alerts. 3) Check your trigger and…

can you run that query directly against your database and get results? -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

Not LEM, but could easily have been used in that way: A few jobs ago, I was a contractor for a large federal agency where we installed SolarWinds for one of their departments. They had a pretty standard setup that included, among other things, UDT and NTA. Being a federal agency, there were certain rules for usage and no…

1) It depends on what you are defining as 'Availability' (this may sounds like a dumb question, but trust me when I say there are a lot of people who have completely different definitions of what true availability is) 2) ABSOLUTELY! That is easily accomplished by creating a custom property for your interfaces, marking the…