This project collects user login dates and times to allow for access-based billing for Vision based on user logins.  Users can be grouped into “Accounts” for easy reporting.  Reports can be exported to Excel as needed.

The software connects to the Vision Informix database server on the AIX server to run the queries to pull reporting information.

Reports can be generated by selecting multiple databases.  When the report has run, the list of users will be displayed with their login count totals for the time period specified.  You can double-click on the user and get details about that user’s login times for the entire period and export to Excel if needed.

A “Quick Report” can be run by selecting it from the drop-down box.  This will automatically populate the Database selector and return only users who are configured in this “Quick Report” filter.

Quick Reports can be created by running a report for a given database or databases and selecting the users by placing a check mark next to their username and then choosing the option to create a Quick Report filter and giving it a name for future reference.

Quick Report filters are saved to an XML file which is read upon application start-up or new Quick Report created.

Screenshots

Quick Report generation

Double-click on a user's login to access detailed information for that particular user. You can also export just these details to Excel as needed.

User Activity Line Chart using Pivot Table in Excel. This is automatically done for a selected user group when you run detailed reports over a timespan to find trends, etc.

Notes

Install I-Connect 2.90 (Information pertaining to i-Connect at IBM’s website here.) Download I-Connect 64bit or 32bit for Windows.

Modify c:\windows\system32\drivers\etc\services and add:  ifx 1541/tcp to the end.  Here’s a command to do this (from elevated prompt as administrator):

echo "ifx 1541/tcp" >> c:\windows\system32\drivers\etc\services