mesverrum · Observability Architect · ✭✭✭✭✭

Comments

  • Agreed, I generally steer my clients to not waste consulting hours on trying to turn NPM into Prime if they already have Prime in place. Always felt a little half baked in comparison.
  • Well that value being Default basically means you are in the default report group, that's why the second step is to go to the manage reports section and confirm that the report you are having trouble with isn't tagged with some limitation other than default. If it is, then I suspect that is your problem. I almost never use…
  • SNR would be nice, but I think that since it isn't always available in SNMP the Orion devs opted not to collect it, since it would be blank for a significant portion of devices, not even all Cisco wireless systems support it. You could just add a custom UNDP for it on your WLC's for your use case. Signal strength is…
  • Custom Alert SLA Report --report on alerts triggered select ac.Name ,ah.Message ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:'+ToString(AlertObjectID) as [_linkfor_Name] ,case When RelatedNodeCaption!= EntityCaption THEN concat(isnull(RelatedNodeCaption,''),' - ',isnull(EntityCaption,'')) else EntityCaption…
  • Adding on to this, you won't get very far at all in doing SQL work against the database without installing SQL Management Studio and connecting it to your database to see whats out there. As a less powerful alternative you can also browse the tables with the Database Manager tool on your main Orion server. I can't imagine…
  • So the new product gives you the option to set up web based orion alert actions from trap data without resorting to SQL. The big gap that they seem to have missed was that they no longer parsed the varbinds into separate entries that you can pick through and use in your alert messages and actions. They replaced them with…
  • Inside the Component settings you typically have a very limited subset of available variables, i believe most of the components only allow for the ${ip} and ${port} variables, so you will be unable to set the component to work by hostname. The closest you could do is set the node itself to use DHCP, then any changes to the…
  • Doesn't it tell you that first thing? So step one, upgrade OS. I can see the benefit in knowing the whole path you need to take before you start trying to schedule a maintenance window though, haha. I just upgraded a client from 12.1 on Server08 and Sql08 to some fresh 2016 servers and sql 2017 running the latest versions…
  • Agreed, for this scenario you arent exporting out the chart or anything related to things you build in the GUI, you just give the tableau system a service account directly into the db so they can pull out what they need. Their tool already has lots of capabilities around connecting to existing databases and they will most…
  • i guess if you were really hardcore about it you could set up your own db table and cook up some kind of external script that you would call to have them write up some kind of alert rule action log, but that's maybe pretty heavy customization. for something that is already a solved issue in current releases.
  • I would second the suggestion from above to install swql studio on your server and test it there since the error messages in swql studio are much more specific. I can't see any reason why the query is not working for you but has no issues for the rest of us.
  • Everything I have found on the Microsoft forums indicates that there is no programmatic way to actually test an RDP connection to a remote host, you can test if you get a response on the port, but everything beyond that is invisible. It is possible to initiate an rdp session from a command line but no status is returned to…
  • I think the typical thing to do here it's probably run the configuration wizard and call support
  • To add on for @"rgarciar1801" using this method you wouldnt have a looping prompt to ask you for the new names at run time, you would set up a custom property on the nodes and set all those values ahead of time, then the script just reads the value from the node custom property and does it. From a programming perspective…
  • That makes sense to me. I can't think of anything that IPAM polls that would tell it the gateway for a given subnet, so you just have to tell it.
  • Traps are outbound messages from the node to a trap server, that normally always happens on port 162. This is really totally unrelated to the snmp requests that happen on port 161. Its more similar to syslog messages on port 514. You shouldn't have anything to do with radius also, traps are not authenticated anywhere. They…
  • Expanding on Tony's macro suggestion, I once had a client who was essentially an MSP that took pictures of where their assets were physically located in client sites so that later on when the techs had to go back they'd be able to find things more easily. They wanted those photos to show up as a tab on node details so the…
  • https://support.solarwinds.com/SuccessCenter/s/article/Unable-to-open-new-database-connection
  • There isn't an out of the box way to make this happen but something could be scripted up. Muting is available via the API so you would set a script up to mute your top device, then query any devices that are children of it, mute those, look up any children they have, mute those, loop until there are no more children left.…
  • I've done it both ways, usually depends on access levels. If the app team has admin in Sam but maybe the systems team normally manages nodes and the related alerts then I can offload the responsibility of the custom requests to the app team by giving them their own template and letting them go crazy with it. It does create…
  • So the SDK doesn't directly expose this for us to modify, you can Read them via Orion.APM.Threshold or Orion.APM.ThresholdsByComponent but the tables don't support any edits via SWQL. With that said, you definitely can manipulate them in SQL, and you can use the SDK as your gateway to the SQL if you don't want to have to…
  • I've written SQL reports like this before, but it is computationally very expensive because at the time you run the report it has to find every timestamp that goes over the threshold and then start comparing them to the future timestamps. The way I learned that was MUCH more efficient to just create an informational alert…
  • Yeah, the only way to do dependencies is with groups. The group status update is under Manage Groups>Edit Group>Advanced I do not believe that additional pollers will help with the group status workload but I've never really tested that idea. I believe the majority of that load falls to the core application server and a…
  • The majority of what goes into the event log is not from alert actions, its just how SW tracks internal stuff. Both of the examples you gave look like they are built in events that you can't control.
  • Yeah, typically I see people use that counter in association with folders that feed batch jobs. If the job fails then the files start piling up and you say something like "if this folder goes above 100 files then something is probably broken"
  • Do you have an inventory job running on a schedule?
  • How have i lived without knowing about this feature?
  • So in this case a top x is much more computationally efficient than a where by itself, the top command just pulls data until it's done at that max number of entries, the where logic is still evaluating all of the entire history of every interface to see if they match the condition (default settings would have data points…
  • It's a SWQL query, I generally use it as part of a custom query widget or custom table data source.
  • Slow response, i looked at the db in the environment I'm in yesterday and saw what you mean, the weight didn't appear to be directly a 1 to 1 counter of the number of polls, most of mine were about 3600 for the 1 day aggregates, since there are only 1440 minutes in a day and we only poll every 9 minutes there is some step…