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
  • Hi

    Hope your doing Well!

    I could parse last one month files from system log named "login-audit.csv.2019-10-23" however the files before that were compressed and the named "login-audit.csv.2019-09-05.gz" and the plugin is throws null pointer exception.

    can you update the plugin so that it should check for these extension file and if exist then it should be capable of extracting zip and read the file?
    login-audit.csv.2019-09-05.gz>login-audit.csv.2019-09-05

    Or do we have any other plugin which help me here?

    Thanks in Advance

Comment
  • Hi

    Hope your doing Well!

    I could parse last one month files from system log named "login-audit.csv.2019-10-23" however the files before that were compressed and the named "login-audit.csv.2019-09-05.gz" and the plugin is throws null pointer exception.

    can you update the plugin so that it should check for these extension file and if exist then it should be capable of extracting zip and read the file?
    login-audit.csv.2019-09-05.gz>login-audit.csv.2019-09-05

    Or do we have any other plugin which help me here?

    Thanks in Advance

Children