Project and Portfolio Management Practitioners Forum
cancel

Last Login details in HP PPM

Highlighted
MandyR
Trusted Contributor.

Last Login details in HP PPM

Hi,

 

 

I need list of users who did not logged in the HP PPM last 6 months. I am writing a query on this but not able to find the field name and table which can give me last login details.

 

Could anyone please help me on this. Any help in this regard would be much appreciated.

 

 

Thanks,

Mandy

2 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: Last Login details in HP PPM

SELECT * FROM KNTA_USERS_V WHERE

LAST_LOGON_DATE < SYSDATE-180

AND

ENABLED_FLAG ='Y'

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
patrick-sa
Super Contributor.

Re: Last Login details in HP PPM

You could also use this one.

 

SELECT max(la.creation_date) LAST_LOGIN,
round(sysdate - max(la.creation_date)) DAYS_FROM_LOGIN,
--p.product_name LICENSE_NAME, (u.first_name || '' || u.last_name) FULL_NAME,
u.username USERNAME,u.email_address,
u.user_id USER_ID,
u.creation_date CREATION_DATE
FROM KNTA_USERS u, KNTA_LOGON_ATTEMPTS la,
knta_products p, knta_user_products up
WHERE up.user_id=u.user_id
AND ((u.end_date is NULL) OR (u.end_date > sysdate))
and p.product_id = up.product_id
AND u.USER_ID = la.USER_ID (+)
GROUP BY u.username, u.email_address, u.user_id, u.creation_date
order by days_from_login desc