Appian Usage Insights

Overview

Gain insights into your Appian usage with an application suite specifically designed to cater for complex environment topologies and heterogenous license contracts.

Key Features & Functionality

With ‘Appian Usage Insights’:

  • Model your license contracts in the application through configuration only - no additional development required!
  • Cater for Cloud, self-managed or a mix of installation topologies.
  • Designed with the enterprise in mind, support large numbers of Appian environments, user accounts and keep track of license consumption over time.
  • Model your internal license usage using license pools mapped to user-definable business entities.
  • Visualize usage the way you want to:
    • Usage by business entity.
    • Usage by license type.
    • License pool membership.
    • License pool logins.
    • License pool membership (which user is in which license pool and, ultimately, which one consumes an actual license).
    • Logins by user (over time).
    • Capacity planning (allocated license count over time).

For more information, see https://community.appian.com/w/the-appian-playbook/2198/appian-usage-insights-faqs

Usage of this application does not permit your organization to exceed its licensed usage requirements. Your organization is required to maintain compliance with your licensing terms, and report any non-compliance to Appian per the terms of your organization’s contract with Appian.

Anonymous
Parents
  • 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. 

Comment
  • 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. 

Children
No Data