Comments
-
Unfortunately, DNS is not accurate 100% of the time either. What I've noticed is that in the web GUI if I was to edit a node leave the name blank and save, the name automatically gets updated to the sysname (polled via SNMP). I'd really like a way to figure out how to do this programmatically considering we have over 100+…
-
Thanks for the confirmation. Does the ability exist to query this data via SWQL? and pull back the counts similar to my original query?
-
Yep, that's it. Thanks for the clarification!
-
Thanks. This is nice, but it's just concatenating the configured IP and mask. I'd really like to see if it's there exists a variable or some way to pull back the actual network identifier, like how my original post outlines if we have a configured IP of 10.10.10.0/24, it'd return 10.10.10.0/24
-
I found this link which shows how to do what I'm asking with respect to custom variables, but I'd like to see if it's possible for non-custom variables such as last boot. Any ideas?
-
For anyone who comes across this, note that the switch stack poller can only apply to nodes that have the "StackPort" or "StackSub-St" ports in "List Resources" of the node. Even if you have a single switch, you need to specifically manage StackPort1, and then the Switch Stack poller will show as an exact match.…
-
I've been able to make some progress with the following SWQL query: select n.nodename, i.InterfaceName, i.OperStatus, toutc(i.LastDiscovery) as [Last Discovery] from orion.nodes n LEFT JOIN ncm.interfaces i on i.Node.CoreNodeID = n.NodeID where n.nodename like '%NAME_OF_MY_NODE' and i.InterfaceName not like 'Stack%' and…
-
I ended up opening a ticket with SolarWinds support, and although it took weeks, they finally reported this as a bug and provided me with two SQL files that were used to update the SQL database, and it looks like that did the trick. I can finally link both nodeid & corenodeid again.
-
Thanks again for your help with my issue. I updated the code to include the WHERE statement that you listed above: SELECT c.RemotePlatform, c.RemoteDevice from orion.nodes i LEFT JOIN ncm.ciscocdp c on c.node.CoreNodeID = i.NodeID WHERE c.RemoteDevice NOT like 'Null' AND c.RemotePlatform LIKE '%AP%' The above code works,…
-
Below is the full code block that that previously worked, but no longer does now due to the fact that c.node.CoreNodeID shows as NULL for 95% of all results. SELECT i.CustomProperties.region, c.RemotePlatform, c.RemoteDevice from orion.nodes i LEFT JOIN ncm.ciscocdp c on c.node.CoreNodeID = i.NodeID where c.RemoteDevice…
-
Hi, Thanks for your response and taking the time to help me with this. Breaking this down into simpler terms without a join: select c.CDPIndex, c.node.CoreNodeID from ncm.ciscocdp c I see 6419 results, BUT only 84 of those results show a value in the CoreNodeID. This is the crux of the problem. If all of those results did…
-
Thanks for the feedback. I've rediscovered devices, I've force refreshed, and there doesn't seem to be anything I can do as far as getting the Switch Stack poller to show as a match.
-
Thanks for the feedback. If I had one or two devices with this issue, then no problem, but I have 73. I'm hoping that there is another solution.
-
Thanks for the quick response. What exactly am I looking for within list resources? For the one node I am testing with, both Hardware Health Sensors, Topology: Layer 2 & 3 are already checked. I compared the list resources against an identical model. The only difference was that under CPU & Memory, it was selected as Cisco…
-
Hi, Thanks for your response. That query did not work for me in SWQL. I don't see anything called NodeCiscoCdpEntries in the object explorer. I've also tried the following queries: select c.DisplayName from orion.NodeCdpEntry c -All 6521 results are NULLselect c.CiscoCdp.DisplayName from ncm.Interfaces c -no results select…
-
Thanks, I ended up doing this. For anyone who sees this and is having the same question, create a Universal Device Poller with the following OID for the standby supervisor serial: 1.3.6.1.2.1.47.1.1.1.1.11.500This should work on any device where the machinetype is Cisco Catalyst 4500 L3
-
Thanks for your quick response. The IFRAME code is about as straightforward as it gets: <iframe id="inlineFrameExample" title="Inline Frame Example" width="1200" height="800" src="">solarwinds.MYSITE.com"> </iframe> I enabled console logging on Firefox, and am seeing the below messages logged: Strangely, in Chrome, I see…
-
Please refer to this thread, where a user created the custom query: thwack.solarwinds.com/.../302958
-
I truthfully cannot thank you enough. Using your query and modifying it slightly to include some custom properties, I finally am able to report on exactly what I am looking for. Hopefully other people can find this as well, as I think it's incredibly useful.
-
Thanks for your reply. We manage 3000+ nodes within SolarWinds, and it's exceptionally useful to have devices log via syslog/log viewer so that we can monitor and send alerts for anything that we deem to be critical. If a device is not successfully configured and/or reporting syslogs to SolarWinds, then I would like to be…
-
I've also been trying to figure this out as well. I don't think that there is an easy way to do it, it's likely going to involve a custom SQL/SWQL script. Have you made any progress or found any way to successfully do this?