Skip to main content
Inspiring
Oct 8, 2025 9:50 AM UTC
Question

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

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
    Brainy
    Oct 8, 2025 11:18 AM UTC

    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
    )


    शुभम्
    Inspiring
    Oct 8, 2025 11:31 AM UTC

    Thanks shubam,

    is there any possibility to check the last login time?

    shubhama926776
    Brainy
    Oct 8, 2025 11:37 AM UTC

    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.

    शुभम्