Query to generate history of password changed date

[Former Member]

Hi all,

Is it possible to generate the history of password changed date for a user.

For example, user A changed password on 2013 Sep 2 and 2014 March 5.

On today when I run the query report, it will display both the changed date for user A in the report

Below is the current query that will only displayed the last password changed date for active user.

SELECT T0.[U_NAME], T0.[LastPwdSet] FROM OUSR T0 WHERE T0.[LOCKED] = 'N'

Thanks

[kothandaraman_nagarajan · Accepted solution]

Hi,

Have you got required query?

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi,

Right now I run AUSR and OUSR in two separate query. Last changed date will not appear in AUSR.

Thanks

[javier_facessantos · Accepted solution]

Hello Olga

That's right, last changed date will get only stored in OUSR together with its actual value.

Regards

[Former Member · Accepted solution]

Hi,

There is a way to combine them. Show your 2 queries.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

First:

SELECT T0.[U_NAME], T0.[LastPwdSet] FROM AUSR T0 WHERE T0.[U_NAME] = 'manager'

Second:

SELECT T0.[U_NAME], T0.[LastPwdSet] FROM OUSR T0 WHERE T0.[U_NAME] = 'manager'

Thanks

[Former Member · Accepted solution]

Try:

SELECT Distinct 'History' 'Type', T0.[U_NAME], T0.[LastPwdSet] FROM AUSR T0 WHERE T0.[U_NAME] = 'manager'

UNION ALL

SELECT 'Current' 'Type', T0.[U_NAME], T0.[LastPwdSet] FROM OUSR T0 WHERE T0.[U_NAME] = 'manager'

[javier_facessantos]

Hello Olga

Check on AUSR table. That is history table for OUSR, you may be able to find it there.

Regards