sum_giais

slick, love it!

Hi there @"greg.remer", here's an example of using the CASE statement within this query (note I made a few minor adjustments to the syntax of the query though). I *think* this CASE should give you an icon for the status... that is if I did this correctly! Hope this helps! SELECT DISTINCT n.Caption AS [Node Name]…

You may want to check your logging levels, perhaps they were adjusted away from default a long while ago and never reverted / defaulted back? Longshot but worth a check... The logadjuster application also has the ability to reset to default if anything ever was changed.…

AP's are so dynamic that it makes sense for them to have feature parity to other child entities like volumes or interfaces. List Resources should show them all and you can pick and choose. I've hit this same problem as well before.

+1 for noting the cadence, its important to not strain your environment more than needed, especially for these simple admin tasks. We do basically the same thing but perhaps slightly different? As an example I set the schedule of the alert to only be active for ~31m every day (say 5-5:31pm) and then the frequency to 15m,…

Are you running Network Atlas on the Main Polling Engine basically connecting to localhost? Or are you connecting from a remote system? Is SWQL studio login working from the same system with the same accounts?

Thank you

Hi @"stuartdc", for that the reset condition in the alert definition should be "Reset this alert automatically after " X time, which could be something like 15 minutes or so. No need to do the manual cleanup anymore, presto! 

Hi @"aaguilar1", as noted by @"donrobert5" could you please submit this as a feature request so others could upvote it? Thanks

I think this is what the variable would need to be to work, same query from @"Seashore" ... pretty much ${N=SWQL;M=SELECT CASE WHEN CHARINDEX('.',n.Caption) > 0 THEN SUBSTRING(n.caption, 0, CHARINDEX('.', n.Caption)) ELSE n.Caption END AS [t] FROM Orion.Nodes AS n WHERE n.NodeID = ${N=SwisEntity;M=NodeID}}

Have you create a support ticket on this? Looks like you're using Internet Explorer, have you tried doing this in either Chrome or Firefox and see the same issue? Depending on the version you're on, in Orion v2020.2.6 they replaced the Custom Properties Manager UI, and just taking a stab in the dark... it may not be…

Curious, why do you need to delete them?

I like the idea to use SAM as well as the custom HTML widget (which gets me wishing of more parity between classic maps/views and the modern maps/views.) Looks like the SQL Server User Experience component only returns a single numeric value, with a 2nd row for a message. That'd be very troublesome (or unusable) with…

Scripting can be powerful.. I do this for data that is "attached" to the nodes etc. where I can and justifies its own custom property (or in some cases I have a text custom property that serves many purposes in various automation..) Basically use scheduled tasks that run PowerShell scripts. It doesn't work in scenarios…

Great to hear thanks for letting us know. That's a troublesome piece of adding in your own links, it's a pain. However to future proof them, you can make the links relative. E.g. if you want to link to a dashboard, set the URL as "/Orion/SummaryView.aspx" instead of "http(s)://myserver/Orion/SummaryView.aspx". SolarWinds…

Hi @"strau2ca" did you end up figuring this out and/or is this still an issue for you? Question: Is this occuring only with specific links or anywhere in your SolarWinds Orion web console? If you go to https://yourOrionServer:443/ and login - at what point will it redirect you to HTTP? A couple things to check: * Go to…

I could not find a table that detailed out what those exactly are but I have figured out a couple from reviewing the data in there. Like you noted, they're not where I'd expect (the Orion.EventTypes table). 0 - Alert Trigger 1 - Alert Reset 6 - Action Triggered I limited the query to the last 7 days (see the "AND…

Here it is... thwack.solarwinds.com/.../3287

I made a query for this just the other day let me grab it...

So this smells like a permissions issue (just my 2 cents). Without knowing exactly what has been tried... have you: * Closed SWQL Studio conpletely? Not sure a lot of people know this but just like SSMS (SQL Mgmt Studio) you can have multiple connections to different Orion servers using various authentication methods in…

There's 2 methods from within the GUI. * When editing the alert definition, manually assign that single action to the alert you're editing on the trigger/reset actions tabs * When in the "Action Manager" tab of manage alerts view, assign the action to multiple alert definitions If you create an action and make it generic…

Ah that's a pretty slick solution to it, nice @"dgsmith80"! Thanks for sharing.

Thanks I had that feeling.. appreciate the info! Looking forward to a day this functionality exists as RBAC needs a major overhaul in SolarWinds Orion.

This is a cool script, bookmarked!

If you want it to match multiple nodes you would want to use the wildcard symbol % WHERE n.Caption LIKE '%JWJ%' Expanding more: WHERE ( n.Caption LIKE '%JWJ%' OR n.IP_Address LIKE '10.10.11.%' )

@"John W Johnson" - does that help and/or do you have any more questions?

I'll update my prior response with the read-host and a filter based off that input.

Heh... look at the Read-Host command within PowerShell. docs.microsoft.com/.../read-host

Here's a basic example of how to modify custom properties of nodes already in SolarWinds from within PowerShell. Now if you already are exporting the data into CSV / Excel and making updates there you could just re-import within the GUI too if it's a one-off. Import-Module -Name SwisPowerShell $hostname = 'myOrionServer'…

Hello @"CourtesyIT", here's an adjusted query with I believe the appropriate statements at the end that you were looking for. Give it a go and see. SELECT [Nodes].NodeCaption , [Nodes].AgentIP , [Nodes].Vendor , [Nodes].MachineType , [Nodes].OSImage , [Nodes].OSVersion , [Nodes].EndOfSupport , [Nodes].EndOfSales ,…