SQL for portlet usage (113 Views)
Reply
Frequent Advisor
B Swanson
Posts: 40
Registered: ‎02-27-2008
Message 1 of 5 (113 Views)
Accepted Solution

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!
Please use plain text.
Trusted Contributor
Tim Brandish
Posts: 58
Registered: ‎12-07-2007
Message 2 of 5 (113 Views)

Re: SQL for portlet usage

what version are you using?
Please use plain text.
Frequent Advisor
B Swanson
Posts: 40
Registered: ‎02-27-2008
Message 3 of 5 (113 Views)

Re: SQL for portlet usage

I'll need the solution for version 7.1 SP5.
Thanks!
Please use plain text.
Trusted Contributor
Tim Brandish
Posts: 58
Registered: ‎12-07-2007
Message 4 of 5 (113 Views)

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
Please use plain text.
Frequent Advisor
B Swanson
Posts: 40
Registered: ‎02-27-2008
Message 5 of 5 (113 Views)

Re: SQL for portlet usage

Thanks so much!
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation