cnorborg · Network Professional IV · ✭✭✭✭✭

Comments

  • Your missing the "SELECT" part of your query? Plus I think you're missing one of the tables your looking at? (ie: VolumesForecastCapacity)
    in Need to Forecast on fixed disks Comment by cnorborg March 2020
  • Don't forget the "Cirrus" tables also, lots of NCM stuff is still there, Cirrus was its old name. I didn't find anything initially. They might generate it on the fly. If they have the NodeID and the whole config in a string, I would think it would be a somewhat simple regex to pull out the correct interface through the…
    in Where does the "Interface Config" Widget Get the Config Data From? Comment by cnorborg March 2020
  • I have never seen any effort by Solarwinds to move towards Radius or TACACS for authentication. But they have implemented SAML, maybe that will work for you? There are a couple documents on Thwack and I think in the knowledge base on how to implement, here is one...…
    in Authenticate against RADIUS for website access Comment by cnorborg March 2020
  • Under "Admin" and "Manage Pollers" if you search for "VLAN" you will see the Solarwinds Native Poller for VLANs, is this assigned to the Juniper boxes? I don't see it being listed as a match for the few Juniper boxes I have...
    in NCM and Junipers and VLANs Comment by cnorborg March 2020
  • I believe what you are asking is in the Administrative Settings under "Manage Dependencies", there is an option you can turn on where it allows you to "Calculate Dependencies Automatically". You can also manage them manually if you want in the same place. Some might call the topology calculations it does somewhat analogous…
    in How do I start re organizing my solarwinds environment to be the Parent Child dependency Comment by cnorborg March 2020
  • What brand of switches? Most Cisco switch stacks it handles on its own, but it doesn't handle each switch separately - but as a stack. Even has a tab that shows the switch and power stacking configuration on the boxes in a stack. I believe most brands of switches are managed via a single IP for the stack. I would think…
    in getting trouble while adding stack switch in NPM Comment by cnorborg March 2020
  • I haven't heard anything about Solarwinds requiring upgrading at any time soon. So I would think performance-wise it would only be what SQL 2019 does differently that might help. I doubt the difference is big though. I've heard 2019 has a few performance tweaks that 2016 doesn't, somehow taking advantage of memory to…
    in Any reasons for upgrade MSSQL 2016 to 2019? Comment by cnorborg March 2020
  • Do you have "Allow 64 bit counters" checked in the SNMP settings for the node?
    in Interface Detail Real-Time Utilization Chart Shows Very High Utilization Comment by cnorborg March 2020
  • Just search for regular expression cheat sheet and find one that you like, they're all pretty good. Many STIG compliance rules don't "anchor" enough stuff, which means defining where the search starts, like at a beginning of a line, and where it ends, like at EOL. A simple string match, instead of a regular expression…
    in Compliance Reports and RegEx Doc? Also, RegEx/Compliance rule matching for network devices? Comment by cnorborg March 2020
  • I think you might be misinterpreting what dependencies are for. If you have a child/parent relationship like you mentioned, and the child goes down while the parent is down, you can use this dependency information to suppress the alert. I don't think SW forces the child down because the parent is down, it still gets…
    in Orion dependencies problem Comment by cnorborg February 2020
  • Pretty nifty report! Lots of work in that. I'm not a big fan of having "Report Writer" stuff on my pages, esp. Node pages where it gets referenced a lot though. Not to mention I'm becoming a big fan of SWQL, so... Here are a couple lighterweight versions of this report and resource that shouldn't tax your server quite as…
    in Resource to display unmanaged information on the node page including user info Comment by cnorborg November 2015
  • One big HUGE thing that needs to be fixed is multi-VRF support for devices like the Nexus 7K, which isolates each VRF's ARP table into a separate context. Right now I can only poll a Nexus 7K within Orion on a single context, thus I can only poll for a single VRF. We should be able to associate multiple SNMP contexts with…
    in What We're Working On for UDT (Updated August 10, 2020) Comment by cnorborg September 2018
  • But Grasshopper, don't forget those fields for which you do not display. Quite often the masters have already performed duties to make things easier on themselves, of which you - the student - should take advantage of... Instead of all those CAST's why don't you just order by the IPAddressN field? I will have to say using…
    in How to write SQL Query for Interfaces with IP Addresses Comment by cnorborg July 2015
  • Yes, one of the "Benefits of SWIS" is that you have "Insulation from Database Schema Changes", exactly the point your asking about. Other benefits listed include not having to have database credentials, it uses your Orion creds. I also like that it respects account limitations for what nodes/interfaces a user can access.…
    in How to write SQL Query for Interfaces with IP Addresses Comment by cnorborg July 2015
  • Caught your attention huh? Remember, this is the same database you work off of with SQL, your just going through the SWQL, which is part of the SDK to get to it. So the database on the back-end is still all separate tables and such. They did something I believe they call creating relationships between the tables to make…
    in How to write SQL Query for Interfaces with IP Addresses Comment by cnorborg July 2015
  • Now we just have to get you writing SWQL too! Here is your query in SWQL. Notice I'm only referencing 1 table instead of 3. @Anyone from Solarwinds! - This is the first time I've run across this, but the SWQL version of the "IPAddress" table I'm referring to below doesn't have "SubnetMask" as a field in it, so it's missing…
    in How to write SQL Query for Interfaces with IP Addresses Comment by cnorborg July 2015
  • I believe even though you discard the message the rules processing engine still retains the info until the rules are done processing. So, if you have additional rules that might trigger or do something else, they will fire unless you put this in. By putting in the "stop processing syslog rules" you make sure nothing else…
    in Tips and Tricks for Managing Traps and Syslog in Orion NPM Comment by cnorborg September 2015
  • There is even yet another way of doing this that might be simpler, depending on your environment. There is both a CDP neighbors table in NPM, which is what the link you gave leverages, and another CDP neighbors table in NCM, which of course means you have to be running NCM! Quite a bit of differences between the two…
    in CDP Neighbors Table Comment by cnorborg August 2016
  • Yea, looking through that a little bit, but I don't think the DestNodeID (and maybe not the SrcNodeID) directly relate to the Nodes table. Still trying to figure out what it relates to... But, I have noticed that the vast majority of my devices have both the "SrcInterfaceID" and "DestInterfaceID" set to NULL, or one or the…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • yea, still working on getting it purchased at our site, so no ability to open a ticket on it the usual way.. We want it for a lot of things, but the group that has money right now wants it to figure when IP Phones move for E-911 location tracking . Sounds like a no-brainer for UDT, but the MAC MOVE alert appears to be…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • Hmm... This is a demo/test environment and with the devices I mentioned most of them were just added and what I consider to be all of the relevant interfaces were monitored. Non-relevant interfaces would include Null0, Layer-2 VLAN interfaces, Management VLAN interfaces on Layer-2 switches. I usually turn off things like…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • Wishlist item already! You are already intelligently handling switch stacks for 3850's and probably other models, it would be great to see that reflected on the maps! ie: mapping them as separate switches rather than one.
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • Right now Geolocation is also "snapping" to the closest intersection for named streets. I'd prefer for it to use my longitude/latitude without this behavior. For example, at our site we have a couple switches that are in different buildings. You can see the two buildings at the top of the satellite picture, they do have a…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • In looking closer, the two that aren't mapping on this particular node both have "CONNECTS TO" set to "L2", while the node that is showing up on the map has it set to "1 Gbps". Could that be part of it? I did go look at the LLDP tables in SWQL Manager and it appears that everything that should be there is for that table at…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • Hmm.... I can see how the "FastEthernet0/3" in the above example isn't part of the mapping due to it being down? In my environment I'm seeing 3 connections in "NPM Network Topology", but only one on the map. Two of the "WITH INTERFACE" columns are "Unknown", while one of those two has the "INTERFACE" column set to unknown.…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • So, how does it work? In our environment we have LLDP enabled, but not CDP. Is it working off that data or what? When I enabled it, I saw a map on one of my core switches for a little while, but it disappeared. Now I'm not seeing anything even though our core switches are a full mesh and I have a few other switches which…
    in Orion Platform 2018.2 Improvements - Chapter Two - Intelligent Mapping Comment by cnorborg June 2018
  • Do you have NCM? His script requires it.
    in CDP_Neighbor_Resource_v2.SWQL Comment by cnorborg September 2018
  • Hmm... Doesn't look like SWQL, is this full on SQL? If so, it won't work as a resource in a Node Details page...
    in CDP_Neighbor_Resource_v2.SWQL Comment by cnorborg January 2018
  • Actually, if I remember right, both NPM and NCM do their own CDP neighbor. I believe you can get it without NCM. Pretty sure I discussed that somewhere here about how they differ a bit...
    in CDP_Neighbor_Resource_v2.SWQL Comment by cnorborg October 2017
  • Just off the top of my head, won't have time to look at this for a couple weeks, but probably a "yes" to both. The SWQL I used for making the resource could probably drop into a web-based report, although you'd have to specify the Node unless maybe you wanted to do it for a bunch of nodes. In the reporting side of things…
    in CDP_Neighbor_Resource_v2.SWQL Comment by cnorborg October 2017
Avatar