Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

command for user last date of password change?

Highlighted
anu_6
Acclaimed Contributor

command for user last date of password change?

command for user last date of password change?
3 REPLIES
George M. Meneg
Honored 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
Esteemed 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
Regular Collector

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
//Add this to "OnDomLoad" event