Actions290
- Action Actions
- Agent Actions
- Appointment Actions
- Approval Process Actions
- Approval Process Rule Actions
- Asset Actions
- Attachment Actions
- Automation Actions
- Canned Text Actions
- Category Actions
- Client Actions
- Contract Actions
- Contract Rule Actions
- Contract Schedule Actions
- Contract Schedule Plan Actions
- Custom API Call Actions
- Feed Actions
- Field Info Actions
- Holiday Actions
- Invoice Actions
- Invoice Payment Actions
- Item Actions
- Knowledge Base Actions
- Lookup Actions
- Notification Actions
- Opportunity Actions
- Outcome Actions
- Product Branch Actions
- Product Component Actions
- Project Actions
- Purchase Order Actions
- Quotation Actions
- Raynet Actions
- Raynet Detail Actions
- Recurring Invoice Actions
- Release Actions
- Release Note Group Actions
- Reporting Actions
- Sales Order Actions
- Secure Secret Link Actions
- Security Check Actions
- Site Actions
- Supplier Actions
- Survey Actions
- Tag Actions
- Team Actions
- Ticket Actions
- Ticket Approval Actions
- Ticket Status Actions
- Ticket To-Do Actions
- Ticket Type Actions
- Timesheet Actions
- Timesheet Event Actions
- Top Level Actions
- Transcription Actions
- User Actions
- Webhook Actions
- Webhook Event Actions
Reporting → Execute SQL Query
AI-generatedSummary
Runs a read-only SELECT query against the HaloPSA reporting database and returns the matching rows. Use TOP to limit the result set; write SQL without comments or semicolons, and note that datetimes are UTC.
Inputs
- SQL (required) — SELECT query to run against the reporting database. Defaults to
SELECT TOP 50 id, summary FROM faults ORDER BY id DESC. Use TOP to limit rows; comments and semicolons are not allowed. Datetimes are UTC.
Output shape
A list of rows returned by the query.
The fields in each row depend on the SELECT statement. The default query returns up to 50 fault records with
idandsummary.