Common SQL Tables and Joins

In this guide we will cover: – Common SQL Tables and What Each Contains – Example Joins Between Them This guide will cover some commonly referenced SQL tables and the information that can be pulled from each. A majority of the tables listed here are also within the following schemas. ITSM Schema PSA Schema CRM […]

Optimising Reports to Improve Efficiency

In this guide we will cover: – Selective Data Retrieval – Join Recommendations – Subquery Alternatives – Minimising Use of Wildcard Characters – Use of $-filters Larger or more complex reports can potentially have slower loading times. This guide outlines a few key points to consider when writing reports to help combat this. Selective Data […]

Agent Cost Tracking and Profitability Reporting

In this guide we will cover: – What is Agent Cost tracking? – Setting Agent Costs – Profitability Reports What is Agent Cost tracking? The reporting suite in Halo can be utilised to create profitability reports based on real time data. This allows you to track the profitability of different areas of your business, including […]

SQL Imports – Licences and Subscriptions

In this guide we will cover: – How to complete a SQL Import to import Licences and Subscriptions into Halo This guide covers SQL imports specifically for the use of importing licences and subscriptions into Halo. For a general overview of SQL imports we recommend reading our guide SQL Imports.  How to complete a SQL […]

Ticket Sources

In this guide we will cover: – What is a Ticket Source? – Adding to Columns and Lists – Ticket Rule Criteria – Setting Source by Actions – Notifications – Excluding/Ordering Ticket Sources What is a Ticket Source? Ticket source is a field that is automatically set to display where a ticket has been created […]

Mail Processing FAQs

In this guide we will cover: – Frequently asked questions about how emails are processed in Halo This guide will cover a list of frequently asked questions about how mailboxes work within Halo. If you have additional questions following reading the below, please contact support to assist you. How are emails processed by a mailbox […]

Tanium Integration

In this guide we will cover: – Connecting to Tanium – Determine Asset Site – Asset Imports – Import Assets automatically on a schedule – Alerting What is the Tanium integration? The Tanium integration with Halo can be used to import sites and assets from Tanium into Halo. Assets can be set to import automatically […]

Redact Sensitive Audit Logs on a Ticket

In this guide we will cover: – Enabling the Audit Log Tab – Redacting Sensitive Information from Logs Audit logs can be redacted from view, allowing sensitive information such as password or HR fields to be hidden from audit logs and reports. Enabling the Audit Log Tab The auditing tab can be enabled per ticket […]

Chat Web Searching with Virtual Agents

In this guide we will cover: – Creating a Custom Virtual Agent – Configuring a Chat Profile – Configuring the Runbook – Using the Chat Related Guides: Chat Bot and Chat Profiles Virtual Agents in the Chat Bot Virtual agents can be integrated with the chat functionality to allow AI-responses to agent or user questions. […]

Service Users

In this guide we will cover: – What are Service Users? – Bulk Updating Service Users – Importing Service Users from CSP – Excluding Service Users from Automatic Billing – Service User Pop Ups – Service User Ticket Rule Criteria – Service User Dynamic Distribution List Criteria What are Service Users? Service users are a […]