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 TinkerbeII

  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