Database View to show all groups and incidents

AA De Vera
Tera Contributor

Hello All,


I am trying to show all assignment groups and the incidents assigned to them. I'd like to see ALL assignment groups whether they are assigned to an incident or not.

Below is what I tried but did not achieve what is required.

 

AADeVera_0-1669818165031.png

 

1 ACCEPTED SOLUTION

Himavamshi
Tera Guru

Hi AA De Vera,

 

Report 1 DBView.png

sys_user_group view fields.png

incident view fields.png

Records in table.png

 

Description of columns in last screenshot

Name column--> Name of Group from Group table

Assignment Group --> Name of the Group the Incident is assigned to
Number --> Incident Number

 

Thanks,

Himavamshi

View solution in original post

5 REPLIES 5

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

Please try it as below:-

 

Saurav11_0-1669823309765.png

 

Please mark my answer as correct based on Impact.