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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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 );
  2. zaradell

    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 |||...
  3. zaradell

    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...
  4. zaradell

    Select all last results from a range of hosts

    r937 You´re a life saver Working like a charm Thank you very much
  5. zaradell

    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 |||...
  6. zaradell

    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...
  7. zaradell

    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...
  8. zaradell

    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...
  9. zaradell

    CISCO PBR

    Ok..problem solved... and a really stupid problem it was I changed set ip next-hop to set default ip next-hop and it worked
  10. zaradell

    CISCO PBR

    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.
  11. zaradell

    CISCO PBR

    ...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...
  12. zaradell

    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?
  13. zaradell

    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!
  14. zaradell

    Filter results by IP subnet

    ...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...
  15. zaradell

    Filter results by IP subnet

    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...
  16. zaradell

    Filter results by IP subnet

    Frink Thanks for your feedback I´ll post it in Microsoft: Access Modules (VBA Coding)
  17. zaradell

    Filter results by IP subnet

    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...
  18. zaradell

    Filter results by IP subnet

    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...

Part and Inventory Search

Back
Top