Does anyone know how to do a report listing the number of traps per device?
I can do one for syslog but cannot find how to do traps.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.