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.
...192.168.10.8
I can´t seem to make this last PBR work.
This are the configurations I have at the moment on equipment B:
access-list 150 remark *** PoC - PBR ***
access-list 150 deny ip any host 192.168.10.8
access-list 150 permit ip any any
route-map POC-PBR permit 10
match ip address...
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?
...by the 158.80.0.0/17 network; the IP range addresses is as follow:
158.80.0.1 - 158.80.127.254
that means that i can´t use the LIKE '158.80.*' because the address 158.80.128.3 is not from that network range, but still falls on the LIKE filter.
Is there any syntax in SQL where i can filter...
PHV
Thank you for your reply
The person who accesses the SQL database isn´t allowed access to the Linux machine where the SQL database is hosted.
We created a specific user with view privileges for the specific purpose of our client accessing the SQL DB by an ODBC connector in Access, so...
Good afternoon to you all
I need your help
I´m using Microsoft Access with a connector to a MYSQL database to retrieve some networking results.
One of the result columns is the IP address of the machine that performed the networking tests.
The problem is that i need to filter the results by...
Good afternoon to you all
I need your help
I´m using Microsoft Access with a connector to a MYSQL database to retrieve some networking results.
One of the result columns is the IP address of the machine that performed the networking tests.
The problem is that i need to filter the results by...
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.