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!

Register Log in
  • Congratulations Mike Lewis 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. TinkerbeII

    SQL syntax help needed

    Thanks for the tips drlex :-)
  2. TinkerbeII

    SQL syntax help needed

    Yes thats correct. The output currently shows multiple lines of up/down events and I would like to get the total time that the node was in a down state. I don't think I have put the dates correctly, I'm struggling to understand the decimal system and couldn't find a decent explanation online...
  3. TinkerbeII

    SQL syntax help needed

    My SQL syntax so far is as follows: Select NodeID, Event_Time, Group_Status_Icon, NodeName, EventTypeIcon, Cast(Message As nvarchar(250)) as Message From ( SELECT Nodes.NodeID AS NodeID, Events.EventTime AS Event_Time, Nodes.GroupStatus AS Group_Status_Icon, Nodes.Caption AS NodeName, (...
  4. TinkerbeII

    SQL syntax help needed

    Hello I am using a network monitoring tool called SolarWinds Orion NPM, in which you can create reports using SQL. The report output and associated SQL I have written so far is attached. What I need to do now is calculate the TOTAL time that the node has been down for (e.g. over the past...
  5. TinkerbeII

    Extract IP SLAs from a Cisco router?

    Hi Burtsbees Thanks for the response, please could you explain how to log to syslog? Amy
  6. TinkerbeII

    Extract IP SLAs from a Cisco router?

    Hi everyone! I have IP SLAs configured on my Cisco routers to poll response times to a responder. Is there a way to extract and store the response time results directly from the routers into an Access/SQL database? Perhaps using SNMP/MIBs? If you need more info please let me know. Thank you! Amy

Part and Inventory Search

Back
Top