Custom Application Attribute Report

[biswash53 (Biswash Nepal)]

Which IIQ version are you inquiring about?

*8.3

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

*I need to create a custom application attribute report. I need to be able to filter the attributes so that only selected attributes can show in the report. Does anyone know how I can do that? I have application that have different attributes and the report can be too long if I use the OOTB one which shows all of the attributes.

[vinnysail (vinod kumar maram)]

Hi @biswash53,

Create a custom report using a report query, you can define a query based on application attributes.

QueryOptions qo = new QueryOptions();
        qo.add(Filter.eq("name", "AppName")); // Replace with your application name

get all attributes whatever you have defined.

then you can specify the columns that you want to include in the report. Save the report.

You can run with the required attributes whenever you are running the report with what ever columns you need.

[biswash53 (Biswash Nepal)]

I have many applications and this report should be able to used for all of them, The ootb has a filter for application already I want the report to be able to filter attributes based on whatever application is selected. The custom report I am creating is using sailpoint.object.Identity as the objectType and Filter as the type. I can reuse everything from the out of the box account attributes report but in that I want to add the attributes filter.

[SivaLankapalli (Siva Sankar Lankapalli)]

Hi Biswash Nepal,

After checking, I see that if you can explain more about your requirements, it will help us provide guidance. A couple of OOTP reports in SailPoint fetch data on applications/application accounts. You can use them to test and see if they accommodate your requirements.

You can duplicate those reports and modify them according to your request.

If you would like to pass any additional input to them, you need to create a form and attach it to the report.

Thanks,
Siva

[biswash53 (Biswash Nepal)]

@SivaLankapalli Hi so I am working with the OOTB Account Attributes Live Report. That report shows all of the account attributes, all I need is to be able to filter the attributes so that the report will only show the selected attributes rather than everything. For some of the applications we have a lot of users so showing all of the attributes is not feasible for us. Since the OOTB is a java type report I cant change or add anything to it, that is why I need to create a custom report where the users can pick and choose what attributes they want in the report.

[santhirajumunganda]

Hi @biswash53

If you want to generate a report with specific application attributes, you can create a TaskDefinition object like the one shown below. Then, import it and go to the Reports tab to create a new report.

I’ve tested the sample report below and got positive results. Please try it out and let me know if it works for you:

Account Attributes Report.xml (1.7 KB)

This report retrieves link attributes based on a specific application. You can customize the HQL and report columns as needed.

Also, refer to the link where @HemantSingh shared a report that fetches both identity and link attributes based on an application.

HQL query to retrieve linked attribute value

Which IIQ version are you inquiring about? Version 8.3 Share all details related to your problem, including any error messages you may have received. I am looking to set up a custom HQL report that will return several identity attributes and one or two attributes from linked applications. Can anyone point me in the right direction on what the HQL query would look like? The identity attributes are straightforward, but looking specifically for the part of the query to get the linked attribute inf…

If you’re looking to learn more about creating custom reports, @enistri_devo has provided a helpful explanation in the documentation below.

Report: How to modify and create custom report

Introduction Report, the dark side of Sailpoint. At first sight, the reports on Sailpoint may seem difficult to create and manage and it is true, but they have their own logic that once understood will make everything more simple. On this blog, I want to explain the structure, the main components of a report and how they interlace with each other. Finally, I want to share with the community a report template with a special configuration and with the possibility of adapting to all cases. Report…

Let me know if it is useful.

Thanks,
Raju