The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Check for users that have been disabled?

Highlighted
b460
Regular Collector

Check for users that have been disabled?

Hi,

We have a couple of duplicate users in PPM and would like to filter by those which are enabled or disabled.

In the KNTA_USERS table there is no field that stores whether the user is enabled or disabled.

Does anyone know where this information is stored? I would like my SQL to check the database to see if the user is disabled.

Thanks.
2 REPLIES
Mahen M
Honored Contributor

Re: Check for users that have been disabled?

Hi,
If the user have end date less than SYSDATE then the user is disabled. If the End date is null or the end date is greater than sysdate then the user is enabled.
Thanks.

Regards,
Mahendran M
Sascha Mohr
Esteemed Contributor

Re: Check for users that have been disabled?

Or use the enabled_flag in the view knta_users_v
//Add this to "OnDomLoad" event