Login Audit

LA_TX_LOGIN_URL is the URL for your Appian suite

LA_TXT_SYSTEM_NAME is whatever you call your system (this is used for a system generated email)

LA_TXT_SERVERS is a list of your application servers. For a single-node environment in Appian Cloud it is generally the URL with ".appiancloud.com" stripped off. For HA there will be numbers at the end of each (you can reach out to Appian Support if you do not know your app server names). For self-managed, app server names can be found in your config

Hi team,

first of all thank you for this useful app! However we noticed a wrong behaviour in the LA_convertTimestampToDateType rule. I think it only happens when the primary locale of the site is different from en_US, as in our case. The effect of this bug is that the date 2024-09-12 is converted to 9 Dec 2024 and the date 2024-09-15 is converted to 15 Sep 2024.

I suggest to fix the expression of the rule to the following code in order to prevent this to happen:

if(
and(
ri!day => 1,
ri!day <= 31,
ri!month => 1,
ri!month <= 12,
len(ri!year) = 4
),
date(ri!year, ri!month, ri!day),
null
)

Thanks!

Hi Max,

Thanks for replying.

I have the documentation but I need information on how can I get below details from my Appian environment:

1. LA_TXT_LOGIN_URL

2. LA_TXT_SYSTEM_NAME

3. LA_TXT_SERVERS

Can you help me please

Hi, instructions for setting these variables can be found in the "Log Reader Documentation" pdf included in the download. If you have any issues from there, happy to help. Thanks

Hi Team,

We are using Appian cloud (24.2) and wanted to configure this for one of the client. 

I need details on where to find information on the variables that has to be configured it in properties file.

1. LA_TXT_SERVERS

-->Is it same as Admin Console >  Monitoring > Current User Activity > Server

2. LA_TXT_LOGIN_URL

--> Is it same as Admin Console> System> User Start Pages > Default Start Page ??

3. LA_TXT_SYSTEM_NAME

• Improved data management for large user bases

Thank you for the clarification Max. I couldnt get the point that this was an application! And many thanks for pointing out about the  LA_TXT_SERVERS constant for High Availability environment as well. Appreciate your help!

Best wishes,

Pavan

Hi pavana162, This is not a plugin, it is an Appian application built on top of the Log Reader plugin. As noted in the documentation, you'll want to ensure you have Log Reader and Personalization Utilities installed as plugins. Run the sql against your database schema and include the updated properties file with your import of the application zip. 

Yes, the information will be accurate for a high availability environment as long as you set the LA_HA_SERVERS constant accurately.

We are on Appian 24.1 cloud environment and need this plugin for a business requirement. However, the plugin is not to be found when I click on the "Add New Plugins" from the Admin console. Also, it is not available for Direct Upload  as Im getting an error that this plugin is not approved.

The documentation mentions installing the plugin after running a SQL and updating a .properties file. However, I don't see an option to use a properties file while deploying on cloud. Any ideas/ experience installing this plugin on cloud?

Also, would the information be accurate for a high availability environment? Would be great if anyone having some experience can provide some guidance.

Thanks,

Pavan

• Displays login time for daily logins rather than the date