sum_giais

Did you open up any ports for WMI / RPC specifically? documentation.solarwinds.com/.../core-solarwinds-port-requirements.htm

There's a setting in the global advanced configuration - HTMLResourceSanitizationEnabled, which is likely enabled by default now that will "Enable HTML Widget Sanitization". I can't recall which version this occurred though. Go to your Global settings page here (change URL for your environment of course)…

If you're using a linux script already - why not add another linux script component, and gather the values of discover / offer packets, and do the arithmetic to determine the difference inside the script? Then it'd be a simple if over 5 warning threshold on that new component. There's ways to do it without that, but you'd…

NCM creates the ${SubFolder} dynamically tearing them up/down as needed. I'm not familiar with backing up existing firmware images though, probably same concept just opposite way and may not tear it down after since it's backing it up. Considering this scenario when your tftp'ing the software to your switch... * TFTP Root…

Take a look at the firmware upgrade requirements of NCM, link below. It explicitly states "The storage location cannot be the same as the TFTP or SFTP/SCP root folders.". I'm not sure why though and probably best to stick with that recommendation... but the ${SubFolder} variable is coming from the firmware upgrade template…

The query above is a SWQL query - it won't work in database manager or SSMS. You'll need to use SWQL Studio or a custom query widget or custom report with a SWQL query datasource to use it. Try one of the queries here: Node assigned credentials SWQL query There's a version for both SWQL, or SQL depending on your need.

Having never used SQL Sentry, that looks like something from the SolarWinds Platform.

There's nothing concrete to do this natively. Here's how I get half the way there by using a SWQL query joining in the audit events data with nodes. SELECT n.Caption ,CASE WHEN d.NetObjectID IS NOT NULL THEN TOSTRING(d.TimeAddedLocal) ELSE '1+ Year ago' END AS [Date Added to SolarWinds] FROM Orion.Nodes AS n LEFT JOIN (…

I'd attempt to address this by disabling the "Condition must exist for more than X" in the trigger (so it could trigger immediately, and adjust your reset condition to essentially be the opposite of your trigger by selecting "Create a special reset condition for this alert", then click "Add Condition" and select "Copy…

Updated the original query to require that Media_Type_1, Media_Type_2, or Media_Type_3 has to not be null. Give it a go.

I had a typo... the very first "MediaType" should have been "Media_Type", corrected my query above.

I'm not sure if this query will work as I don't have properties similar to this to test it on but I'm hoping this is close to what you're looking for. Give it a go an let us know the results. SELECT m.Media_Type ,COUNT(m.NodeID) AS [Total_Cybernet_Fiber] ,COUNT(CASE WHEN m.Status = 2 THEN 1 END) AS [Down_Cybernet_Fiber]…

There's an example of it here using the SwisPowerShell module in PowerShell. thwack.solarwinds.com/.../powershell-to-update-captions---what-features-am-i-missing

Ultimately that depends what the actual values are for that node. If both ${Caption} and ${SysName} (same as ${SystemName} macro), provide the same value, then you'll probably need to update the Caption of the nodes enabling you to use the ${Caption} macro, removing the dns zone info. I use a script to do that, removing…

Centralized upgrades has certainly become more reliable over the years. However, I've hit issues nearly every time I use it, sometimes major others minor like any upgrade. Some I know what the issue is, e.g. SolarWinds Administration Service is in need of restart or server needs a restart etc., others have needed to engage…

Once you change the "I want to report on..." to Interface, then change the filter to use the Advanced Selector, then click the Select Field, then change the SolarWinds Platform Object to Node and you can find those properties there to filter your datasource on.

It may be because you have the Node selected as the object of the reports datasource, and need to select interface.

Possibly throw a simple script action to run a SwisPowerShell command that does it all in one alert, or scheduled task and could end up with just 1 alert that does the action. That's a bit complex though and probably not the easiest way to go about it. Could perhaps make an attempt to slim down your scope with a custom…

My money would be on that too @"adam.beedell" . The extra periods are likely confusing SolarWinds. A period is usually used to separate the expected output of "Message" and "Statistic" with the defined value output of the script. So if I want a monitored value of "datapoint1" from my script it would be: print…

Chiming in a bit late, but looks like Unmanaging the node that the API poller is assigned to successfully stops polling of the API poller. That's probably your best option... Unsure if muting the node would have any effect on alerts configured specifically for the API poller however. Alternatively you could tweak your…

Yes SQL Server 2016 and up is required... documentation.solarwinds.com/.../solarwinds_platform_2023-4_system_requirements.htm

I'd recommend getting SWQL Studio to familiarize yourself, it's a very helpful resource. https://github.com/solarwinds/OrionSDK/releases https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions Below is an example of a SWQL query you could use to start this off. SELECT TOP 1000 i.Caption ,i.DetailsUrl ,i.Status…

No issues and/or impact here when upgrading to the latest v17 ODBC driver (that was supports recommendation - as SCM uses v17), I'm not exactly sure what the ODBC driver is utilized for within the SolarWinds Platform however. Can't comment on OLE - didn't have that installed. Download ODBC Driver for SQL Server - ODBC…

WHERE clauses need to go before GROUP BY clauses like so: SELECT TOP 1000 c.ContainerID ,c.Name ,c.CustomProperties.GroupCity ,c.CustomProperties.GroupState ,COUNT(c.Members.DisplayName) AS [DisplayNameCount] FROM Orion.Container AS c WHERE c.CustomProperties.GroupCity LIKE '%Carlisle%' GROUP BY c.ContainerID ,c.Name…

You could add the first case statement to your query in the top section, and if you wanted, something similar to the second case statement to add an icon for it. Would need to change the logic for the second based on your need, and if it's going in a classic or modern dashboard. ,CASE WHEN…

Looks like it's possible if you're willing to do the leg work. SWQL Studio can help you understand the API. Perfect example, looking at the Application entity in SWIS via SWQL Studio (Orion.APM.Application), I'm able to see that the Orion.APM.Application entity has a "CreateApplication" verb attached to it. Expanding on…

Jumping in a little late, but looks like SWIS does some of the work for you if I'm not mistaken with using the SwitchStack navigational property to MemberCount and then you would just need to sum it up. Here's a way to show both those in a table with a union. SELECT 'Total Branch Nodes' AS [metric], COUNT(n.NodeID) AS…

Here's an example of a basic query looking at a SWIS entity (Orion.Nodes) and the properties attached to it. But yes, as @"adam.beedell" noted, in SWQL studio you can easily get an idea of how all this stuff is connected and their properties attached far quicker than this. But if you're looking for something quick and easy…

Quick and dirty way could be to use a SQL variable to replace the line feed and carriage return chars. This is an example: ${SQL: SELECT REPLACE(REPLACE('${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}', CHAR(13), ''), CHAR(10), '') AS [output] }

Check out the documentation here, it does a decent job going through all the date functions. https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions Here's an example of looking at response data in the last month for only hours between 8am and 5pm. SELECT TOP 500 rt.DateTime AS [DateTime (UTC)] ,TOLOCAL(rt.DateTime) AS…