Comments
-
Thanks for the help, much appreciated
-
ORDER BY SummaryMonth ASC, 4 ASC) AS X where AVERAGE_of_Availability < 100; I'm having problems with this line of code, Incorrect syntax near ')' Is this line correct or not?
-
This worked a treat thanks
-
Glad its not just me being dumb as a box of rocks, here is the SQL code for the report; SELECT TOP 10000 CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth, Nodes.Caption AS NodeName, AVG(ResponseTime.Availability) AS AVERAGE_of_Availability, AVG(ResponseTime.AvgResponseTime) AS…
-
I have tried this approach but i still get the error message saying i need to specify a complete trigger condition. Where am i going wrong?
-
The IP address that it says does not exist is the IP address that is contained in the "agentIP" colum of the nodes table.
-
Id just bite the bullet and manually update them!
-
Is the location of the server shown on the node details page? i.e is Orion aware of the SNMP info if so you can create a node tree view and then Group the nodes by location