NaveenKumarV183 Absent Member.
Absent Member.
290 views

Information on Report generation

Hi,

 

Can any one help me how to run the report that shows everyone who has a Time Management license and the last time they logged into PPM?

 

 

 

Thanks,

Naveen Kumar.

0 Likes
4 Replies
Established Member.. Utkarsh_Mishra
Established Member..

Re: Information on Report generation

You can quickly create a list portlet using below SQL (modify it according to your need)

 

SELECT ku.username,
       ku.full_name,
       ku.enabled_flag,
       ku.last_logon_date ,
       kup.product_name
FROM knta_users_v ku
JOIN knta_user_products_v kup ON (ku.user_id=kup.user_id
                                  AND product_name LIKE 'Time Management') 
/*for enabled user check*/
AND ku.enabled_flag = 'Y'    

 

You can get the time managment users details using "User Detail Report" but it does not show the last login. So probably go with custom list portlet.

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
NaveenKumarV183 Absent Member.
Absent Member.

Re: Information on Report generation

Hi,

 

I got the data from backend. I want to know is there a way to get the data from front end.

 

 

 

 

Thanks,

Naveen Kumar.

0 Likes
Established Member.. Utkarsh_Mishra
Established Member..

Re: Information on Report generation

No, there is no way to get ALL ur required data from front end..

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
NaveenKumarV183 Absent Member.
Absent Member.

Re: Information on Report generation

Hi,

 

Thanks, for the information. I will let you know for any further issues.

 

 

 

 

Regards,

Naveen Kumar.

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.