How do I manually delete events from the repository? (NETIQKB6903)

  • 7706903
  • 02-Feb-2007
  • 03-Jul-2013

Environment

NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x

Situation

How do I remove items that I don't want without using the Operator Console?

Resolution

To manually remove events from the repository:

  1. Record the Event ID for each event you want to delete.
  2. Open SQL Server Query Analyzer.
  3. Select the repository (QDB).
  4. Enter the following SQL statements:


                 DELETE
                 FROM EventDetailAction
                 WHERE EventID = xx 
     

    Where xx is the Event ID noted from Step 1.

  5. Press F5 to execute the SQL statements.
  6. Enter the following SQL statements:


              DELETE
              FROM EventDetail
              WHERE EventID = xx 
     
    Where xx is the Event ID noted from Step 1.
  7. Press F5 to execute the SQL statements.
  8. Enter the following SQL statements:

              DELETE
              FROM Event
              WHERE EventID = xx

    Where xx is the Event ID noted from Step 1.

  9. Press F5 to execute the SQL statements.
  10. Repeat steps 4-9 for each event you want to remove.

Additional Information

Formerly known as NETIQKB6903