Reporting

Reporting

Introduction to Reporting

What is Reporting?

It is the process responsible for collecting data and presenting it in a readable format. These reports can be used to know the status of the applications, to solve possible errors with the data and also to make decisions.

Reporting is an add-on provided by Soffid that offers an easy way to generate reports based on Soffid data model.

In order to manage reports, three authorization levels are allowed:

  1. Permission to access report screen: allows the user to execute the explicitly granted reports.
  2. Permission to schedule reports: allows the user to schedule the execution and delivery of periodic reports.
  3. Permission to admin reports: allows the user to upload or remove reports.

Soffid provides a Report add-on that allows you to define new reports based on Soffid data model. For more infomation about the data model you can visit the data model documentation.

How to install Reporting in Soffid

Installation

Download

Please download the Soffid Reporting add-on.

You can download it at the following link http://www.soffid.com/download/enterprise/ if you have Soffid user with authorization, or in the following http://download.soffid.com/download/ by registering.

Upload

Once the Reporting add-on is downloaded, please log in to IAM Console.

You need to be an administrator user of the Soffid console or a user with permissions to upload addons.

In the Soffid console, please go to: "Main Menu > Administration > Configure Soffid > Global Settings > Plugins"  and upload the addon file, for more information visit the Addons Getting started page

Finally, when the addon is installed, it will be required to restart the Soffid Console.

How to customize Reporting in Soffid

How to customize Reporting in Soffid

Using iReport

Steps

Once you have installed the Reporting add-on you must follow the following steps:

1. Download the iReport classes from Soffid.

1.1. Open the Reports screen.

Main Menu > Administration > Monitoring and reporting > Reports

1.2. Click on the "Reports definitions" tab.

1.3. Click on the hamburger icon.

1.4. Click on the "Download iReport componet" option and save in your computer the file.

1.5. Once you have saved the file, you need to customize the hibernate.cfg.xml file to point your development database.

 
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://172.20.0.2:3306/soffid</property>
<property name="connection.username">YOUR_USER</property>
<property name="connection.password">YOUR_PASS</property>

2. Download the iReport designer from  sourceforge.

2.1. Execute iReport.

To execute iReport in Linux: ./ireport --jdkhome /usr/lib/jvm/jdk1.7.0_80/

2.2. Add iReport addon jar, previously downloaded on step 1.4

Go to: Tools > Options > Classpath and then: Add JAR

 

image-1647254436975.png

5. Design your report, using the hibernate connector or open an existing one.

The data model documentation, including E-R diagrams is here.

6. Upload your report to Soffid Console.

7. Execute or schedule it!!!

 

How to customize Reporting in Soffid

Using JasperReports

Introduction

Soffid provides an addon to execute a custom Jaspersoft report designer. Configure a new Soffid data adapter will be mandatory with the proper data to connect to Soffid console, it will not be necessary to configure the database connection.

Then you can use your custom Jasper report designer, it will be in charge to make REST requests to the Soffid console, and Soffid console will make the requests to the database. 

Steps

Once you have installed the Reporting add-on you must follow the following steps:

1. Download the Report designer from the Soffid download page.

You could donwload in the following link http://www.soffid.com/download/enterprise/ if you have Soffid user with authorization, or in the following http://download.soffid.com/download/ by registering.

2. Open the custom Jaspersoft report designer.

root@soffid:/home/user/Descargas/jaspersoftstudio# ./Jaspersoft\ Studio

3. Add a new Soffid Data Adapter

image-1651765772922.png

4. Design your report or open an existing one.

The data model documentation, including E-R diagrams is here.

5. Upload your report to Soffid Console.

6. Execute or schedule it!!!

 

Reports

Reports

Reports definitions

Description

At the report definitions tab you can add new reports to Soffid Console, and manage the the existing ones.

You can create your own reports, you can visit the How to customize Reporting page, or download then from the Standard reports library page

Screen overview

image-1638197196660.png

Actions

Download iReport component

Allows you to download the ireport-addon.jar.

That add-on will be customized and added to the iReport designer to design your owns reports. You can visit the How to start Reporting in Soffid page.

Upload

Allows you to upload a designed report with iReport tool. You can upload defautl jasper files or customized jasper files as well.

First of all, you need to click the Upload option by clicking in the hamburguer icon. Then Soffid will display a window to pick up the new report (a .jasper file).

Add

Allows you to upload a designed report with iReport tool. You can upload defautl jasper files or customized jasper files as well. 

First of all, you need to click the add button (+). Then Soffid will display a window to pick up the new report (a .jasper file).

Delete

Allows you to delete one or more defined reports. To delete reports, first select the reports, then click on the subtract button (-) and finally Soffid will ask you to confirm or cancel the operation.

Update report

By clicling on a report, Soffid will display the report configuration. You could update and customize the report configuration.

You can download the iReport designer from  sourceforge.

Reports

Scheduled reports

Description

At the schedule reports tab you can schedule or run the report. The report must be defined in the report definition tab.

First of all, you need to select the report you want to execute. Once the report was selected, then you will need to fill in the parameters if they are required. And finally, you can execute the report right now, or shedule the report execution. If you schedule the execution, you would config a Access control list. At this list you would define the users, groups or roles

Screen overview

image-1647260909831.png

image-1676995644176.png

image-1676995941382.png

Standard attributes

For each value of month, day, hour, minute, or day of the week:

 

Actions

Add

Allows you to shedule or execute a report. First of all, you need to click the add button (+). Then Soffid will display a window to pick up the report. Then you need to select the report you want to execute or schedule and click Next button. At the Enter report parameter, you could fill in the required parameter, and click the Next button. Alt the Schedule report execution, you could choose to execute the report right now, or to schedule the execution, to do that, you need to fill in the parameters, and the click the Finish button.

Delete

Allows you to delete one or more scheduled reports. To delete reports, first select the reports, then click on the subtract button (-), and finally Soffid will ask you to confirm or cancel the operation.

Edit

By clicling on a report, Soffid will display the report sheduled configuration. You could update and customize the sheduled configuration.

Reports

Executed reports

Description

At the Executed reports tab, Soffid displays all the reports previously executed. Soffid displays a list with the report name and the execution date.

In addition, you could download the reports previously executed in XML, HTML, CSV or XLS format.

Soffid allows you to define a parameter to establish the maximun number of days to keep generated reports in Soffid. Todo that, you can add the parameter soffid.addon.report.expire at the Soffid parameters page and indicate the maximum number of days.

Screen overview

image-1676995449032.png

Actions

Schedule report execution

Allows you to run or schedule the execution of a report. First, you need to click on the add button (+), then Soffid displays a wizard in which you must select the report you want to execute or to schedule. Once the report is selected, you must click the Next button. Then you can fill in the filter parameters and click the Next button. Then, you need to select if you wan to execute now, or if you want to schedule execution, if you select the second one, you could customize the execution and you could define de access control list. Finally you need to click on the Finish button, and the report will be executed or scheduled depending on you previous selection.

Delete

Allows you to delete one or more executed reports. To delete executed reports, first select the reports, then click on the subtract button (-) and finally Soffid will ask you to confirm or cancel the operation.


Standard reports library

Library

Here you can download standard reports to add to Soffid.

Generate a list of identities

Download: Identities.jasper

Generate a list of accounts

Download: ReportSummaryAD_full_detail.jasper

Generate a summary of the existing accounts

Download: ReportSummaryAD_onlySummary.jasper

Track unmanaged accounts

Download: OrphanAccounts.jasper

Track the usage of business processes

Download: Workflows_metrics.jasper

Get a list of password policies

Download: PasswordPolicies_v2.jasper

Get a list of account types

Download: TypesAccounts.jasper

Catalog of applications and permissions

Download: BusinessRoles.jasper

Catalog of business units and users

Download: BusinessUnits.jasper

Overview of roles and grants

Download: Overview_Report_Per_Application.jasper