Login Information Parser

Overview

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
Anonymous
Parents
  • Hello,

    Recently we started getting an error when trying to invoke the "Import Login Information" smart service. We are calling this smart service whenever user tries to login to the system first time, to capture first login details. We have not seen this error coming before, started from today itself.
    It did worked for few users and thrown below error for couple of them so as such random behaviour

    ERROR Message:
    java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

Comment
  • Hello,

    Recently we started getting an error when trying to invoke the "Import Login Information" smart service. We are calling this smart service whenever user tries to login to the system first time, to capture first login details. We have not seen this error coming before, started from today itself.
    It did worked for few users and thrown below error for couple of them so as such random behaviour

    ERROR Message:
    java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

Children
No Data