Comments
-
So I got into my lab and found that there must be some kind of limitation with this specific Top xx Component by Response Time resource. I tested where I could get it to display the ${applicationid} variable in the title or subtitle of the widget, but no matter what I did if I put any kind of ${anything} variable inside…
-
I did not, im on leave from a surgery and haven't been "on the clock" so to speak in a bit and my VPN is spitting out errors that I don't care to resolve until i go back to work. So most of those formats you have tried would be a SWQL style, but this widget specifically calls out in those instructions that its using a SQL…
-
So it sounds like you are trying to figure out which variable works in the ${} on the application entity view, have you tried = ${id} yet?
-
You could roll your own swql query to display basically the same things as the old widget. It's not a particularly complicated widget.
-
The current install model is basically to set up all the databases and software for every module on every install, regardless of what you currently use or don't. You can just stick it in the same place as your main Orion install and as long as you don't use nta it will be mostly empty, but having it all in place ahead of…
-
Seems like a really messy set of data, but if you want exactly the format you described at the top then this should work or be close SELECT SUM(case when n.CustomProperties.Media_Type_1 = 'fiber' or n.CustomProperties.Media_Type_2 = 'fiber' or n.CustomProperties.Media_Type_3 = 'fiber' then 1 else 0) as…
-
Just for the sake of clarity, are you using python or PowerShell? That's not the PowerShell syntax. PowerShell would be more like Invoke-SwisVerb $swis Cirrus.Nodes AddNodeToNCM 1325
-
At the end of your query add And unmanaged != 1
-
To be entirely honest I just jumped on board using the diagrams.net/draw.io/lucidcharts format with a vscode plugin because my old job has lucid licenses for me to abuse. Mostly made that move because I wanted all my data in a git repo and Orion was still using Atlas at the time. I mostly just showed my monitoring data in…
-
I can throw in my experience. I started as a network tech, then ended up doing a fair bit of server admin stuff at work, then got tasked with managing Orion, did that for a while and really got into it. In the course of having to do things in Orion I didn't like doing things one by one by hand all the time so I poked…
-
Anecdotally I have seen companies where data was not really leveraged well for a variety of reasons. Gaps in the originating the data - you built a hot new product but the devs were focused on just getting the features ready to ship, they didn't think ahead and implement the right kind of telemetry to capture critical…
-
The quick and dirty solution here is just to export a list of all your monitored IP's from old env and then put them into discoveries on the new environment. If you want to move over things like custom properties and SAM templates or NCM settings each of those adds some more steps, but as a general rule when I would do…
-
So the root issue you are dealing with is that each of those vendors reports their SNMP data in different formats and you want to try and make them the same. Unfortunately SWQL doesn't have very strong control over formats like that built in so you'll need to do quite a bit of string manipulation and math to get it…
-
There are a few built in ways to handle time of day stuff. You can set a schedule on the alert itself, so its only active during specific time periods, or you can set a schedule on the individual alert actions, so you might have it send an email during business house and trigger a page after hours. There's also the new HCO…
-
In solarwinds api terminology the way you invoke a verb (the pink things in SWQL studio) is to make a post to that endpoint with the required params, it looks almost identical to a create operation, but instead of just creating a row in the db and returning the ID for it a verb will do whatever it is that verb does and…
-
Ah yeah, one of the things that can sometimes trip you up is that the attributes are based on the real DB column names, but if you are checking in SWQL they occasionally have renamed how they display some of the column names to try and make them more specific. When in doubt use the database manager or SSMS and you can find…
-
This is a limitation of the SNMP counter for uptime, it rolls over every 500ish days . You can also reset the counter by stopping the snmp service. It's just kind of a lie that the field is called sysUptime, but thats par for the course with SNMP data.…
-
Like you mentioned, the maps would never be accurate from one instance to another, so there's not an OOTB export/import feature. If you are feeling fancy you could script something up that extracts all the map data, then identifies all the objectid's in it and looks up their details like captions or IP's in the parent…
-
Have you tried ${VirtualServerID} ? In most cases the way those variables on entity details pages work is they are exactly the same as the column names you find in the main database table for that kind of object, so for example if you see an attribute in the Nodes table, then you can call it into a nodes detail view with…
-
I've always been pretty negative on having alerts ramp up like that, it just feels like its destined to get spammy. If you aren't going to actually get up an resolve a problem at 20 and 10 then what's the point? Set your alert threshold at the point where you will actually fix the problem and when you get an alert you know…
-
So the thing to understand about NCM scripts is they don't have the ability to run a command, learn something about the result, and then take conditional action from what they learned. All the data you want to work with has to be in place before the script begins. Like @"sja" mentioned, you could write a config change…
-
In general terms this is the documentation you would want to be looking at https://github.com/solarwinds/OrionSDK/wiki/REST#create-request You don't pass in a projectID, if you send in a properly put together payload then it should respond with the projectid that the system creates. You can see that in your example where…
-
You'd have to be a lot more specific than "other" dns, and would probably get your best results by asking for script help at a forum for whatever DNS solution you use. And yes, in multi subnet situations the failover requires that the DNS entry is updated to route to the server that is currently active. Also the failover…
-
This is more of an Okta question, https://support.okta.com/help/s/article/bypass-mfa?language=en_US You just need to set up the relevant rules to bypass Okta for your service account used for testing the sites, its a fairly common use case for Okta admins.
-
Not possible via the GUI, it checks to make sure the settings you have provided are working, and for a down node they wont be. Just going to have to ask the team who will be turning them on to notify you when the nodes are up to be added. You could also work around it by getting into the DB/API and making direct edits…
-
The problem is that your prod database likely has relatively large tables of logs, and you are asking it to do a string match with several wildcards, which makes it impossible to use the indexes. So it has to scan every single log entry each time it runs. I bet if you could look at your event messages and get rid of the…
-
[quote userid="252284" url="~/products/network-performance-monitor-npm/f/forum/100790/brocade-sanswitch---not-all-interfaces-listing/316300"]all the interfaces in Solarwinds is same as the output of snmp walk[/quote]So if you want the behavior to change you need to talk to Brocade. Solarwinds just works with the standard…
-
I'd suspect the easiest way to do this would be something like this SELECT n.Name, n.Uri, n.Type, n.Category, concat('/Orion/Report.aspx?ReportID=',reportid) as NameLink FROM Orion.Report n WHERE Category LIKE 'X%' AND n.Name IN ('y', 'z'); Although as I read your query it does make me slightly crazy that you aliased the…
-
What you need to know is all covered in this migration guide. https://documentation.solarwinds.com/en/success_center/orionplatform/content/migrate_solarwinds_to_a_new_server_with_a_new_ip_and_hostname.htm Obviously skip the steps that don't apply since you dont have two servers, but it shows the tables that need editing…
-
Cooked this SWQL query up in my lab just now SELECT c.Application.Node.Caption as Node , c.Application.Name as App , c.Name as Component , cs.[Key] as [key] , es.Setting as script FROM Orion.APM.ExternalSetting es join orion.apm.ComponentSetting cs on cs.Value = es.id and cs.[key] = 'ScriptBody' join orion.apm.Component c…