Community in read only mode June 18 & 19
This community will be set in READ ONLY mode for a while on Tuesday June 18 into Wednesday June 19 while we import content and users from our Micro Focus Forums community site. MORE INFORMATION
MandyR Absent Member.
Absent Member.
1162 views

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

Tags (1)
0 Likes
2 Replies
Established Member.. Utkarsh_Mishra
Established Member..

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)
0 Likes
Super Contributor.. patrick-sa Super Contributor..
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 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.