Pull report of Workgroups and their members in SailPoint

[derrickthomasvdot (Derrick Thomas)]

Which IIQ version are you inquiring about?

8.3

Please share any images or screenshots, if relevant.

Share all details about your problem, including any error messages you may have received.

Is there a way to pull a report of all present workgroups and their members? I have attached a screenshot from our test environment. Where can the workgroups and the members be found in the Object Browser?

[vishal_kejriwal1 (Vishal Kejriwal)]

try below report

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE TaskDefinition PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<TaskDefinition executor="sailpoint.reporting.LiveReportExecutor" name="Vishal WorkGroup Member Details" progressMode="Percentage" resultAction="Rename" subType="Identity and User Reports" template="true" type="LiveReport">
  <Attributes>
    <Map>
      <entry key="TaskDefinition.runLengthAverage" value="4"/>
      <entry key="TaskDefinition.runLengthTotal" value="4"/>
      <entry key="TaskDefinition.runs" value="1"/>
      <entry key="report">
        <value>
          <LiveReport title="User Details Report">
            <DataSource defaultSort="name" objectType="Identity" type="Filter">
              <QueryParameters>
                <Parameter argument="queryFilter">
                  <QueryScript>
                    <Source>
                            import sailpoint.object.*;
                            import java.lang.*;
                      
								 Filter f = Filter.eq("workgroup",true);
                                 queryOptions.addFilter(f);                                       
                            return queryOptions;
                          </Source>
                  </QueryScript>
                </Parameter>
              </QueryParameters>
            </DataSource>
            <Columns>
              <ReportColumnConfig field="Workgroup" header="Workgroup" property="name" sortable="true" width="110"/>
              <ReportColumnConfig field="members" header="Members" property="id" width="110">
                <RenderScript>
                  <Source>                    
                    import sailpoint.object.*;
					import java.util.*;
                          
                    				
					List wgs = new ArrayList();
               
                    List props = new ArrayList();
					props.add("name");
					
					QueryOptions qo = new QueryOptions();
   
					  qo.addFilter(Filter.eq("workgroups.id", value));
					  Iterator entIter = context.search(Identity.class, qo);
					  
					  while(entIter.hasNext()){							
					  Identity wg = (Identity)entIter.next();
					  wgs.add(wg.getName());
					  }
								  
					return wgs;	  
                          
                  </Source>
                </RenderScript>
              </ReportColumnConfig>
            </Columns>
          </LiveReport>
        </value>
      </entry>
    </Map>
  </Attributes>
  <Description>A detailed view of WorkGroup Members.</Description>
</TaskDefinition>

https://community.sailpoint.com/t5/IdentityIQ-Forum/Report-To-Get-Members-of-All-Workgroups/m-p/177452#M142204