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: 

Information on Report generation

Highlighted
NaveenKumarV183
Occasional Advisor

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
Honored 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
Occasional Advisor

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
Honored 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
Occasional Advisor

Re: Information on Report generation

Hi,

 

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

 

 

 

 

Regards,

Naveen Kumar.

//Add this to "OnDomLoad" event