yaquaholic · Senior Monitoring Simian · ✭✭✭✭✭

Hello Goliath_Of_Cedar You want to have a look at the Orion SDK - https://github.com/solarwinds/OrionSDK First you'll need to download the SDK and set it up, you'll find instructions on the site. The SWQL Studio is included with the SDK, well worth getting familiar with it. Then you can select the accounts you want using a…

Hi chrodriguez, Firstly you'll need to set up a new SAM monitor and add the "Windows Event Log Monitor" to it. Then configure this to use the <inherited from node> credentials, "DNS Log" and "Custom" Match Definition. Then you can match by event ID 2501. Then set up the rest of the monitor how you'd like it, but I'd leave…

The ISE's support the HOST-RESOURCES-MIB, which will provide the CPU, so as Stuart mentioned a generic *nix CPU poller will work. Have a look at Linux CPU Load Average and Memory

It looks like your Archive folder is a subdirectory of the the orignal Archive location folder, so it is being included. If you can't move the folder structure, you could filter the archive schedule to just *.log files.

Good point, here's a REST example for you: # Orion connection variables $user = 'yaquaholic' $pwd = 'Thwack_Rules!' $orion = 'orion.yourdomain:17778' #Note port 17778 is being replaced by port 17774 # Added to ignore PowerShell TLS/SSL errors add-type @" using System.Net; using…

Hello Pogue1000, All of this was found here: https://github.com/solarwinds/OrionSDK/wiki/PowerShell You'll need to install the module, instructions included. Here is an example on getting (previously created) and populating Node Custom Properties: ## Orion SWIS connection $user = "yaquaholic" $pwd = "Thwack Rukes!" $orion…

Thank you

Hi Dinge2023, That OID is also known as: hrPrinterDetectedErrorState from HOST-RESOURCES-V2-MIB Here's what the MIB says: STATUS current DESCRIPTION "This object represents any error conditions detected by the printer. The error conditions are encoded as bits in an octet string, with the following definitions: Condition…

Hello Daisyahoy, Looking at the report's SWQL you can see the query is (cleaned up a little): SELECT [data].[DisplayName] AS [DisplayName], [data].[InstanceSiteId] AS [InstanceSiteId] FROM orion.nodes AS data WHERE [data].[NodeProperties].[NodeID] IS NOT NULL AND…

Hi Greg, It is possible, first you'll need to get the Orion SDK PowerShell working - https://github.com/solarwinds/OrionSDK/wiki/PowerShell Then you'll need to familiarise yourself with: New-SwisObject $swis -EntityType 'IPAM.Subnet' Details can be found here…

The script needs to report back labelled as "statistic:" for the monitor to pick up on it. Replace "return $RoundTripTime" with: Write-Host "Statistic: $RoundTripTime"

Typo, missing and ending ' $web = New-WebServiceProxy ‘www.webservicex.net/whois.asmx'

Hi there, The script is failing in the New-WebServiceProxy command. Can you use New-WebServiceProxy command locally [on your Orion server]? Log on to your Orion server, open up a PowerShell prompt and test it from there. $domain = 'solarwinds.com' $web = New-WebServiceProxy ‘www.webservicex.net/whois.asmx $out =…

SELECT Interfaces.NodeID, Interfaces.InterfaceID, Interfaces.CustomProperties.Link_ID FROM Orion.NPM.Interfaces AS Interfaces WHERE Interfaces.CustomProperties.ThwackQuestion = TRUE

Morning Patriot, Funnily enough DonnieDarko84 asked the same question yesterday. Does this help? thwack.solarwinds.com/.../swql---custom-property---90-95-99th-percentile

Interfaces.CustomProperties.<Custom property> LIKE '<string>'

Hi DonnieDarko84 There is a link from the Interfaces table to the CustomProperties, which can be called as such: SELECT Interfaces.NodeID, Interfaces.InterfaceID, Interfaces.CustomProperties.Link_ID FROM Orion.NPM.Interfaces AS Interfaces WHERE Interfaces.CustomProperties.Link_ID LIKE 'ATT-X0XXXX1234' I hope it helps

Hi Andrei, There is no centre function in SWQL, you'll have to use the UI. I suspect that you are using that widget. 

Hello Mrldg123, Grab the latest installation (the MSI is the simplest method) from the Github site - https://github.com/solarwinds/OrionSDK/releases Then have a look at the Wiki page for Powershell - https://github.com/solarwinds/OrionSDK/wiki/PowerShell That should get you started

Version 2 - now with 9am until 5:30pm WHERE Weekday(rt.DateTime) IN (1,2,3,4,5) AND ( ( Hour(rt.DateTime) = 17 AND Minute(rt.DateTime) <= 30 ) OR Hour(rt.DateTime) IN (9,10,11,12,13,14,15,16) )

Well 9 until 17:59, but hopefully you get the idea 

Hi MakeCrazy, You could use the Weekday and Hour functions to limit the tr.DateTime to weekdays between 9am and 5pm as so: AND Weekday(rt.DateTime) IN (1,2,3,4,5) AND Hour(rt.DateTime) IN (9,10,11,12,13,14,15,16,17) Weekday translates the rt.datetime to the day integer, where Sunday = 0 and Saturday = 6 And Hour is the 24…

There doesn't seem to be a direct way, but I was having a play with the Orion SDK creating events and had some success. This is far from perfect, but from an event it's easy enough to create an alert. I've selected Event Type 505, just as it was fairly generic. ## Connect to Orion $swis = Connect-Swis -UserName 'username'…

Here's a break down of what the SAM template provides: documentation.solarwinds.com/.../sam-microsoft-iis-smtp-server-sw5207.htm

Use the EngineID and Orion.Engines table SELECT aa.AlertActiveID, aa.Uri, aa.AlertObjectID, n.IP_Address, n.Caption, E.ServerName AS Poller FROM Orion.AlertActive AS AA JOIN Orion.Nodes AS N ON aa.AlertObjectID=n.NodeID INNER JOIN Orion.Engines AS E ON E.EngineID = N.EngineID

Have a look at the Microsoft IIS SMTP Server SAM template. Unless your queue is on *nix.

I think it looks something like this.... SELECT COUNT(AC.Severity) AS [Severity] FROM [dbo].[AlertObjects] AS AO INNER JOIN [dbo].[Nodes] AS N ON N.NodeID = AO.RelatedNodeID INNER JOIN [dbo].[AlertConfigurations] AS AC ON AC.AlertID = AO.AlertID INNER JOIN [dbo].[AlertActive] as AA ON AA.AlertActiveID = AO.AlertID WHERE…

https://thwack.solarwinds.com/p/store is unresponsive 

Hi Kevin, I haven't played with this yet, but there is a UpdateConnectionProfile verb for Cirrus.Nodes. https://github.com/solarwinds/OrionSDK/wiki/NCM-Connection-Profiles Rich

Have you tried the manual? It's got examples for syntax and regex that should get you started.