Appian Usage Insights

Hi Team,

              is it possible to release the DB scripts for MS SQL Server as well.

thanks in advance

Amit

For Cloud sites, 30 days is the max as after that logs are compressed and the plugin does not collect data from compressed logs. I wouldn't recommend running collection multiple times per day - usually you'd configure this somewhere between 7 and 30 days depending on your reporting needs.

Could you please check and confirm us about these points regarding "Appian Usage Insights Data Collector" application.

 -Data collection time period. 

-Whether data collection can be done multiple time or not. 

We already tried to change the value of constant "LMA_DC_INTEGER_LOGINS_INITIAL_HISTORY_HORIZON" from default value 30 days to required value 365 days, but we are not getting the expected result. Also, we have observed a strange behavior- In Data package login details are capture When first time data collection is done on a particular day, but if again data collection is done on same day then no login details are being exported to the data package. 

Hi,

Yes, the collection plugin supports HA log structure.

Regards,

David

Hi,

Is it safe to assume this is compatible with HA environments (i.e., login information will be retrieved for all app servers)?

Thanks

v1.1.1 Release Notes

• Added support for Oracle database. See /documentation/Release Notes.txt for full details.

You can request to roll back to an earlier version of a plugin via a Support Case, or alternatively there is now a newer version of the plugin (2.2.11) that fixes this issue.

Thanks David. 

We are using version 2.2.10 of the Excel Tools. Since we are using Appian cloud I guess there is no easy way to move to an older version of the plugin. 

Hi, are you using v2.2.10 of the Excel Tools plugin? I was able to replicate this issue (with MariaDB but I think this will apply to MySQL too) using v2.2.10 -> "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:ss'". I believe this is an issue with version 2.2.10 of the Excel Tools plugin, whereby the Import CSV to DB smart service fails to properly import dates. You should be able to address this by moving to the previous version (2.2.9) of the Excel Tools plugin.

Hi,

I'm running into an issue when running a collection run. The node 'Import CSV to Audited Logins table' goes into error with the following message: "Date Format must be one of the following 'yyyy-MM-ddTHH:mm:ssZ','yyyy-MM-dd', 'HH:mm:ss'"
However, the format in the csv contains date in the format "2020-12-14 08:00:59"

It could be that our DB's are upgraded to MariaDB which is causing this issue.