Service Desk Practitioners Forum
cancel

command for user last date of password change?

Highlighted
anu_6
New Member.

command for user last date of password change?

command for user last date of password change?
3 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: command for user last date of password change?

Hello,

Just execute the query bellow:

select ACC_PASSWORD_MODIFICATION_DATE from rep_accounts where acc_loginname=''

where 'loginname' is the loginname you want to examine.
menes fhtagn
Venkatesha_1
Outstanding Contributor.

Re: command for user last date of password change?

Hi,

Goto Tools >> System >> Security >> Access > Application Account
You will see all the Applicaton Account created for the system.

Click on the Filter and in the "available fields" select "Password modification date" field for display.

This will give you the password modification date for each users in your system.
In this case you don't need to go into the DB.


Regards
Venkatesha
Hanspeter Loche
Super Contributor.

Re: command for user last date of password change?

Hi,

Unfortunately, the solution from Venkatesha works for 4.5 only. In 5.10 it's (currently) not possible to personalize the application account view.

In 5.10, on the other hand, you see the password modification date for an individual account directly on the account form.

Cheers
Hanspeter