anybody has a sql command to get number of password resets ?

[sharas]

Hi,

Does anybody have a sql query that can get the user records whose passwords have been reset by a particular user id ?

I am wondering which table to hit to get this info..

Thanks in advance,
Sharas.

[nbarr007]

I use the following command on the emprd database

select username, userfullname, passexpiredate from generalauthorizations
order by passexpiredate

I use this query to see when a user last reset his/her password.

Running controlM 6.4

rgd's

Norman