halopsa_query
Execute SQL queries to retrieve data from HaloPSA tables including tickets, users, sites, actions, and request types through the reporting API.
Instructions
Execute a SQL query against HaloPSA reporting API. Use this to retrieve data from any HaloPSA table including tickets (FAULTS), users (USERS), sites (SITE), actions (ACTIONS), request types (REQUESTTYPE), and more. Returns the full report response with data rows, column metadata, and available filters.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query to execute against HaloPSA database. Supports standard SQL syntax including SELECT, JOIN, WHERE, ORDER BY, GROUP BY, etc. Example: SELECT * FROM FAULTS WHERE Status = 1 | |
| loadReportOnly | No | Whether to load report data only (default: true) |
Input Schema (JSON Schema)
{
"properties": {
"loadReportOnly": {
"default": true,
"description": "Whether to load report data only (default: true)",
"type": "boolean"
},
"sql": {
"description": "SQL query to execute against HaloPSA database. Supports standard SQL syntax including SELECT, JOIN, WHERE, ORDER BY, GROUP BY, etc. Example: SELECT * FROM FAULTS WHERE Status = 1",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}