Email notification to requester with list of all active tickets for specific assignment group

[Brahmi Pandla]

Hi Everyone,

I have a requirement  for  to send notification to requestor  with list of all active tickets which are assigned to specific assignment group.

1) assignment group is one of the catalog variable

2) Records should send table format

How i achieve this

Could  anyone please help

[Ankur Bawiskar]

@Brahmi Pandla 

Steps

1) So you can create a scheduled job which runs daily

2) Iterate over that catalog item which has that assignment group

3) Gets active tickets (tasks or incident) for that group and send email

Note: you will have to use event, notification, email script for this

Another way is to use scheduled report

Email scheduled report of unassigned tickets to the User Group Managers and their Managers of the gr... 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Brahmi Pandla]

Hi @Ankur Bawiskar 

Thanks for your response 
 First step not required for me

I need only get the active ticket from task table and send the notification to requestor with ticket numbers

Could you please help me with script for getting the active records

[Ankur Bawiskar]

@Brahmi Pandla 

Request you to close your earlier questions by marking appropriate response as correct.

I have provided solutions to most of those.

Members invest their time and effort in helping members.

Marking those as correct helps future community members.

[Ankur Bawiskar]

@Brahmi Pandla 

I will suggest you to start from your side and it will be learning for you as well.

Without this you won't learn and won't develop the developer skills

If my response helped please mark it correct and close the thread so that it benefits future readers.