How can list all incidents raised by my group members.

[Pankaj Grover1]

Hi All, Can you please help me to get the report where I can list down all the incidents opened by my Team members.

Example: I am a lead of 2 groups and I wanted to have the list of incidents which have been raise by/opened by my group members and same must be visible to all members as well.

@Adam Stout :Hi Adam, can you suggest something in this?

[kumaril1]

Hi Pankaj,

You can use dynamic filter for that

https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/using-lists/task/t_Dynam...

[Vallabh Baradk1]

Hi Pankaj ,

You can try below process,

1) use client callable script include,

Name = members

Client Callable = true

Script

var groupMember = Class.create();
groupMember.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getMember: function(members){
var mbrs = "";
var gr = new GlideRecord("sys_user_group");
gr.get("name",members);

var grmember = new GlideRecord('sys_user_grmember');
grmember.addQuery('group', gr.sys_id);
grmember.query();
while (grmember.next()) {
mbrs += grmember.user.user_name.toString();
if(grmember.hasNext())
mbrs += ",";
}

return mbrs;

},

type: 'groupMember'
});

2)On Incident table, on list view you can use that script include name. see below screenshot. Put any group name for which you want to find out the list of incidents created by those group members

 

Please mark Helpful , if it works.

Thanks,

Vallabh

Dxsherpa Technology Pvt Ltd

[Pankaj Grover1]

it's not taking the condition as mention in your step 2.

[kumaril1 · Accepted solution]

Below are snapshot will help you