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
Data Accessed / Used
Anyone have any sample code for this to get me started? Appreciate any help.