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

Archiving Syslog Entries After a Specific Time Period

Running Orion 9.1

Is there a method for archiving messages out of the Syslog database that have been there for over 30 days? I want to keep the messages, just get them out of the ballooning database.

Find more posts tagged with

Accepted answers

savell

I would create a quick DTS or SSIS task to select the required records and dump them either into another table or date stamped flat file. A second step could delete the exported rows (or if the export was done daily, you could set the Solarwinds retention to 31 days and just let the nightly SolarWinds maintenance take care of the delete).

See here for some sample SQL on the syslog table using the datediff statement.

Dave.

All comments

savell

See here for some sample SQL on the syslog table using the datediff statement.

Dave.