k_barton

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?