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

Last Login details in HP PPM

Highlighted
MandyR
Super Collector

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
Honored 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
Regular Collector

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 

//Add this to "OnDomLoad" event