On Reporting Options
All data in Xpress Password is in a normalized, relational database schema and can be appraised using standard analytical tools (Crystal Reports, Cognos, MS-Excel, SQL queries, etc).
The schema is well documented and is accessible to all product licensees and evaluators under NDA. The current release schema documentation is approximately 127 pages long and includes detailed descriptions of every field, table, relation, value constraint, etc.
ILANTUS customers can request to add custom reports to the Xpress Password web UI, so that they can be run interactively, scheduled, have output delivered via e-mail, etc. These reports are written using short Python scripts that mostly contain a SQL SELECT statement which interacts with the Xpress Password back-end database, but can also pull data from other sources (e.g., web services, other SQL databases, LDAP directories, etc.).
Data available through Xpress Password includes but is not limited to:
- A list of login IDs per user.
- A list of user IDs per system.
- Identity attributes and group memberships for each user.
- Linkage between (possibly nonstandard) user IDs and people (user profiles).
- Full detail of transaction history.
- Status of the user enrollment process.
Xpress Password includes many built-in reports, available through its web portal:
- Lists of users and accounts, by system or universally.
- Metrics regarding enrollment progress.
- System utilization data.
- Lists of target systems, with or without login accounts on each.
- Lists of events, by type, user, administrator, resource, time and other criteria.
- Lists of enrolled users or users with incomplete profiles.
- Statistical analysis of user, help desk analyst and server transactions in a time period.