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.
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:
Hi bradc, Eduardo Fuentes 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!
© 2017 Appian. All rights reserved.