antonis.athanasiou · SolarWinds and monitoring Consultant · ✭✭✭✭✭

You are right, this will take 1 component out of your SAM licensing. You can leverage NetPath though, as lcsw2013​ suggested above in Re: Port monitoring which is a combination of ping+TCP connect. Bear in mind though you will need to setup different type of alerting (Trigger Object is now NetPath instead of SAM component…

dan jagnow​ is this for the website certificate or the SWIS REST API Endpoint? I was under the impression the self-signed certificate found on port 17778 cannot be changed as described here:

Let me know if that was successful. I've found an old thread about changing the certificate however it is old, a lot of things have changed since 2013 and I've never tested it myself. Better to well-test it in a non-prod system first: Change SolarWinds Information Services SSL Certificate

Is this a good start to reference? I'm not so experienced with python: orionsdk-python/add_node.py at master · solarwinds/orionsdk-python · GitHub

This is not an expected behaviour, have you tried with a different web browser?

NetObjectID is actually a great asset to work with! Did you manage to get it working on a custom query? both ${NetObjectID} and ${Caption} are giving me the infamous 'Error: A query to the SolarWinds Information Service failed.' SWISv3 logs "ErrorMessage = SolarWinds.Data.Query.ParserException: Cannot resolve property…

Hi Tony, While this is accurate, what happens if SAM is also installed, which should give the flexibility to monitor interfaces by WMI ? I've just tested in my environment (NPM+SAM+ a few others) on a WMI monitored Windows node and I'm getting 'Invalid Node', which I assume is the error message deekshitha is also referring…

I don't have any exposure to PA, but is there any chance you can get the value you're looking for by using SNMP (-> UnDP etc)? that would be ideal. if not, mesverrum​'s suggestion is the way forward. I wouldn't recommend injecting anything in the database as there is no way to guarantee the data in there after a DB…

I agree in principal and logic though I could not stop myself from commenting the typo 'cpuload is <90', that should be >90. (sorry, carryon! )

There's actually a way to create a custom table with colours/styles by injecting javascript into the custom SQL and making that column 'HTML friendly' reference back to Re: Change Row Colors in Reports which I used previously on a project, unfortunately I do not have a copy of that code anymore.

Hello, The NodeID is an integer and therefore you can skip the quotes from your select statement. also, the datetime format is like the following: '2020-02-17 07:30:09.13' SELECT TOP 10 a.NodeID, a.DateTime, a.Message, a.level, a.LogMessageSource.Caption from Orion.OLM.LogEntry a Where a.NodeID = 561 and DATETIME BETWEEN…

Hi Jeff, Thanks for the quick response! I've confirmed that it works, however the end goal here is to restrict the specific account to a limited resultset within the NCM entities (Config Archives in specific) I feel it is really necessary to ensure that account limitations are applied to other data entities exposed by the…

It may worth checking the AlertHistoryView table and apply an appropriate filter to check whether any records exist in the database. All alert triggers, resets and actions (including manual clearings etc. if memory serves right) are logged there. Take a note of the AlertObjectID for the triggered alert in question and…

Hi Tom, thanks for reporting this back to the dev team and for the feedback! the actual query is more complicated and the concern is the performance impact with multiple SELECT statements. while this will work for now, I'm really looking forward to seeing more clauses included in SWQL Antonis Athanasiou Prosperon - UK…

Hi Johnny, Thanks for your contribution on this one. Unfortunately I haven't performed any benchmarks on different methods/tables/NTA entities. Have you tried connecting SWQL Studio to Orion with SWISv2 rather than v3? Different service, may have different methods

Hi, Thanks for the walk-through, however your method defines a static selection of NodeID(s) where I need a filter mechanism to select the top X (Conversations by total bytes) out of the top Y (Nodes with most NetFlow traffic), where the NodeIDs are not known prior creating the report.

Just seen it mesverrum, here it is : Custom Query resource with colors and styles I'm also (trying-to-get-some-time-to-work-on) creating progress bars but it is just a little bit harder than anticipated so far..!

In my case, I had to block all external connections from 'c:\Program Files (x86)\SolarWinds\TFTP Server\SolarWinds TFTP Server.exe' during the installation. The environment I'm working has some complicated proxy setup and the above .exe was failing to connect to an external address which I didn't manage to capture... 

Great work as always Marc, Well done and thanks for sharing!! 

the "If NTA were one of the products to install, the silent installer also installs the Flow Storage Database on the same computer" refers to Example A: which is pretty much 'Evaluate Orion and place everything in the same server using SQL Express". I believe you're after "Example C: Standard fresh NTA installation with an…

That seems like a PowerShell script to me! Start querying DNS and if ((noerror) then) {exit 0;} else {catch something write-host "Message: Error $($Error[0])" and exit 1;} (-or-similar-) after you've set up the app monitor, you can apply any alerting logic to notify you on failures. 

How about checking Event viewer -> System log -> Source: "Service Control Manager" ? Just tried myself to disable a service and it gets logged:

Both tables are legacy (and belong back to NPM 10.x and the Desktop version of the advanced alerting engine) if i'm not mistaken and should give no results back, so you are not going crazy. Try [dbo].[AlertConfigurations] for the actual definitions. If you let us know what were you looking for on the dbo.Alerts we will be…

It is indeed a bug. Depending on the cmdlets you are using, you may be able to pass the Credentials from SAM like this

Got that confirmed with SolarWinds support. This is a known bug tracked under this number NPM-15971 2 files are missing in the AWEs SWISv3 schema, which are present in the main poller and APEs: 1. NpmNetPathSchema.xml 2. NpmNetPathSchema.resx They are Found in c:\Program Files (x86)\SolarWinds\Orion\Information…

Great work as always, thanks for sharing !

You may also have better luck if that IP address is in any way inventoried in NCM rather searching that (scary) column with hundreds of characters long..! If there's a command to strip that running configuration into a a few lines, will also be a better way of quering into the database

Hello! Do you have a Server and Application Monitor (SAM) license installed? (I assume you have from the PoSH script, just making sure though!). The following thread solves the issue you are having, should be…

Orion's DB will automatically move the data points to their appropriate sampling interval specified in your polling settings (Under Settings -> All Settings). So your Orion.NPM.InterfaceTraffic is basically built upon 3 SQL views: - dbo.InterfaceTraffic_Detail - dbo.InterfaceTraffic_Hourly - dbo.InterfaceTraffic_Daily…

This is amazing!!