ctech291

This is what we use: SELECT TOP 1000 ac.AlertID ,ac.AlertMessage ,ac.AlertRefID ,ac.Name ,ac.Description ,ac.ObjectType ,ac.Enabled ,ac.Frequency ,ac.Trigger ,ac.Reset ,ac.Severity ,ac.NotifyEnabled ,ac.NotificationSettings ,ac.LastEdit ,ac.CreatedBy ,aa.CategoryType , aa.ActionAssignmentID ,aa.ActionID --,aa.ParentID…

Oh, that's an interesting idea. If you have a suggestion on a resource on how to learn to create reports, that'd give me a jumpstart. (I'll also start googling how to do that, too). (And I'd love to use the Rest API, I'm just limited on the tooling and approval process at my company for implementing a solution to get…

@"KMSigma.SWI" - Thank you again for the reply. I think I kind of found an answer: it appears that there is a Python Client that we can use to run SWQL queries: https://github.com/solarwinds/orionsdk-python We could also use powershell via the OrionSDK ( https://github.com/solarwinds/OrionSDK ). But I haven't found an ODBC…

 @"KMSigma.SWI" - thank you for the reply. Is there a way to run a SWQL query via JDBC or ODBC connection? The tools I have at my disposal currently limit me from grabbing hundreds of thousands of rows via REST API. Thank you~ PS: For those that are able to use the API, I've found this to be super helpful: 1.…

I ended up changing my payload and I'm converting the string to a JSON in my own code. My payload now looks like this: { "fullscanbit": 0, "server_text": "${N=SWQL;M=SELECT c.MultipleStatisticData.StringData FROM Orion.APM.Component c where componentid = ${N=SwisEntity;M=ComponentAlert.ComponentID} and…

@"yaquaholic" - thank you. I was able to get SWQL Studio and validate that the above SWQL statement is valid: But it appears that when I try to place the "StringData" variable reference into my alert trigger, solarwinds is trying to escape the double quotes for me: Alert trigger POST body: Error message in…

I think I might have solved it: ${SQL: SELECT REPLACE(REPLACE(REPLACE(Notes, CHAR(13), '\r'), CHAR(10), '\r'),CHAR(9),'\t') FROM [AlertStatusView] asv INNER JOIN [AlertActive] aa ON asv.AlertObjectID = aa.AlertObjectID WHERE aa.AlertActiveID = ${N=Alerting;M=AlertActiveID}} Here's my full JSON I'm passing to Jira…

This was working up until this year. I wonder if the 2020.2.5 release changed this? (now it outputs the HTML tags)

7 years too late: Trigger Condition: Custom SQL Alert Set up your SQL condition: Group SQL: </code></p><p><code>WHERE GroupID IN ( </code></p><p><code>SELECT nodesDown.ContainerID /*, nodesDown.Name as GroupNM , nodesDown.NumeratorNBR / (nodesDown.DenominatorNBR * 1.0) * 100 as NodeDownPercentageNBR*/ FROM (…

Is a custom report using custom SQL the only way? thwack.solarwinds.com/.../how-to-create-triggered-alerts-history-report-for-all-configured-alerts

Thank you! I didn't know about the "Node Warning level" and how when the main polling process determines a node is down, the polling engine will start pinging (my guess is ICMP pings?) the node until the warning level is reached... and if the node is still not responding to pings at that time, the node is marked as down.…

Okay, after waiting awhile and doing a reboot, we now see .NET 4.8 on the box. Not sure why it took so long (we waited 20+ minutes), but it is there now.

I just found a view: dbo.CPULoad which seems to have CPU info and memory info. Unless someone says otherwise, I'm going to run with this.

I think I might have found the CPU information recorded at 5 minute increments in dbo.CPUMultiLoad_Detail . I'll keep searching for memory...

I found a Monitoring Settings page that has the "Manually set up monitoring after devices are discvoered" option selected: If I select "Automatically monitor based on my defined monitoring settings" it activates the "Define Monitoring Settings" and then I can select to automatically monitor IIS. But I don't want that…

That sounds exactly what is going on! Thank you @"mesverrum" ! Unfortunately I'm too new in solarwinds to find the configuration that let's me undo this. I'm poking around "Discovery Central" and a "Network Sonar Discovery" page but I can't see where the appinsights for iis template is set to auto apply to every node that…

Yes, I did try that, it unfortunately doesn't seem to be unique.

awesome. I'll try active alert ID and run with that for awhile: ${N=Alerting;M=AlertActiveID}

This is what I put into my JSON: ${SQL: SELECT REPLACE(Caption, '\', '\\') FROM Volumes WHERE VolumeID = ${VolumeID}}

Well, I couldn't wait, so I just deleted the group and recreated it and it is working again. ¯\_(ツ)_/¯

https://thwack.solarwinds.com/t5/SAM-Discussions/SAM-PagerDuty-integration-issues-with-volume-names/m-p/314843 I'll reply back here when I get it working

Thank you. I think I'm going to spend a few hours reading documentation, watching videos, and become more proficient in solarwinds and I'm hoping that will give me the added knowledge I need to better understand the best option for our situation (and also the knowledge to better understand your response ). Thank you again…

cmazko​, jrouviere​, sturdyerde​ - thank you!!! Each of your posts helped me solve the problem (this was my first attempt at writing a powershell script for solarwinds and apparently I didn't know solarwinds was parsing the output in a special way)

@"shuth" - YOU. ARE. AMAZING. In one post, you provided exactly the information I needed at the level I needed it at. You answered my question, you provided pros and cons, you pointed me to the virtual classrooms. This is exactly what I was looking for. With your post, I now have enough knowledge to move forward and train…

That was it (I have to use Agentless) + remote host execution mode.