mesverrum · Observability Architect · ✭✭✭✭✭

Actually I think I was the one talking about the wrong thing. I went into the db thinking I was looking for the automatic credentials info instead of the device templates. You are right, I believe, it is supposed to try and match them up based on systemOID, but I've never really experimented to see how it deals with things…

Its helpful to have the more specific breakdown of nodes/interfaces/volumes as each of them has a different polling effect Did you load up those queries to verify the intervals between everything is the same, including any one-off modifications? There weren't any dramatic changes to the way polling load was calculated, and…

When I get back to the office I can check but I'm pretty site either the custom object resource or the custom chart resources could do this entirely with native gui functions.

Yeah, my typical layout for a component alert is usually something like this: Component ${N=SwisEntity;M=ComponentAlert.ComponentName} is ${N=SwisEntity;M=Status;F=Status} on ${N=SwisEntity;M=Application.Node.Caption} - ${N=SwisEntity;M=Application.ApplicationAlert.ApplicationName} Current Statistic Value:…

Leandro, honestly it sounds like a brutal mess but I would also second the idea of starting fresh, hosting a 'historical' copy of data for anyone who needs it, and migrating everything over. I'm going to jump into a thread with you and Doug Keyser when I get back on the ground this weekend. It pains me to see how you've…

There is a tool to set custom properties in bulk, setting 100 nodes should take just a few seconds. You can get there by going to https://YOURSERVER/Orion/Admin/CPE/InlineEditor.aspx​ The technique being described by vinay.by​ is described here in more detail Using Custom Properties sending Alert emails The tricky thing…

That is because this is a SWQL query, the table names are different in SWQL compared to SQL. Rather than adding in an advanced SQL report just look for the Custom Query resource and use it there. -Marc Netterfield Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1…

That would skip over SQL components, check that some list for something along the lines of exchangedatabase instal of sql.

This is what I have for MS and sql stuff on mine and

So when I run this in my swql studio on my lab it seems to work, i just had to add the select and define the o as an alias for Orion.AlertObjects. Unfortunately my lab is pretty freshly rebuilt and didnt have any alerts for me to confirm the criteria with but I would think instead of matching against the triggeredmessage I…

That would be in part of the action. Like I said, nothing you do in custom sql from the trigger will carry over to the action, so you have to recreate that statistic on the action side as well. You would want to modify the query so that the answer it gives is just that one single stat for a specific interface instead of it…

Normally if I can't do it in swql I wrap the whole query up in powershell and do my manipulations and parsing there.

You can do customized icons and links, but if I recall correctly from past experiments it won't parse html. Here is a custom query example for a summary page that has the syntax for links, icons, and a case scenario for using different icons to represent a condition. SELECTn.caption as Node,…

Here is a Custom Query that I use to to show all alerts that have fired on the current node. You can use this as an example of a query that should work fine. If this doesn't work your software is broken in some way, but if it does work then you have something wrong in the syntax of the query you are building. select…

Patch Manager is essentially just built on top of the existing WSUS functionality inside Windows. Whenever you ask "what will Patch Manager do in this scenario" then you really just need to find out how Windows normally does that without PM, the answer will in almost all cases be that PM does it the same as WSUS does. So…

Release v2.0.50 · solarwinds/OrionSDK · GitHub It is part of the SDK, and if you are trying to figure out the tables and such without it then you are going to have a painful time. The thing to keep in mind is that SWQL is sanitized to be read only so any commands that would impact the contents of the database probably…

This query is written in SWQL, not SQL, I should have specified that. You should be using it inside a custom query resource in the web console.

I'm going to go back to my earlier statement that if you aren't strong in coding to begin with then this is likely to be a much much slower process to learn than just building a few map layouts in Atlas. If you are looking at it as a challenge and an excuse to expand your technical skills in a non-production environment…

Adding to cnorborg​'s comment about the SDK, if I was going to undertake this mission I would start by digging into the docs for any of the open source tools that the various task forces around telemetry have put together to subscribe to and receive the streams. You are going to have to build something that takes the data…

I don't use powerbi enough to know if it can parse json natively, but if it knows how then there's really nothing to stop you from connecting to the API and pushing SWQL to it rather than direct SQL.

Those are the first things off the top of my head, I find that whenever NTA is giving me a hard time with something one of the best ways to be really sure what is going on is to run a few minutes of packet capture on the orion server to make sure the flow packets are arriving and that they are showing everything I think…

There's no good option for piping metric data directly into orion. The api *could* be used to do it, but the application as a whole would probably not be happy with you because it was designed with that kind of flow in mind. Orion assumes that they will be the ones collecting metrics, its not just a time series database…

Just picked the columns that I was looking at, endpointid should probably work just fine. In my lab that Orion.UDT.MACAddressInfo had some 37000 entries and we barely use the lab here so I could imagine it being a beastly table to work with in a bigger environment. I only spent a short time playing with it so there may be…

You just have to put that redundant hardware into a group and set that group as the parent, what problems are you experiencing?

This is incorrect, dependency trees in orion are entirely based on up/down status of whatever the parent object is. You could make the parent a firewall, server, router, or even an app monitor, or group. Orion will take any parents you tell it to use, and as soon as that parent object goes down it will trigger the…

Yeah I would go with the first option, its probably counting something else. What exactly it is counting is the mystery. My lab also has 0 for that number. It's possible that it could also be counting something that was deprecated before your APE got installed? 

Looks like the api will only allow read operations against orion.actionsassignments directly, but you have this table of possible verbs to invoke…

So I would say this is less of a bug and more of a non standard snmp "feature" that Cisco has implemented. They have it documented various places but I am not aware of any other vendors who do it the way Cisco does. SNMP Community String Indexing - Cisco I looked at the IETF standard for the bridge mib's and really cannot…

For ssrs based reports we usually just embed html widgets in Orion to be able to access them from "within" the web console. It does cause a situation where end users can't create that category of reports on their own in the native console, but if they NEEDED it and knew how to work in SSRS I'd just give them appropriate…

The value that Solarwinds displays for WMI node location is the AD site name. It always has been like that, see this screenshot from my lab, i'm sure you can guess how we set this one up. There is no option short of database hackery to change these values. In SAM you could set up a powershell monitor to display the…