Project and Portfolio Management Practitioners Forum
cancel

SQL for portlet usage

SOLVED
Go to solution
Highlighted
B Swanson
Regular Collector

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
Tim Brandish
Frequent Visitor

Re: SQL for portlet usage

what version are you using?
B Swanson
Regular Collector

Re: SQL for portlet usage

I'll need the solution for version 7.1 SP5.
Thanks!
Tim Brandish
Frequent Visitor
Solution

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
B Swanson
Regular Collector

Re: SQL for portlet usage

Thanks so much!
//Add this to "OnDomLoad" event