Skip to main content
October 8, 2025
Question

How to check inactive user list in the on-premise envionment

  • October 8, 2025
  • 5 replies
  • 0 views

Hi,

could you please suggest me better approach like how can get inactive user list in the environment and last login inactive user ?

I have seen, we can get to know in admin console but if we want check without admin console like any functions to check?

thanks

    5 replies

    shubhama926776
    October 8, 2025

    You can make use of default user record to get deactivated users.

    a!queryRecordType(
      recordtype:'recordType!{SYSTEM_RECORD_TYPE_USER}User',
      fields:{ 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active'},
      filters: a!queryFilter(
        field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active',
        operator: "=",
        value: false
      ),
      pagingInfo: a!pagingInfo(1,5000)
    ).data
    




    or

    Install Personalization Utilities
    Use below function to get deactivated users.
    getdeactivatedusersby(
      "username",
      null,
      2
    )


    October 8, 2025

    Thanks shubam,

    is there any possibility to check the last login time?

    shubhama926776
    October 8, 2025

    You can use the getLastLoginDateTime() function, but it only works on system logs. Appian doesn't maintain login logs beyond 30 days. I recommend moving this information to a table via a nightly job, which will allow you to have continuous, up-to-date data. However, this requires custom development.