HaloPSA | A Learning Journey ( Agent Costs + Burden Rates Report )
In this video we discuss how to work out Agent Costs/Burden Costs and we create a report together.
HaloPSA SQL Schema - https://halopsa.com/sqlschema/
Require our assistance? Website: https://renada.co.uk/
Sign up for a Trial : https://trial.halopsa.com/trial/signu...
HaloPSA Discord Community - / discord
MSP's in the UK Discord - / discord
MSP Geek Discord - / discord
HaloPSA Reddit - / halopsa
SQL
select
faults.faultid as [TicketID],
aareadesc as [Customer],
Uname as [Agent],
sum(ucostprice*timetaken) as [Agent Cost],
sum(timetaken) as [Time Taken],
rtdesc as [Ticket Type]
from faults
left join area on areaint = aarea
left join requesttype on rtid = requesttypenew
left join actions on faults.faultid=actions.faultid
JOIN Uname on uname=who
group by faults.faultid,area.aareadesc,Uname.uname,actions.timetaken,requesttype.rtdesc