Thwack » SolarWinds » Orion Network Performance Monitor » Custom reports and limitation problems

in More Search Options

Custom reports and limitation problems

Last post 09-19-2007 8:22 AM by thurgoodj187. 1 replies.
Page 1 of 1 (2 items)
Sort Posts:

  • 09-06-2007 4:21 PM

    Custom reports and limitation problems

    Reply

    I wrote this report, which lists active advanced alerts, along with information about the host and such.  Whenever I atttempt to view this through an account with a limitation applied, I get the following:  Incorrect syntax near the keyword 'Where'

     

    select NODES.CAPTION, NODES.STATUSLED, NODES.PRIMARY_ROLE, ALERTDEFINITIONS.ALERTNAME, ALERTSTATUS.OBJECTNAME, ALERTSTATUS.TRIGGERTIMESTAMP, interfaces.interfacename, interfaces.interfacetypedescription,  interfaces.interfacespeed,  interfaces.statusled, interfaces.interfaceicon, interfaces.inpercentutil, interfaces.outpercentutil

     From (alertdefinitions INNER Join alertstatus on (alertdefinitions.alertdefid = AlertStatus.AlertDefID) inner join interfaces on (interfaces.interfaceid = AlertStatus.activeobject) inner join nodes on (interfaces.nodeid = nodes.nodeid))

    where alertdefinitions.objecttype = 'interface' 

     

    I cannot use basic alerts, and cannot handle how little information is given by default of the advanced alerts.  I need to have a summary page that can show relevant information about advanced alerts.

     

    does anyone have any suggestions on how I can accomplish this?

     

    Thanks

     

    Steve 

     


     
    • Post Points: 1

  • 09-19-2007 8:22 AM In reply to

    Re: Custom reports and limitation problems

    Reply

    Bump<?> 
    • Post Points: 1
Page 1 of 1 (2 items)