Comments
-
Absolutely. here is the query i ended up going with as an example: SELECT COUNT(*) AS [99.99% Available] FROM (SELECT [Nodes].Caption , AVG([Nodes].ResponseTimeHistory.Availability) AS [Availability] FROM Orion.Nodes AS [Nodes] WHERE [Nodes].NodeName LIKE '%WTNC%' AND [Nodes].[ResponseTimeHistory].[DateTime] BETWEEN…
-
Thanks a ton guys. using that query from Adam above, I was able to tweak it to meet my needs. Thanks so much to each of you for assisting!!!!
-
Great question. I'm running it in a Dashboard View. I get this error when i edit the dashboard containing this new code. This shows the query: It validates correctly, but then throws the error after saving it. We are on the latest version of the software as well.
-
This is great. Thank you. One last issue with this, i get thiis error when I attempt to use it...does this ring any bells on why? "message": "An error has occurred.", "exceptionMessage": "RunQuery failed, check fault information.\n'DateTime' is not a recognized built-in function name.",
-
So support gave me this query, but the issue is it throws errors: SELECT [Nodes].Caption, AVG([Nodes].ResponseTimeHistory.Availability) AS [AverageAvailability] FROM Orion.Nodes AS [Nodes] WHERE [Nodes].NodeName LIKE '%SOLARWINDSC%' AND [Nodes].ResponseTimeHistory.DateTime BETWEEN DATEADD(DAY, -31, GETDATE()) AND GETDATE()…
-
I do as well...I've been trying to figure out if maybe it was related to a network latency timeout issue or something happening on the server, but I've validated that it's not either of those. Jeremy
-
Okay...thanks for the advice...I have opened a case as well.
-
I already have it open - as of Thursday night.
-
Any word on this issue? I'm still getting it while running version 9 with SP1.
-
Ken, I'm one of the other cases that they are working with to address this issue. I can tell you (from an enduser standpoint) that they are indeed working on the issue. I agree that it'd be nice if they were able to come up with a quicker resolution, but as is life in the IT world :-) I did want to give you an idea that is…
-
Anyone get a solution to this? The support team is trying to tell me to uninstall Netflow, deleted all the SQL tables for Netflow and reinstall.....I just have a hard time understanding that is the fix for this as others are experiencing the same thing..........
-
Thank you for the info.
-
First support said to use the main poller installer on the additional poller and the additional web server. I told him that was different then the past and then he went and checked and found out there was 3 different installers to use. I only was seeing the one installer on my portal, so he transferred me to customer…
-
If you don't mind sharing more details, I would be very very grateful. I was in the process of figuring out how to write a page that changes SQL on the back end to put the device into maintenance mode, but then I read Denny's post about it being stored in memory. So this is a great alernative and even better in some…
-
yea...I've read that post....but that is only in reference to the SNMP unknown state problem...I have it with the WMI monitor.
-
I'm running v1.1. It was working until I rebooted the server. Then it started having this issue. I've done a bunch of things to troubleshoot this including uninstalling completely and reinstalling.
-
Had it open for two days - case 40096
-
You get this fixed? if so, what did you do?
-
So I found the MIB: 1.3.6.1.2.1.4.20.1.1 So I now know I can query that and get all the ip's for a server....I don't suppose Solarwinds has that already stored in a table?