Microsoft SQL Server
The MS-SQL output module allows you to write data to a Microsoft SQL Server database server.
| Parameter | Default | Meaning |
|---|---|---|
| host | localhost | The host name or IP address of the server |
| user | The name of the database user | |
| password | The database password | |
| database | The name of the database | |
| sql | INSERT INTO events (start,end,message) VALUES ('%S','%E','%M') | The sql statement to execute, including event codes |
| timezone | UTC | The timezone to write date data in. |
Example (Event)
[
{
"type": "event",
"method": "mysql",
"host": "myserver",
"user": "myuser",
"password": "mypass",
"database": "eventlog",
"sql": "INSERT INTO events (start,end,message) VALUES ('%S','%E','%M')",
"timezone": "Australia/Sydney"
}
]
Other Modules
Return to the list of output modules.