HaloITSM Guides
Documentation to assist with the setup and configuration of the HaloITSM platform
Guides > Logging to a Database instead of the File Structure
Logging to a Database instead of the File Structure
From 0.57.2 onwards;
In both the api and auth's appsettings.json, add the following ConnectionString for LoggerConnection, with the value being the connection string of the database to log to.
Create the event log table in the database you wish to log to
CREATE TABLE EventLog([ID] int identity primary key,[EventID] int,[Level] nvarchar(50),[Message] ntext,[Name] nvarchar(255),TimeStamp datetimeoffset,[Host] nvarchar(255),[Path] nvarchar(255),[QueryString] nvarchar(255),[Method] nvarchar(255),[User] nvarchar(255),[ServerHostname] nvarchar(255),[Version] nvarchar(50),)
When restarted the site, the web app will now log to the specified database instead of the file structure.
Popular Guides
- Asset Import - CSV/XLS/Spreadsheet Method
- Call Management in Halo
- Creating a New Application for API Connections
- Creating Agents and Editing Agent Details
- Departments and Teams
- Halo Integrator
- Importing Data
- Multiple New Portals with different branding for one customer [Hosted]
- NHServer Deprecation User Guide
- Organisation Basics
- Organising Teams of Agents
- Step-by-Step Configuration Walk Through
- Suppliers
