Hi Everyone,
Please note, We need send a mail to team members/group mail Id for receiving the Ticket case(Service Request) details from Dynamics CRM portal in daily basis with schedule time.
In this, We have to filter the every agent ticket details and ticket status like a)open b)Work-in-progress c) Closed 4)waiting for confirmation etc. Herewith I have attached table details for reference.
|
Total No. of Tickets September Month |
43 |
|
No. of Tickets assigned to xxx1 |
1 |
|
No. of Tickets assigned to xxx2 |
16 |
|
No. of Tickets assigned to xxx3 |
12 |
|
No. of Tickets assigned to xxx4 |
3 |
|
No.of Ticket assigned to xxx5 |
10 |
|
Unassigned Tickets |
1 |
|
Information Tickets |
0 |
|
No. of Open Tickets |
2 |
|
No. of Closed Tickets |
34 |
|
No. of Work in Progress |
7 |
|
No. of waiting for client response |
0 |
|
No. of Waiting for confirmation closure |
0 |
|
No.of Hold Tickets |
0 |
Regards,
Vinoth Kumar A K

Report
All responses (
Answers (