All Tags » sql » configure (RSS)

Browse by Tags

  • custom SQL report - sql question

    This report shows some WAN ckts > 45% use for a 5 min period. See pic. I have that working, but want to make it more readable by either doing a COUNT on the number of times the >45% hits or rolling those results into a link for the serial interface (some have hundreds of rows) or just showing the...
    Posted to Orion Network Performance Monitor (Forum) by njoylif on 07-12-2007
    Filed under: Database, Custom Report, SQL, configure, sql manager

  • Custom reports grief

    SQL questions for custom reports...The only lines I've added is in the WHERE section for <NodeID LIKE> part, which is a valid SQL query, but it causes the report to come back empty...any thoughts??? Also, I'm fairly new at SQL and the DateTime in the WHERE command is killing me. If I remove...
    Posted to Orion Network Performance Monitor (Forum) by njoylif on 07-10-2007
    Filed under: report write interface node exclude sql, Database, SQL, configure, sql manager

  • Bulk Interface manipulation

    Is there a way to delete "in mass" interfaces from Nodes. I am looking to delete all Null0 and Loopback interfaces from a major chunk of my nodes and would like to figure out how to do this with SQL rather than through the GUI... Thanks
    Posted to Orion Network Performance Monitor (Forum) by njoylif on 07-10-2007
    Filed under: Database, SQL, configure, sql manager
Page 1 of 1 (3 items)