Reporting Options

All data in Hitachi ID Password Manager is in a normalized, relational database schema and can be accessed using standard analytical tools (Crystal Reports, Cognos, MS-Excel, SQL queries, etc).

The schema is well documented and is available to all product licensees and evaluators under NDA. The current release schema documentation is about 127 pages long and includes detailed descriptions of every field, table, relation, value constraint, etc.

Hitachi ID Systems customer can add custom reports to the Password Manager 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 Password Manager back-end database, but can also pull data from other sources (e.g., web services, other SQL databases, LDAP directories, etc.).

Password Manager includes various built-in reports, including:

  • User Reports
    • Matching user ID (string).
    • Matching user names (string).
    • By disabled only? Y/N.
    • List accounts? Y/N.
    • Matching target identifiers (string).
    • Matching target names (string).
    • Target type (drop down list).

  • Target System Reports
    • Matching target identifiers (string).
    • Matching target names (string).
    • Target types (drop down list).
    • List accounts Y/N.
    • Matching user ID (string).
    • Matching user names (string).

  • Event Reports
    • Matching session IDs (string).
    • Matching user IDs (string).
    • Matching target identifiers (string).
    • Matching target names (string).
    • Target type (drop down list).
    • Event type (drop down list 46 different selectable, all).
    • Event list (number).
    • Requested by (string).
    • Earliest date/time.
    • Latest date/time.

  • Synchronization Reports
    • Matching user IDs (string).
    • Matching target identifiers (string).
    • Matching target names (string).
    • Target type (drop down list).
    • Currently queued or failed events.

Screen Shots


Image:  /password-manager/screen-shots/dashboard
(Click to enlarge)

Dashboard:

A simple dashboard shows the Hitachi ID Password Manager administrator which products are installed, how many users have been licensed, how many user profiles actually exist in the environment and the number of users who have completed every type of enrollment step (security questions, ID mapping, etc.).


Image:  /password-manager/screen-shots/enrollment
(Click to enlarge)

Enrollment:

Show how many users have completed various types of enrollment steps.


Image:  /password-manager/screen-shots/enrollment-invited
(Click to enlarge)

Enrollment - invited:

Show how many users have been invited (typically via e-mail or popup web browser at login time) to complete various types of enrollment steps.