How to generate a custom report having all users except those having Business Role ABC

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

*8.3

How to generate a custom report having all users except those having Business Role ABC

2

Hi @niladritalapatra1 ,

Go to Advance Analytics —>Search Type as Identtiy—>Select Advance Search—>edit filter source.

In the filter source add the below query and save it. it will return the identity as per your requirement.

!(id.subquery(sailpoint.object.Identity, "id", "assignedRoles.name.contains(\"ABC\")"))
2 Likes
3

I want it as a report

4

Hi and Hello,

From Advance Analytics,
When you have all what you need. You can always change to report. Than execute or schedule when you want.

image
image1275Ă—1030 82.5 KB

Regards,
Adam

5

But I also need to schedule it and mail it, is there any option to mail if I follow advance analytics approach ?

6

Hi and Hello,

Like I said.
First create data from Advanced Analytics.
Second save data like report.

image
image507Ă—452 30.4 KB

Than from report go to tab “My Reports” find your report from second step.
image
image535Ă—579 32.6 KB

than click and schedule this report.

You have report from Advanced Analytics. which is schedule.

If you want to send it like email you need:

  1. Find this report on debug
  2. Add this code
 <entry key="emailFileFormat">
        <value>
          <List>
            <String>CSV</String>
          </List>
        </value>
      </entry>
      <entry key="emailIdentities">
        <value>
          <List>
            <String>identityidusername</String>
          </List>
        </value>
      </entry>

identityidusername you need to choose from identity cube. Here also you can put workgroup.

Regards.
Adam

7

That is not working, email is not being sent

8

Hi,

You need to show report xml. There need to be bug.
Maybe here “identityidusername”

Regards,
Adam