database

Database Logging with MSSQL

This guide helps you to add database logging to any of your services. Microsoft SQL Enterprise Manager 1. To create a new Database, open up the Microsoft SQL Enterprise Manager. 2. Right-click on “Databases” and select “New Database”. 3. Select a Database Name there and click “OK”. ODBC Data Source Administrator After you created the […]

How to store custom properties of a log message in a database

Last updated 2016-09-30 by Pascal Withopf, using Winsyslog 13.3. This step-by-step guide describes a scenario where WinSyslog receives syslog data from a Fortigate firewall, parses the messages via post processing action and writes the custom parsed properties into a database. Step 1 – Creating the Syslog Server First, please create the syslog server service by right […]

Timestamp in field “ReceivedAt” and “DeviceReportedTime” stored in the database is wrong ?

The local PC-Time and other reported device time is correct but the the time stamp in “ReceivedAt” and “DeviceReportedTime” field stored in the database is wrong ? The time in field “ReceivedAt” and “DeviceReportedTime” which is stored in the Database Table (e.g. MySQL, SQL Server) isn’t actually wrong. In the database logging action (the one […]

Scroll to top