Server Management Suite

 View Only

  • 1.  SQL Table or View From Event Console

    Posted Jan 21, 2015 11:24 AM

    All

    For reporting purposes, I am looking for the SQL table or view that is used during alert drill downs from the Event Console. I have already gone through 'ec' views and tables, but nothing has stuck out which populates the 'Metric Information' section of that alert drill down.

    Don't suppose anyone has dug around for this information?

    SMP 7.5 SP1



  • 2.  RE: SQL Table or View From Event Console
    Best Answer

    Broadcom Employee
    Posted Jan 21, 2015 01:24 PM

    Hi MonitorMan,

    Did you try to open "Event Console" with already populated alert from monitored resource ⇒ Open "Altiris Profiler" on SMP server ⇒ start profiling ⇒ drill down alert details in EC ⇒ stop profiling ⇒ check "SQL" tab of Altiris Profiler to determine what it uses to populate such alert details?

    Thanks,

    IP.



  • 3.  RE: SQL Table or View From Event Console

    Posted Jan 21, 2015 11:11 PM

    HA!. Forgot about that. I'll give that a go tomorrow.



  • 4.  RE: SQL Table or View From Event Console

    Posted Jan 23, 2015 01:12 PM

    For anyone else wondering, its value column in the ec_alert_variable table.

    Thanks