Ok, I figured it out
I got it working with the following query
select timeofexecution , result from results_tbl GROUP BY DATE( timeofexecution ), HOUR( timeofexecution );
Actually my problem is a little more complex that I´ve exposed before.
I´ve confirmed, and I have no unique ID per test, but instead I have a unique ID per test/per user. Something in these lines:
TestID ||| User ||| Timeofexecution ||| Result
1245 ||| UserA ||| 2013-03-10 09h50 ||| 5
1248 |||...
Ok
One more, and this is a little trickier, not sure if it is even possible:
Instead of retrieving the AVG of only the last results, the query should extract the AVG result of all the results based on an unique test ID?
For instance, I have several results identified on an unique test ID...
r937
Thank you for your feedback. It worked perfectly!
Just one final question. How do you adapt your query to extract the AVG result? I want to know the AVG value of the last results between the 3 users.
For instance, right now I´m able to extract the results as expected:
ID |||...
Good afternoon
I'm trying to select all the last results from a range of hosts that are performing tests, and their results are written in one table.
For instance, I have a table with 3 users and the fields:
ID Timeofexecution Result
UserA 2013-03-10 13
UserA...
Hello
I have 3 Force10 S4810 and I want to interconect them in a ring topology:
Switch1---------Switch2
| |
| |
|-----Switch3-----|
But I don´t want any link blocked by Spanning-Tree. I read that Force10 has support for TRILL or VLT. Which is...
Hello
I have 3 Force10 S4810 and I want to interconect them in a ring topology:
Switch1---------Switch2
| |
| |
|-----Switch3-----|
But I don´t want any link blocked by Spanning-Tree. I read that Force10 has support for TRILL or VLT. Which is...
brianinms
Thank you for your reply.
The VIP is active on the correct switch.
The 10.8 is the static IP of the interface. I´m monitoring this IP I don´t want for the traffic destined to it, to be "PBRouted".
But for some reason it isn't working.
Good afternoon
I´m having a problem with a new PBR and I need your help
This is the scenario:
I have Equipment A which is currently configured with a PBR defining that all trafic from host 10.10.1.1 has a next hop to IP 192.168.10.10 (on equipment B). This PBR is working fine.
Now, I want to...
Good afternoon to you all
I was wondering if you have a notion on what oversubscription ports are and what are they for? A simple explanation if possible.
And if so, what´s the show command to see what ports are Oversubscribed?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.