Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
devel:documentation:modules_reports [2017/12/11 16:23] poulm links |
devel:documentation:modules_reports [2022/05/17 06:42] kucerar sql report |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <- .: | ||
+ | |||
+ | {{tag> report}} | ||
+ | |||
+ | ====== Modules - Implemented reports [reports] ====== | ||
+ | |||
+ | The main purpose of reports is to create a snapshot of current data in IdM which can then be downloaded as a CSV or XLSX file. This is often useful for audits or other cases when an overview of a large amount of data in IdM is needed. The reports module gives the basic [[.: | ||
+ | |||
+ | {{ .: | ||
+ | |||
+ | The module is fully dependent on the [[.: | ||
+ | |||
+ | ====== Overview of implemented reports ====== | ||
+ | |||
+ | ==== Identities and their roles ==== | ||
+ | |||
+ | This report allows you to export the list of identities together with their assigned roles. [[.: | ||
+ | |||
+ | ==== Identities, their roles and contract ==== | ||
+ | |||
+ | This report is similar to the one above but contains more information. The generated XLSX file has a clear separation between attributes of identity, contract, and role. [[.: | ||
+ | |||
+ | ==== Roles and their identities ==== | ||
+ | |||
+ | This report allows you to export the list of roles and their holders. [[.: | ||
+ | |||
+ | ==== Identities, their main contract and their roles ==== | ||
+ | |||
+ | This report allows you to export the list of identities (with information about their contracts, incl. one contract EAV) together with their assigned roles (and values of role attributes). [[.: | ||
+ | |||
+ | ==== Identities and their assigned roles changes ==== | ||
+ | |||
+ | This report allows you to export all changes in assigned roles for users in a given time period. You can use filter to only show changes caused by automatic roles (both by position and attribute). [[.: | ||
+ | |||
+ | ==== Identities and their password changes on a system ==== | ||
+ | |||
+ | This report allows you to export all password changes in end systems. You can filter by system, time period, and success of the change. [[.: | ||
+ | |||
+ | ==== Identities and their system account (state) changes ==== | ||
+ | |||
+ | This report allows you to export all account changes in end systems of the type CREATE, DELETE and ENABLE. You can filter by system, time period, type of operation, | ||
+ | |||
+ | ==== Virtual system archived request report ==== | ||
+ | |||
+ | This report allows you to export all archived (realized or rejected) requests on virtual systems. You can filter by time period. [[.: | ||
+ | |||
+ | ==== Identity complex report ==== | ||
+ | |||
+ | This report allows you to export complex information about users, their contract and their identity form values (EAVs). [[.: | ||
+ | |||
+ | ==== Complex report of identities, their roles and contracts attributes ==== | ||
+ | |||
+ | This report allows you to export complex information about users, their contract and their assigned roles. [[.: | ||
+ | |||
+ | ==== SQL Universal report ==== | ||
+ | |||
+ | This report allows you to export complex information based on table/view name or custom SQL query. [[.: | ||
+ | |||
+ | ====== Read more ====== | ||
+ | |||
+ | ===== Admin tutorials ===== | ||
+ | |||
+ | * [[: | ||
+ | |||
+ | ===== Devel guide ===== | ||
+ | |||
+ | * [[.: | ||
+ | * [[.: | ||
+ | * [[.: | ||
+ | |||
+ | ===== Devel tutorials ===== | ||
+ | |||
+ | * [[: | ||
+ | |||