Appian Usage Insights

RE: Appian Usage Insights

ashishm1985 — Wed, 15 Apr 2026 15:10:36 GMT

Unable to open downloaded zip file.. Getting below error.. Can someone help understand the issue?

RE: Appian Usage Insights

Appian AppMarket — Tue, 10 Mar 2026 22:00:00 GMT

v1.2.3 Release Notes

Fixing the issue related to the creation of empty login csv files.

RE: Appian Usage Insights

gajananap0001 — Thu, 12 Feb 2026 21:08:58 GMT

I am extremely dissatisfied with this plug‑in and the level of support provided by Appian. User inquiries are not being addressed, and new versions continue to be released without resolving existing issues or incorporating user feedback. Due to the lack of timely and effective support, I cannot recommend this plug‑in. Consequently, I have uninstalled it from our environment.

RE: Appian Usage Insights

ByteMyst — Mon, 22 Dec 2025 21:09:39 GMT

Is any one keeping this upto date at Appian?

RE: Appian Usage Insights

Johnny Allain-Labon — Wed, 17 Dec 2025 09:57:42 GMT

Hi,

We are using this plugin on Appian 25.3 and the Collect Audited Logins smart service in V1.2.2 does not work. It runs without an error but produces an empty document. We were previously using this functionality in V1.2.0 and it worked fine.

Is this something you could look at please?

Thanks,

Johnny

RE: Appian Usage Insights

Appian AppMarket — Tue, 07 Oct 2025 22:00:01 GMT

v2.0.0 Release Notes

Support for Oracle DB scripts (ORA_Application_License_Reporting.sql, ORA_ALRDC_Data_Collector.sql).

RE: Appian Usage Insights

gajananap0001 — Fri, 11 Jul 2025 21:50:36 GMT

Hi,

Could you please confirm whether this tool is compatible with Appian version 25.1? The documentation mentions compatibility with version 24.3.

However, I installed it on our DEV environment running version 25.1 and encountered the following issues:

Issue #1: Blank audited_login.csv File

The audited_login.csv file in the data extraction ZIP package was blank.
As a result, the process model "ALR Process Data Package" failed with the following error:

Error Details:

Problem: An error occurred while executing an Activity Class.
Details: The identifiers parameter cannot be null or empty.
Recommended Action: Review and correct the activity class, then resume the process.
Priority: High

To address this, I modified the process model to handle null lists.

Issue #2: Foreign Key Constraint Error in ALR Analysis Process

When attempting to run "Run Analysis" from the Collection Run tab, the ALR Analysis process fails.

Error Details:

Issue: Error in the task "Execute Stored Procedure ALR_SP_POPULATE_USER_POTENTIAL_LICENSE_POOL".
Problem: An error occurred while executing an Activity Class.
Details:
(conn=401006) Cannot add or update a child row: a foreign key constraint fails (LicenseTracking.ALR_USER_POTENTIAL_LICENSE_POOL, CONSTRAINT 'ALR_USER_POTENTIAL_LICENSE_POOL_ENTITY_LICENSE_POOL_ID_FK' FOREIGN KEY ('ENTITY_LICENSE_POOL_ID') REFERENCES 'ALR_ENTITY_LICENSE_POOL' ('ENTITY_LICENSE_POOL_ID'))
Recommended Action: Examine and update the activity class to ensure valid foreign key references, then resume the process.
Priority: High

FYI, backend database: MySQL on Appian Cloud.

I’m not sure how to resolve these issues and would appreciate your assistance.

RE: Appian Usage Insights

davidl0016 — Thu, 22 May 2025 11:15:27 GMT

hello, i've seen that it requires the execute stored procedure plugin ( inside the documentation) ... alas this one is flagged as obsolete.

Could you please upgrade it to avoid this dependency ?

Thanks in advance

RE: Appian Usage Insights

Appian AppMarket — Thu, 03 Apr 2025 22:00:00 GMT

v2.0.0 Release Notes

Support for Oracle DB scripts (ORA_Application_License_Reporting.sql, ORA_ALRDC_Data_Collector.sql).

RE: Appian Usage Insights

Appian AppMarket — Wed, 26 Mar 2025 22:00:01 GMT

v2.0.0 Release Notes

Plugin:
Bug fix related to collecting group membership to retrieve users starting from index 0.
Collector app:
Changed name to Appian License Reporting Data Collector (ALRDC)
Moved most data types to Synced Records from CDTs to align with Appian's modern design patterns.
Process models that required sync nodes were also updated to sync data with stored procedure calls.
As such, constants connected to Data Store Entities have been removed.
Reporting app:
Changed name to Appian License Reporting (ALR)
Moved most data types to Synced Records from CDTs to align with Appian's modern design patterns.
Process models that required sync nodes were also updated to sync data with stored procedure calls.
As such, numerous constants connected to Data Store Entities have been removed.

RE: Appian Usage Insights

Appian AppMarket — Tue, 18 Mar 2025 22:00:00 GMT

v1.2.1 Release Notes

Bug fix related to collecting group membership to retrieve users starting from index 0.

RE: Appian Usage Insights

praveenap6705 — Mon, 28 Oct 2024 08:44:05 GMT

We are planning to install this plugin in our DEV environment. Can you please provide to details steps to install this in our dev environment?

RE: Appian Usage Insights

gauravl7665 — Wed, 19 Jul 2023 10:10:46 GMT

Hi team,

We are planning to use this app for collecting user activity. I have two questions about this app

1. If we have HA setup with multiple appian nodes, will the collector collect users and login activity from all three of them?

2. One observation I have through one of our recent collection, the number of users in LMA_ENVIRONMENT_USER table are one less than the actual active users in the environment. Anyone seen this type of issue? the user missing is active appian user since 2022, but i dont see any login done by the user.

RE: Appian Usage Insights

poojabodkhe — Wed, 29 Mar 2023 10:16:52 GMT

Hi team,

We are trying to install this app on Appian 22.4 with MSSQL database. We were able to install collection app, also we have setup the database for Reporting app. But while importing the Reporting app, we are getting below error:

processModel 0002e3e2-7e00-8000-5369-544d98544d98 "LMA Process Data Package": An error occurred while creating processModel [uuid=0002e3e2-7e00-8000-5369-544d98544d98]: com.appiancorp.process.validation.ValidationException: Process Model is not valid. Invalid Activity Class Schema ID (APNX-1-4071-007)

We have tried this with Excel Tools 2.5.0 version. During inspection, it does not show any error but after importing it gives error.

RE: Appian Usage Insights

jraaquino — Fri, 30 Sep 2022 10:30:37 GMT

Hi David,

Thank you for building this app/plugin.

We're using your smart service Collect Audited Logins to retrieve last login timestamp information for our Access Management app in Appian.

However, our Appian environments are quite heavy in terms of API calls - we're receiving thousands per day. Due to this, the generated CSV file often reaches >100MB just because of the recorded login attempts of Service Accounts.

We only intend to retrieve logins of actual business users which can be done by excluding service accounts in the collected logins.

We've created a forked version of your plugin to do this:

1. Added smart service parameter for the excluded groups (e.g., Service Accounts group as input)

2. Added getExcludeUserList which fetches the members of the excluded groups provided

3. Updated CollectAuditedLogins.processLogins function to filter entries by username

I've attached the modified Java class for reference.

Do you think it's possible to (officially) include said changes to your plugin?

Thanks!

[View:/cfs-file/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-59c9bed7-be42-46d6-9300-fce649244c31/CollectAuditedLogins.txt:320:240]