Top Trap Talkers Report

Create a custom SQL report:

select count(*),hostname,nodeid 
from traps group by hostname,nodeid order by count(*) desc

on field formatting copy the URL for nodeid and make it a hidden field

Paste the URL onto the hostname field settings (will make it a clickable link in the report taking you to the node)

If you only need the top 25 trap senders make the query:

select top 25 count(*),hostname,nodeid
from traps group by hostname,nodeid order by count(*) desc

Thanks, following your advise I researched for a SQL timeframe search and added 'Last 24 Hours'

select top 25 count(*),hostname,nodeid

from traps

where (DATEDIFF (Hour, DateTime, getdate()) <= 24)

group by hostname,nodeid order by count(*) desc

This works a treat to capture the Top Talkers.