0 Replies Latest reply on Aug 27, 2014 2:47 PM by vrao123

    Custom Reports Based On Windows Events

    vrao123

      Hello:

       

      We have Win2k8 r2 64 bit web server farm. We also have SAM 6.1 and LEM 6.0. I am wondering whether we can get a report in the following format:

       

      The below should

      ==================================
      Event ID                          : <could be any event viewer id>
      Severity                           : <Information or Error or Warning or Critical>
      Total Number of Events: <some computed number based on the Severity>
      Nodes                              : <list of web server nodes included inside SAM or LEM>
      Event Text                       : <capture one event message text>
      ==================================
      Event ID                          : <could be any event viewer id>
      Severity                          
      : <Information or Error or Warning or Critical>
      Total Number of Events
      : <some computed number based on the Severity>
      Nodes                             
      : <list of web server nodes included inside SAM or LEM>
      Event Text                       : <capture one event message text>

      ===================================
      and so on......


      The above is a high priority item for us. Second requirement is to run some SQL script (probably) that would generate the following table or a .csv file (NOTE: All our web servers are load balanced and these servers are monitored by both SAM and LEM):

       

      Daily Consolidated Events Report Per Server As Of mm-dd-yyyy

      Server Name

      Severity Level

      Database Name

       

      Informational

      Error

      Warning

      Critical

       

      WebServer1

      1000

      155

      10

      0

      DB-ABC1

      WebServer2

      800

      100

      50

      0

      DB-ABC2

      WebServer3

      755

      156

      80

      0

      DB-DEF1

      WebServer4

      200

      100

      20

      0

      DB-ABC1

       

       

       

       

       

       

      Daily Consolidated Events Report Per Database As Of mm-dd-yyyy

      Database Name

      Severity Level

      Total Events

       

      Informational

      Error

      Warning

      Critical

       

      DB-ABC1

      1200

      255

      30

      0

      1485

      DB-ABC2

      800

      100

      50

      0

      950

      DB-DEF1

      755

      156

      80

      0

      991

       

      Will appreciate an early response.


      Thanks.

      Victor