yaquaholic · Senior Monitoring Simian · ✭✭✭✭✭

Arpnet or internet? Quotes from the linked page: It was not called the internet – that name was not coined for another five years. Nonetheless, this was the first time a message had been sent over a telephone line between two computers. (Hardly the internet) "Nor was it the World Wide Web – that was created by the British…

Sorry for the delay, I've been away from civilisation for a few days. From what I have found, the events table, although it does have an Acknowledged column, has no user tracking of who acknowledged them. I also checked against the auditing tables, and again I found no audit action types related to event acknowledgment.

Mainly, but MS SQL only makes up about 60% of our environment, with MySQL, PostgreSQL, Mongo and Oracle also playing their parts. And who knows what Dev-Ops are playing with. 

Have you tried using SNMP? Set it up, then browse through the hrSWRunEntry MIB (1.3.6.1.2.1.25.4.2.1) then you'll get some application monitoring.

Paul, As Orion is "databased", now is as good a time as any to learn! Believe me, if you are looking after Orion, learning SQL (and then SWQL) will be beneficial. 1. Open the SolarWinds DB Manager (Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe), or MS SQL Studio, or any other DB tool you use. 2. Connect to your…

Mr Bump would like to remind SolarWinds how much of a no-brainer this request is!

Can you snmpwalk the devices? If you can, then it should just be a case of finding the correct OIDs for your device a creating a poller for it. It is always best to start with resolving the devices sysObjectID (1.3.6.1.2.1.1.2​), as this usually allows us to research the correct OIDs that you seek. With the sysObjectID in…

Hi there, Have you looked at the documentation for the VMware monitoring? 

CASE MONTH(A.TimeStamp) WHEN 1 THEN 'Jan' WHEN 2 THEN 'Feb' WHEN 3 THEN 'Mar' WHEN 4 THEN 'Apr' WHEN 5 THEN 'May' WHEN 6 THEN 'Jun' WHEN 7 THEN 'Jul' WHEN 8 THEN 'Aug' WHEN 9 THEN 'Sep' WHEN 10 THEN 'Oct' WHEN 11 THEN 'Nov' WHEN 12 THEN 'Dec' END AS Month Add something like this in 

$interfaces = Invoke-SwisVerb -SwisConnection $swis -EntityName 'Cirrus.ConfigArchive' -Verb 'GetInterfaceConfigSnippets' -Arguments @($coreid) foreach ($interface in $interfaces.string) { If ($interface.InnerText -match 'interface Ethernet1/27') { Write-Host $interface.InnerText } } A cleaner method of PowerShell…

I've spent too long looking at this, and from what I can see the information is being pulled from Cirrus.ConfigArchive, where you will find all of the device configs. You'll need the NCM.NodeID (check NCM.Nodes for the Orion CoreNodeID correlation) and then to parse the config text for the interface in question. Though I…

I couldn't find the linked post you mentioned, what information are you after?

Hi BLG, As the Orion.NertFlow.FlowsByConversation table is linked to Orion.Nodes, you can just call "FBC.Node.Caption" to resolve the Caption without using the JOIN at all. SELECT TOP 100 FBC.Bytes, FBC.DestinationCountryCode, FBC.DestinationDomain, FBC.DestinationDomainID, FBC.DestinationHostname,…

Hi there duck1, Have you had a look at the SWQL Studio (part of the Orion SDK) and the NCM.Interfaces table?

Yes, yes there is GitHub - solarwinds/orionsdk-python: Python client for interacting with the SolarWinds Orion API Also check out the Wiki on the main SDK pages Home · solarwinds/OrionSDK Wiki · GitHub

Hi Avivi, Try something like this SELECT TOP 10 EP.EntityID, EP.EntityName, EP.EntityDescription, N.NodeCaption, N.AgentIP FROM NCM.EntityPhysical AS EP LEFT JOIN NCM.Nodes AS N ON N.NodeID = EP.NodeID Rich ;)

I tested this myself and yes despite the column being shown in SWQL Studio, Uri is always null. I also noticed that you can't update that Orion.Thresholds, which may explain why: Maybe someone with better knowledge can explain why. Rich

Hi Joe, Just a thought but I've seen kit reject SNMP comm-strings with meta-characters in them. Try an alphanumeric comm-string. Rich (yaquaholic)

Hi Narzsa, No I don't believe that you're missing anything, it appears a limitation of the monitor where it only checks the body text. But getting the headers is easy enough with PowerShell: # URL to query $url = "https://www.softcat.com" # Invoke the web request $response = Invoke-WebRequest -Uri $url -Method Get # And…

Hi Lucy, Have you had a look via SWQL? Here's a starter for you: SELECT P.ServiceAssignment.DisplayName, AVG(P.RttMin) AS RttMin, AVG(P.RttMax) AS RttMax, AVG(P.RttAvg) AS RttAvg, AVG(P.RawRttMin) as RawRttMin, AVG(P.RawRttMax) AS RawRttMax, AVG(P.RawRttAvg) AS RawRttAvg, AVG(P.PacketLossMin) AS LossMin,…

Hi Sriram, You've not given us much information of the problem, but if your environment is anything like ours the alerts are coming from BGP ports are configured but unused. Ask the network team to place them in Admin down state, to stop the "false" alerts. Or give us a bit more information on the issue 

HI swf.nfs, I think the NCM.EntityPhysical table has this data in it. This SWQL isn't perfect but it should get you started: SELECT TOP 1000 EP.Node.NodeCaption, EntityID, EntityName, EntityDescription, HardwareRevision, FirmwareRevision, SoftwareRevision, Serial, Manufacturer, Model FROM NCM.EntityPhysical AS EP WHERE…

Afternoon Robert, Remembering the days I used to use PHP, we'd use the PHP Info function. Drop the script into a file onto your web server and view the page. Or if you have the php.exe file you can run it as: php -v Although this does presume the PHP is in $PATH. Saying that, I've checked our Orion web servers and none…

Hi Adeelcorps, The exception is being raised by the Python Request module and it's saying that it cannot reach 172.29.100.45 on TCP port17778. Do you have any firewalls that may be blocking port 17778 for you? Other than that your code looks okay. Yaquaholic

Hi Mcmillrl, The PowerShell monitor is expecting either just a Statistic with a value (with optional Message with a string),with up to 10 named Statistics. Your script is trying to pass strings to the Statistic variables, so they are failing. Also each statistic name must be unique, and using the process name won't…

Hi, I've cleaned it up a little, using the internal SWQL table connections. And I think it works SELECT DISTINCT([Nodes].Caption), [Nodes].IP_Address, [Nodes].Interfaces.InterfaceAlias, [Nodes].Interfaces.TypeDescription, [Nodes].NodeIPAddresses.IPAddress, [Nodes].NodeIPAddresses.SubnetMask FROM Orion.Nodes AS [Nodes]…

Or as Adam correctly mentioned... SELECT TOP 10 OV.NodeID, OV.Caption, OV.Node.Caption FROM Orion.Volumes AS OV

Here's a starter for your: SELECT TOP 10 NodeID, Caption, ARRAYVALUEAT(SPLITSTRINGTOARRAY(AncestorDisplayNames),1) as Ancestor FROM Orion.Volumes The SplitStringArray splits the text up on the comma separator and then the ArrayAtValue selects the second value (0 being the first) of the array. I hope it helps! Rich

What table are you looking at and i'll have a look? 

What does your code look like? Post up the SWQL query, it'll help