AIC for reports - RoleName, EntitlementName, SourceName

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

Hi All,

I am wondering if anybody has used AIC to build reports.

For instance, I am working on extracting a report which gives just 3 columns:

“Role Display Name, Entitlement Display Name, Source Display Name”

I know I can utilize APIs to get this and I have one already but i want to explore if getting such data from AIC is possible. This will help decommission a lot my scripts/codes but i want to start with this basic report.

We have SDS too but the data on SDS has been nothing but unreliable so we are not renewing SDS license.

2

AIC (AI‑based Identity Security in ISC) is not meant to be a reporting or extract layer, and today it cannot reliably replace API-based reporting for a Role → Entitlement → Source style report.

3

Hey @lampard08

I worked on AIC a few months ago, we have had a lot of mapping issues that we had to open tickets with SailPoint. The only data I was able to get correctly was completed certification campaign data. I know this does not answer your question directly but that was my experience with AIC

4

Thanks @utkirjonkamiljanov

So in general, you were able to get the data as a report?

Can you help me how to go about building one please. any report.

5

Unfortunately I don’t have access to that tenant anymore otherwise I would have shared the expressions directly. We had a weird structure where our quarters started in December instead of January, so I had to write a lot of custom QLick expressions. The tricky part is knowing the correct field names in the AIC data model. From my experience, I tried mapping access profiles and entitlements to sources for dashboards but kept running into mapping issues — the data just wasn’t reliable. The only thing that worked consistently for me was certification campaign data — things like how many managers certified, number of reassignments, completion rates etc. That data was solid.

6

IMG_1890
IMG_18901320×741 203 KB
This is just one of the things I tried to build and the only screenshot I have remaining unfortunately.

7

this is great. i understand the data is not reliable but just want to give it a shot. can you please point me to some documentation where i can learn/understand the expression building for qlik. I am trying to find some but looks like there are multiple qlik products and not sure what is the right one for used by Sailpoint.

8

I just went through the AIC videos and a couple of YouTube tutorials: Access Intelligence Center Videos | SailPoint Developer Community

Also in my case, I was the only one with some Power BI knowledge and was asked to customize the AIC even though I had never written Qlik expressions before. I was told to use AI to get at least something working so we could present it to management.

9

Thanks a lot @utkirjonkamiljanov