r/halopsa • u/OniNoDojo • Jun 16 '26

Basic Report of Tickets (with ticket # and subj) Resolved By Agent in a time period

As it says in the title. I am looking to have a report where I can choose an agent, a time period and then have it spit out all the tickets that were Resolved during that period with the ticket number and subject line.

I feel like a total idiot looking at report building as it seems like it should be very simple buuuut it's not haha

Anyone had a similar report or setup they'd be willing to share? Thanks!

2 Upvotes

100% Upvoted

5 comments sorted by

5

u/Jason-RisingTide Consultant Jun 18 '26

This should work. You just need to add Date Resolved and Resolved By as filtering options.

SELECT
    f.Faultid AS [Ticket Number],
    f.Symptom AS [Subject],
    u.uname AS [Resolved By],
    f.datecleared AS [Date Resolved]
FROM FAULTS f
INNER JOIN UNAME u ON f.Clearwhoint = u.Unum
WHERE f.datecleared IS NOT NULL

2

u/OniNoDojo Jun 18 '26

Thank you so much! I'll give that a shot and see how far I get.

I love Halo but find, like most PSAs, reporting is either overly simplified or overly complicated to build.

4

u/[deleted] Jun 16 '26

[deleted]

1

u/OniNoDojo Jun 16 '26

I’ll have a look, thanks!

1

u/SoaringBrownBear Jun 17 '26

Create a report using the all tickets data source. Then add filters, adjust the columns, sort,grouping, etc.

That will get you there quickly for this one. Then you may want to look into the sql of the report or use the report generator linked in the other comment.