Daily Call report

[TPA_Support]

I want an SQl Qurries, as i have zero knowledge about sql. Actually, I want to create an email report which will send detailed daily call details with pending call details of all previous calls.

Currently, I have configured one daily email report which only sends calls of Daily incident only, not pending call details.

[Esben_D]

Easier way of doing it would be to create a copy and modify the built-in report called "Helpdesk: All tickets whose current state is Open"

You can then change htblticketstates.statename (which has the criteria = 'Open') to = 'Pending' (make sure this is spelled identical to your state).

Lastly, you can add > Getdate() - 1 to htblticket.date as the criteria and then save and run the report.

[Esben_D]

Am I right in assuming that with call details you mean helpdesk ticket details, and pending call details are ticket set on the pending state?

[TPA_Support]

Charles.X wrote:
Am I right in assuming that with call details you mean helpdesk ticket details, and pending call details are ticket set on the pending state?

Yes...