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

Orion NPM Syslog Report

davorsl500

hi,

Is it possible create report from Orion NPM 9.1 Syslog messages?

Regards,

Davor

Find more posts tagged with

Accepted answers

lchance

It sure is. For example.

Here's a SYSLOG report which Counts Messages by 'Severity' for the Last 24 hours coming from IP Host addresses starting with 10.16x.x.x

SELECT SysLog.Hostname AS Hostname,
SysLog.IP AS Source_IP_Address,
SysLog_SysLogSeverities.SeverityName AS Severity,
COUNT(SysLog.Message) AS COUNT_of_Message

FROM
((SysLog INNER JOIN SysLogFacilities SysLog_SysLogFacilities ON (SysLog.SysLogFacility = SysLog_SysLogFacilities.FacilityCode)) INNER JOIN SysLogSeverities SysLog_SysLogSeverities ON (SysLog.SysLogSeverity = SysLog_SysLogSeverities.SeverityCode))

WHERE
( DateTime BETWEEN 40075.5783796296 AND 40076.5833333333 )
AND
(
(SysLog.IP LIKE '10.16%')
)

All comments

Ciag

Hi,

if it's creating a report then yes you can using the report writer. Open Report writer > New > syslog Messages. Then build your report to the preset options for syslog reports.

What kind of reports are you looking to create?

HTH

lchance

It sure is. For example.

Here's a SYSLOG report which Counts Messages by 'Severity' for the Last 24 hours coming from IP Host addresses starting with 10.16x.x.x

SELECT SysLog.Hostname AS Hostname,
SysLog.IP AS Source_IP_Address,
SysLog_SysLogSeverities.SeverityName AS Severity,
COUNT(SysLog.Message) AS COUNT_of_Message

WHERE
( DateTime BETWEEN 40075.5783796296 AND 40076.5833333333 )
AND
(
(SysLog.IP LIKE '10.16%')
)