# Report for Workgroup Members

**URL:** <https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960>\
**Category:** IIQ Discussion and Questions\
**Tags:** workflows, identityiq\
**Created:** [December 18, 2024, 11:40am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960 "2024-12-18T11:40:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\
**Post date:** [December 18, 2024, 11:40am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/1 "2024-12-18T11:40:56Z")

</div>

Hi all,

Is there a way to get all the members of a Workgroup through Reports/Advance Analytics?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Arun-Kumar](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arun-kumar/32/15128_2.png) [@Arun-Kumar](https://developer.sailpoint.com/discuss/u/Arun-Kumar)\
**Post date:** [December 18, 2024, 11:59am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/2 "2024-12-18T11:59:13Z")

</div>

Hi @rishavghoshacc ,

You can retrieve the members of a workgroup from Advanced Analytics. Simply select “Identity” as the Search Type and choose the desired workgroup to view its members.

 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/f/2/f26e4d709f5bfb017a66879fa5a54d57dde1c292.png)

---

<div class="post-metadata">

**Author:** ![rishavghoshacc](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rishavghoshacc](https://developer.sailpoint.com/discuss/u/rishavghoshacc)\
**Post date:** [December 18, 2024, 12:01pm UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/3 "2024-12-18T12:01:50Z")

</div>

@Arun-Kumar Is this possible using the Advanced Search in the Identity Search?

I want to get all the members by simply inputting a set of 100 Workgroup Names

---

<div class="post-metadata">

**Author:** ![angelborrego](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/angelborrego/32/21987_2.png) [@angelborrego](https://developer.sailpoint.com/discuss/u/angelborrego)\
**Post date:** [December 18, 2024, 12:47pm UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/4 "2024-12-18T12:47:17Z")

</div>

I think there is not an option in Advanced Analytics to do that, but you can create a simple rule and use a SailPoint-built method called getWorkgroupMembers to obtain the members of the workgroup.

Here you can see an example of the code to do that:

```auto
  import java.util.Iterator;
  import sailpoint.api.ObjectUtil;

  //Save workgroup members in list “wrkgmemnberList”
  Iterator wrkGrpmembers = ObjectUtil.getWorkgroupMembers(context, id, null);
  List wrkgmemnberList = new ArrayList();
    
  while(wrkGrpmembers.hasNext()){
    Object[] object = (Object[]) wrkGrpmembers.next();
    Identity ids = (Identity) object[0];

    wrkgmemnberList.add(ids.getName());
  }

```

---

<div class="post-metadata">

**Author:** ![angelborrego](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/angelborrego/32/21987_2.png) [@angelborrego](https://developer.sailpoint.com/discuss/u/angelborrego)\
**Post date:** [January 2, 2025, 8:47am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/5 "2025-01-02T08:47:18Z")

</div>

Hi @rishavghoshacc, was the code I shared with you helpful?

---

<div class="post-metadata">

**Author:** ![Arpitha1](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/arpitha1/32/20512_2.png) [@Arpitha1](https://developer.sailpoint.com/discuss/u/Arpitha1)\
**Post date:** [January 3, 2025, 2:21am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/6 "2025-01-03T02:21:15Z")

</div>

Hi @rishavghoshacc

You can try with below filter in advanced search. Replace NAME1, NAME2 from your workgroup names.

`workgroups.collectionCondition("(name i== \"NAME1\" || name i== \"NAME2\")") `

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 4, 2025, 2:22am UTC](https://developer.sailpoint.com/discuss/t/report-for-workgroup-members/93960/7 "2025-03-04T02:22:07Z")

</div>

Closed on March 4, 2025, 2:22am UTC

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.