AnsweredAssumed Answered

SQL listing users and the names of portlets they have accessed (and dates)

Question asked by sam_s on Oct 6, 2015
Latest reply on Oct 7, 2015 by Andrew_Lerner


Hi,

 

For Clarity version 12, looking for some SQL to pull a list from the database of the Clarity users, the names of the custom portlets that they have accessed over a given time period, and the dates they accessed the portlets.  Need this to determine what portlets we can omit during upgrade.

 

something similar to this:

 

 


 

Clarity User ID


 

 

Page/Portlet


 

 

Data Accessed / Used


 

 

12345


 

 

odf_***2


 

 

25-Sep-15


 

 

23456


 

 

odf_xx234


 

 

25-Sep-15


 

 

34567


 

 

odf_xx234


 

 

1-Oct-15


 

 

Anyone have any sample code for this to get me started?  Appreciate any help.

 

Thanks,

Sam

Outcomes