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

Question

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

Shubham Aware · Answer

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
)

Shubham Aware · Answer

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.