Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by zaradell
-
Select all last results from a range of hosts
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 ); -
Select all last results from a range of hosts
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 |||... -
Select all last results from a range of hosts
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... -
Select all last results from a range of hosts
r937 You´re a life saver Working like a charm Thank you very much -
Select all last results from a range of hosts
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 |||... -
Select all last results from a range of hosts
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... -
DELL Force10 S4810 - TRILL or VLT
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... -
DELL Force10 S4810 - TRILL or VLT
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...- zaradell
- Thread
- Replies: 0
- Forum: Network Appliance networking solutions
-
CISCO PBR
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... -
Cisco 6500 - Oversubscribed Ports
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? -
-
-
Filter results by IP subnet
PHV Thkx...it worked :D I´m still checking if there´s any bugs, mas at a first impression it seems to work fine!- zaradell
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
