sguido · NOC Team Lead · ✭✭✭✭✭

This feature would make creating customer views a whole lot easier and help me with security concerns of who can see and do what. Also, save some face by not having to ask the customer to "test" their views.

I really like this idea. It would also be a benefit if the pop-up box had the option to allow the user to add the missing field from within the pop-up box itself.

This would be nice and I'd like the global search to search all IPs associated with a Node, not just the polling IP.

Is the answer for week 1 day 3, correct? I have a custom property of Date and Time set up for my Nodes.

It would be good to have a search option for this table. Searches should be available by default for any table. 

It would be nice to have the ability to draw lines anywhere on a map.

We have a robust data center and IT support infrastructure in place, so we've only moved to the cloud when it makes technical sense to do so. We do have several vendor-provided SaAS solutions that are cloud-based.

Love to see you guys do something in Charlotte or Atlanta.

This one was a lot of fun, thanks.

Currently, we run a Powershell script to leverage our OpenDuty application to make phone calls. Integrated support for this would streamline things for us.

I agree. If someone wants all caps they can just type it in that way.

I keep our environment pretty up to date so I'm never making large jumps like this. I normally use the centralized update as we have an Orion HA pair, 10 additional polling engines, and 3 standalone webservers. During a typical update I need to run the configuration wizard on one of the polling engines manually. Also, the…

I have a suggestion but I'm pretty sure you won't like it. My personal experience with rebuilding SolarWinds components is that it's best to blow away and rebuild the whole server. It just saves time. There seem to be so many small bits and pieces leftover when you try to do it any other way. Also, the servers that I have…

Sorry, you need to also remove the WHERE condition for OpenDuty.

Here is the SWQL I use to get alerts for the last 12 hours. Instead of MinuteDiff use DayDiff and change 720 to 8 (I use <) and I think you should be in business. SELECT ToLocal(Alert.TimeStamp) as Time, Nodes.Caption AS Name, SubString(Alert.Message, 1, 100) AS Alert_Description,Nodes.DetailsUrl AS DetailsUrl, Nodes.IP AS…

Since I store the Days of the duration in D, I think you need to just add a where statement for D. Something like. WHERE D < 31

We are having the same issue. It seems to happen to everyone, more often to some users. We have three webservers behind a load balancer, and it seems to be impacting all three servers equally. I've asked one of my admins, it seems to happen to her a lot more than the rest of us, to use the webserver on the Orion server to…

I use the following query to make this dashboard. You could use something similar and create a WHERE condition for day (D in the query) is less than 30. Note - currently this query only returns active alerts but you can change that as well. (MinuteDiff(AlertActive.TriggeredDateTime,ToUtc(GetDate()))) AS Seconds,…

Thank you for posting this. I saw it before my upgrade, so when I ran into problem 3 I knew right where to go to fix the problem.

There's a similar question posted here - https://thwack.solarwinds.com/product-forums/the-orion-platform/f/forum/98634/remove-platform-connect-icon-from-menu-bar Still no answers from SolarWinds about how to fix it.

I'm having the same issue. If SolarWinds is going to keep doing things like this they need to make sure it's very easy to remove them. I've opened a ticket with support and it's taking much longer and I'm having to jump through a lot more hoops than I should.

So this produces a report of alerts over the last 12 hours. You may be able to edit it to give you the alerts over the last 10 minutes and then just perform a count on the number of alerts returned. SELECT ToLocal(Alert.TimeStamp) as Time, Nodes.Caption AS Name, SubString(Alert.Message, 1, 100) AS…

This is off-topic, so if you can point me in a direction that would be great. I noticed that you said this can be caused by SQL cluster failover. I've noticed that when we have a cluster failover SolarWinds rarely handles this well. I don't know if this is a SolarWinds or OS issue. Has anyone found out why this is and a…

I know it can be a pain, but the cleanest method is a server rebuild. I've tried removing SolarWinds from a few of my polling engines to perform clean installs and have never been able to get all the shrapnel removed. In the end, it was faster and guaranteed a clean install of SolarWinds. One note, I removed the polling…

Interesting, so I didn't include any of the FROM or JOIN statements that you may need because I figured you'd be using a different field. I've included the complete query below. I use this for a table of a modern dashboard. SELECT (MinuteDiff(AlertActive.TriggeredDateTime,ToUtc(GetDate()))) AS Seconds,…

I don't know the field in the database you need to find but I can give you the math needed to turn the date into a current duration, just replace AlertActive.TriggeredDateTime with your field. CONCAT(CASE WHEN (MinuteDiff(AlertActive.TriggeredDateTime,ToUtc(GetDate()))%1440)<720 THEN…

I use this in my emails to display how long the device was down. You may be able to use this to convert the time stamp into something more meaningful. Object was down for ${SQL:Select '${N=Alerting;M=Downtime}'/1440} Days ${SQL: Select '${N=Alerting;M=Downtime}'%1440/60} Hours ${SQL: Select…

Those are some pretty big jumps you need to make. A few ideas come to mind, but how you'll attack this depends on how you go about building servers and your organization's tolerance for SW being down. My first idea is to build all of your new servers (new names and IPs). Migrate you database to the new version of SQL. Then…

This will cause a security red flag in my environment as well. I'll need some type of official documentation about the purpose of this account.

I use the following SWQL functions: - Concat(a, b, c, ...) - Takes one or more arguments and returns a single string that is the concatenation of the values of the arguments. - SubString(s, start, length) - Returns a substring of length characters starting at position start (the first character is position 1). - Length(s)…