Is there a way to query the Appian user database and discover those users whose passwords are expired (rather than account deactivated.
I've looked at the user() function and none of the arguments help..
Discussion posts and replies are publicly visible
You're asking a very specific question...but to what end? What problem are you actually trying to solve? We may have a better insight as to what you might need...
Pretty simple really.. i need to produce a list of users whose password has expired, and by definition are no longer using the system.
...and the purpose behind this is...to deactivate the accounts and recycle the licenses? (just trying to get to the outcome you're attempting to achieve)
...just in case your use case is this simple you can deactivate users who haven't logged in recently via the Admin Console:
Hi Stewart,Unfortunalty not. We will need to approach the users first to determine the next course of action. given that there is no way to track when the last activity was performed by the user - we are using the logic of if there password has expired - then they wont be using the system and we can approach them to discuss the next course of action. It is possible that they still not sporadic access.
There's a log file in Appian named user_management.csv under the audit folder. It tracks the last password changed date-time of the users. It might be helpful for your case if we read the log correctly and tweak it.
© 2022 Appian. All rights reserved.