wes.reneau

Thanks! That fixed it

I had a bad piece of code in what I posted earlier WHERE N.CustomProperties.YourCP='thevalue' I was tinkering w/ a custom property instead of a node attribute. So, i edited the query to include Linux as the vendor and removed that offending WHERE statement, and Windows nodes are still showing up. SELECT 'Unmanaged' as…

Thank you. This is a good start. I'm using your code to learn. Much appreciated

You've been great thus far, so how difficult would it be to add an link to acknowledge the alert from the dashboard?

Sorry for the late reply. Priorities had me focused elsewhere. I do have SAM. I'm going to begin testing this later this week. I'll update my findings.

just now revisiting and the query isn't working as I expected. It only shows acknowledged alerts

fantastic! THANKS!

How difficult would it be to have only unacknowledged alerts?

YES! thanks for that!

the link didnt save but the original post is here Create an "Active Alerts" view based only on critical alerts - Alert Lab - The Orion Platform - THWACK (solarwinds.com)

I'm using this swql query but I'd like to add an Acknowledged "YES" or "NO" and whom/who acknowledged the alert. My swql fu is lacking and I look fwd to your reply. Thx

This is SWQL only. If I'm not mistaken Report Writer is SQL only. Also, the rumor is that Report Writer is being depreciated, at least I think I read that someplace. Thanks Wes

Thank you! This worked exactly as expected.

Sorry, misunderstood the last question. I'm not sure why its not working. I'll try to tinker w/ it. Wes

Probably worth noting for posterity... I'd been using Eclipse to write the HTML in the traditional format, using spaces and blank lines to make it more readable. When I got the format I wanted in my html I'd copy/paste to the trigger actions editor only to find wildly varying results. After reading a bit of related posts I…

Finally got back to this and I now have muted and unmanaged. I added an OR to capture those nodes w/ suppressuntil unset. This is a tweak on the previous version supplied. Your mileage may vary... OR --Added to capture those nodes where the suppress until time is not set SuppressUntil IS NULL OR SuppressUntil = '9999-01-01…

that was it, the bash ${script} was not there, I deleted it as I was not using perl and never revisited that. Simple things... Thanks for the help!

I only get unamanged nodes when I use your query. Not muted items. 2017.3.4 SP4

I went back and edited the query that does unmanaged and unmuted and added the same OR clause and it appears to work. SWQL follows. Your mileage may vary... SELECT 'Unmanaged' as [Status] ,n.Caption AS [Node] ,tostring(tolocal(n.UnManageFrom)) AS [From] ,case when n.UnManageUntil is null or n.UnManageUntil = '9999-01-01…

I dialed back my query to focus on muted nodes, specifically those w/o a ending date/time and I've got this. This does not address the unmanaged nodes, those can be captured w/ a SQL query using the following " Status = '9'" It doesn't get you the details you'd probably want but it works in a pinch until the custom query…

The SWQL is perfect, it essentially is the same thing as the database details but I'm going to use it to learn. I use most of the stuff out of the box but this is a great spring board into other areas. Thanks for sharing this!

Not trying to reproduce the entire page, only Elements for the moment, I'm sure that'll change but I'm starting small. Thanks Wes

Thank you. This is an excellent starter. I changed my search and found a few but most were highly involved, I can borrow from your code. Much appreciated WR

I realize this is really old but I'm stumbling through some of the same things. I've tinkered and cobbled together solutions from other similar scripts. The problem for me was that most all the statements were using UTC. I used local w/ the following (harvested from other Thwack posts) ,tostring(tolocal(n.UnManageFrom)) AS…

These are great! Going to use them as a springboard to my own. Thanks for sharing WR