Login Information Parser

The Smart Service, Import Login Audit, will read your login audit file(s) and populate a database with information about logins.  This is provided mainly as an example (source code provided) as you may need to modify the smart service to make it work with your environment.

  • Requires a table named "logins" in the specified datasource.  The example SQL is provided.
  • Inputs:
    • datasourceName: The datasource where the login information will be populated
    • date: The date suffix for the login_audit.csv* file to be read. If null, it reads the latest file.
  • Supports MySQL, Oracle and Microsoft SQL Server databases
  • To those using this plugin - I discovered an issue where some of our users are logging IP addresses longer than the 20 characters set on the table in the documentation.  The IP address logged is two addresses separated by a comma and space. I would recommend extending the ipaddress column length to at least 50 (I did 100 just to be safe) to avoid this issue.  The plugin will simply write records up to the point a record would be truncated and stop writing additional records.  

    Here is a link to some information I found regarding why there would be two IP addresses logged:

    serverfault.com/.../742754

  • Hi , made an update to the Plug-in listing and the sample DDL for the table now references a length of 50.  Thanks for the suggestion!