Reports
All data in ID-Access® is available via ODBC and accessible using standard analytical tools (Crystal Reports, MS-Access, MS-Excel, SQL queries, etc).
The schema is well documented and this documentation is available to all product licensees and to evaluators under NDA. The current release schema documentation is about 175 long, and includes detailed descriptions of every field, table, relation, value constraint, etc.
Data available through ID-Access includes:
- A list of user IDs per target Active Directory domain.
- A list of group IDs per target Active Directory domain.
- A cross-table connecting users to groups in which they are members.
ID-Access includes a number of standard reports, available through a web user interface, from the command-line, or by e-mail:
- Users who have accounts on specific domains.
- User groups available on target systems.
- Membership of users in user groups on target systems.
- Transaction history per time period.
- Authorizer actions.
- Delegations (current and pending).
- Requests, by status, state and result.
- Request statistics.
- Past Reports.
All ID-Access reports are available in either HTML or CSV formatted output. HTML output can be displayed directly on the reporting page of the ID-Access administration web GUI. Both HTML and CSV output may be generated asynchronously (i.e., in the background), with output delivered via a network share or e-mail when ready. In this way, any report data can be easily exported from ID-Access and imported into external spreadsheets, database tables, etc.
In addition to directing report output to CSV files, it is possible to generate direct extracts of ID-Access tables, either by attaching an ODBC driver to a copy of the ID-Access database or by using a command-line program included in ID-Access to generate a CSV file. These methods allow ID-Access to extract any data, including data that is not available through packaged reports and develop its own reports or integrations.
A full schema of the ID-Access database is available to all customers. It is over 100 pages and describes the contents of and relationships between every table and field.