How to manually query the Active Administrator Database for a specific Event ID? (4236976)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to manually query the Active Administrator Database for a specific Event ID?
Description

Would like to run a query against the database to return the event records for a specific Event ID.
Resolution

The following SQL script will allow you to query the AA database for the Event ID that you specify. Replace Event_ID_Number with the number of the event id you want to look for. The event id has to be enclosed with the '%. For example to look for any events that are stored in the DB with an event ID of 1007 it would look like '%1007%'

Select tblAlertLog.ActionText, tblAlertLog.EventDump, tblAlertLog.TimeGenerated

From tblAlertLog

INNER JOIN tblEventDefinition

On tblAlertLog.EventDefinitioncode=tblEventDefinition.EventDefinitionCode

where tblEventDefinition.EventCode like '%Event_ID_Number%'

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title