christopher.t.jones123 · CRIS Solutions Architect/Engineer · ✭✭✭✭✭

@"robert777", Gray usually means unknown, which usually means that SolarWinds is unable to poll that interface and get stats on it

@"david.b.davis", take a look at this article. Might be able to execute a config script to accomplish this. 

@"SolarRafic", change DAYDIFF to HOURDIFF and increase the value of "1" to how many previous hours you want it to look at. so in your specific case it would be HOURDIFF(e.EventTime, GETDATE()) < 24

@"SolarRafic", something like below would get you all the node down events for the last day. You can modify the WHERE statement to scope it down to particular days or nodes if desired. SELECT COUNT(EventID) as Total FROM Orion.Events where EventType = 1 and DAYDIFF(EventTime, GETDATE()) < 1

@"VaughnDumas", the actual query is in Orion.ResourceProperties, you'll have to figure out the ResourceID and then in that table, it has the SWQL query for the resource (Widget).

@"robert777", something like below is a great starting point for this. Just ensure you modify the custom property being referenced in the where statement. SELECT CS.Component.Application.Node.Caption ,CS.Component.Application.Name, CS.ComponentName , CS.ComponentPercentCPU , CS.ComponentPercentMemory ,…

@stuartd, if those were left balnk im pretty sure it would error out, to revert them back to be managed by SolarWinds you'd set CustomBandwidth = false on line 55. Thats essentially the little check box in the UI that enables/disables custom bandwidths.

@"awolfrom", if you update the bandwidth statement on the interface itself within the firewall, SolarWinds will usually auto-adjust the configured bandwidth to match. This would be the preferred method as setting a custom bandwidth means that over time if the interface changes its often overlooked that SolarWinds has a…

@"xpowels", i am on 2023.2 and my application availability widgets are not behaving the same way as your screenshot, perhaps you should put in a ticket with support.

@"ITOM", here's an article on how to set a custom cert for the SWIS REST Endpoint starting in version 2023.1. Idk if this would affect a ServiceNow connection, I'd imagine it would, but i would also not be surprised if it didn't. 

@"martian_monster" is that a screenshot of the actual test you are running? If so, the path is looking for .TXT in C:\Path, you'd need to update that first argument to the file path you actually want to look in and then change TXT to XLS. 

can you post your support ticket number? perhaps @"jvb" or @"bshopp" can shed more light.

that's odd, I'm running 2023.1.1 and Network Atlas is available for me to use and I can create and display maps using it. 

@"ggatten", it is absolutely an escaping problem, take a look at the below THWACK post. You can create a custom SQL variable that adds the escaping into the returned result using replace. I would give this a try and see if you can get different results. thwack.solarwinds.com/.../113654

@"sredmond" try this. $ListsEqual = $true # Query external CNAME MyCompany.ca and output as string [array]$ExtIPs = Resolve-DnsName MyCompany.ca -DnsOnly -server 8.8.8.8 | foreach {$_.IP4Address} | Sort-Object -Descending # Setting internal DNS server IPs for payments.ca (2023-03-20) [array]$IntIPs = ('1.1.1.1','2.2.2.2')…

@"sredmond", an exit code of 1 tells SolarWinds that the script failed to execute, try changing that exit code to 0. also your $ListEquals for your message nedss to be witihn the quotes, not outside of it. 

@"mickdon", that is an available option, or you could WMI for both.

@"mickdon", unfortunately, you can't have the same agent point to two different SolarWinds instances. 

@"robert777", assuming you are adding each node individually, have you tried to do it via Network Discovery?

@"robert777", once they find the snmpd.conf file, I recommend taking a look at the views that are defined and assigned there. Typically, the default config is to restrict a bunch of the root level OID's as @stuartd alluded to. See below is an example of what it looks like, you'll notice that the systemonly view restricts…

@"yaquaholic", there is a navigational property from the Nodes table to the Engines table, you should simply need to use the below as your selection statement and then you can just remove the INNER Join you have in your Query. N.Engine.ServerName SELECT aa.AlertActiveID, aa.Uri, aa.AlertObjectID, n.IP_Address, n.Caption,…

@"jaleef", what @"jm_sysadmin" provided is the way I would recommend moving forward. 

@"robert777", here's one that does a number of different objects. Because it's using a union it becomes pretty simple to just extract the queries you want for the objects you want. -- Unmanaged Nodes SELECT 'Unmanaged' as [Status] ,n.Caption AS [Node] ,'Node' AS [Object] ,tostring(tolocal(n.UnManageFrom)) AS [From] ,case…

@"aksh14", you have to set up an IPSLA specifically targetting the ports that Microsoft Teams using for calls and then you monitor that IPSLA within VNQM. 

@"KampferKFL", you could turn it into a scheduled task, thats basically what the scheduling utility does for you. 

@"KampferKFL", take a look at this article, it explains how to do it via a PowerShell script. Without the utility using the API is the only option to provide something similar to that app. 

@"AgentSmith", So Netflow is just going to tell you the amount of data that traverses your network and details about it, in this scenario as you've found it's not generally helpful beyond "Yup, it's traversing my network." To start looking at the quality your best bet is using IPSLA's on your routers (or supported…

@"seymanur", which query is returning nothing? I will say from experience that even if your particular issue is not advertised within that article, clearing the subscriptions fixes several issues with the Information Service. With that being said have you completed all the steps as outlined in the article and it still did…

you arent going to be able to add two critical values, the only thing you could do it as is would be to do the math in your SWQL query and then have it return a consistent value you can alert on. For example you could case anything greater than 95% is XX and then case anything less than 2% is the same value. Then set your…

@"ggatten", let me throw my two cents in. I have seen it as a requirement for several SolarWinds specific jobs to at least have one of the SCP's so it does offer some value in that regard; took a while for companies to start making it a requirement, but within the last 6 months or so i've seen it become more common. The…