Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Need Syslog report for SolarWinds polling engines

I am looking to build a report that shows, 1) the total number of Syslog messages received, and 2) the amount of Syslog traffic in MB received by each SolarWinds polling engine in the last 24 hours.

Can't seem to find one here. I did see a couple of possibilities in the Content Exchange, but clicking Download results in an error.

Has anyone done that report? Thank you.

Find more posts tagged with

Comments

patriot

It now occurs to me that maybe this could be a NetFlow report using port 514 for the NTA application. But, how would I show a single value for total GB of Syslog (514) data RECEIVED by a SolarWinds polling engine?

Lofstrand

Number of logs are easy (as I already had that query….)

Below shows number of logs per day, per type. Use it as a baseline:

SELECT

    COUNT(L.LogEntryID) AS NrOfMessages

    ,DATETRUNC('day',L.DateTime) as Day

    ,l.LogType.DisplayName

FROM Orion.OLM.LogEntry AS L

GROUP BY DATETRUNC('day',L.DateTime),l.LogType.DisplayName

ORDER BY DATETRUNC('day',L.DateTime)