The eventlog table, housed in the back-end database of LabTech is in most cases going to be one of your biggest tables. What most people don’t realise is that a lot of the space used in there can often be down to a few machines who have issues that can be logging multiple times a second into the event log. These subsequently get sent to LabTech and they have to be stored somewhere.
This simple SQL command to identify your noisiest agents – it will count the amount of entries per Agent in your eventlog table:
SELECT DISTINCT ComputerID, COUNT(*) AS Total FROM eventlogs GROUP BY ComputerID ORDER BY Total DESC
From there you can connect to the agent in question and see if the application/service spamming the event log can be stopped. Not only will this decrease the size of your own database but will likely offer some relief to server performance too.
Found a PC that had over 250k event log entries with this Query, great job!!