Project and Portfolio Management Practitioners Forum
cancel

Information on Report generation

Highlighted
NaveenKumarV183
Regular Contributor.

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.

4 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

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)
NaveenKumarV183
Regular Contributor.

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.

Utkarsh_Mishra
Acclaimed Contributor.

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)
NaveenKumarV183
Regular Contributor.

Re: Information on Report generation

Hi,

 

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

 

 

 

 

Regards,

Naveen Kumar.