How to get external gadget names in confluence

Question

I have confluence linked with jira , looking for gadgets which were part of jira and being linked to confluence as external gadgets

I need SQL to fetch gadget names

Ex: Activity Stream

Assigned to me

Bhargavi Vasa · Answer

I just need gadget url or name which were taking out from jira

I don't need where it is being used or in which page, just looking for the unique gadgets name

In my jira I have 18 gadgets, I just need those gadgets name from confluence using sql

Tomasz Kowalczyk · Answer

select 
cu.display_name as Display_Name_Owner,
pp.ID, 
pp.PAGENAME as Gadget_Name, 
* from portalpage pp
inner join portletconfiguration pc on pp.ID=pc.PORTALPAGE 
left join app_user au on au.user_key=pp.USERNAME
left join cwd_user cu on au.lower_user_name = cu.lower_user_name
where pc.GADGET_XML like '%activity%'

I think this might help you