Return
-
Title
How to run a SQL Query to show the total number of events for each event definition name in the database -
Description
Need SQL Query to list total number of events for each event definition name in the database. This will help determine which events are filling up the database the quickest. -
Resolution
- Open Microsoft SQL Server Management Studio
- Expand "Databases"
- Right click the Active Administrator database and select "New Query"
- Copy and paste the query below into the query window
- Click "Execute"
-- Shows the total event definitions sorted by TotalSelect b.DefinitionName , COUNT(distinct a.AlertLogID) As Total From tblAlertLog As aInner Join tblEventDefinition As bOn a.EventDefinitionCode = b.EventDefinitionCodeWhere b.ADVersion = '5.2' OR b.ADVersion = '6.1' OR b.ADVersion = '5.0' OR b.ADVersion = '6.2' OR b.ADVersion = '6.3'Group By b.DefinitionNameOrder By Total Desc
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Software Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Software Support and Development.Quest Software Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.For customization of the Active Administrator, please contact our Professional Services Organization.