Checking your DB Size

This guide details how you can check your on-premise Halo database size. Please run the below query directly on your Halo database: SELECT s.name AS SchemaName, t.name AS TableName, SUM(p.rows) AS RowCounts, — Total space in MB and GB CAST(SUM(a.total_pages) * 8.0 / 1024 AS DECIMAL(10,2)) AS TotalSpaceMB, CAST(SUM(a.total_pages) * 8.0 / (1024 * 1024) […]

On-Premise Instance to Instance Refresh

The guide will detail how you can refresh your Halo on-premise instance with that of another on-premise instance, such as a production instance to a UAT / Dev instance. Throughout this guide I will reference the two instances as below: Source: The instance you are copying from Destination: The instance you are copying to Information […]

Restoring a DB Backup

This guide will show you how to restore a database backup. This guide only applies if you are running Halo yourself, on-premise. Warning You must ensure that the database backup is using a database version the same as or older than your Halo app version. You can find the database version using the below command: […]

Changing your Halo URLs

This article outlines how to change your Halo agent and user portal URLs. This guide only applies if you are running Halo yourself, on-premise. Prerequisites You have access to IIS and the certificate store on the server which is running the Halo web application Please ensure you have your SSL certificate(s) available and imported into […]

Enabling Reference Tokens

Enabling reference tokens in the Halo API allows sessions and tokens to be stored in the database. Each API call will check the token is still valid in the database. Enable Reference Tokens in the Halo API and Auth server by setting  "UseReferenceTokens": true Inside both the API and Auth appsettings.json. Activating this will invalidate […]