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

Parents

spandanat over 3 years ago

HiEduardo Fuentes,

Your server is configuration with 'High Availability' so we have 3 nodes of logs.

so we are missing data into table for around 445 users.

The Plugin is parse randomly available node, any solution for this?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

spandanat over 3 years ago

HiEduardo Fuentes,

Your server is configuration with 'High Availability' so we have 3 nodes of logs.

so we are missing data into table for around 445 users.

The Plugin is parse randomly available node, any solution for this?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

paulc919 over 3 years ago in reply to spandanat

Hi - the Log Reader plug in has recently been upgraded to allow you to specify the HA node you wish to investigate logs for. It might be possible to recreate your login process to use this plug in instead.

https://community.appian.com/b/appmarket/posts/log-reader
- Cancel
- Up 0 Down
- Reply
- More
- Cancel