klomper2007

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?