Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SQL for portlet usage

SOLVED
Go to Solution
Frequent Advisor

SQL for portlet usage

Has anyone developed SQL to determine what portlets / pages are being used by the users in the system?

I know you can get the info for admin-controlled pages, but I wasn't sure how to determine usage of non-admin controlled pages.

Thanks!
4 REPLIES
Trusted Contributor [Founder]

Re: SQL for portlet usage

what version are you using?
Frequent Advisor

Re: SQL for portlet usage

I'll need the solution for version 7.1 SP5.
Thanks!
Trusted Contributor [Founder]

Re: SQL for portlet usage

This includes portlets that the user has added on their own as well as portlets that are added via module

--pages added via module
select u.full_name as Full_Name, p.PORTLET_ID as Portlet_ID, p.TITLE as Title
from dsh_user_module_pages ump,
dsh_portlets p,
knta_users u
where ump.PAGE_ID = p.PAGE_ID
and ump.user_id = u.user_id
union all
--pages created by user
select u.full_name as Full_Name, p.PORTLET_ID as Portlet_ID, p.TITLE as Title
from dsh_user_pages up,
dsh_portlets p,
knta_users u
where p.PAGE_ID = up.PAGE_ID
and up.user_id = u.user_id
order by Full_Name, Title
Frequent Advisor

Re: SQL for portlet usage

Thanks so much!