How to get external gadget names in confluence

[Bhargavi Vasa]

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

[Tomasz Kowalczyk]

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

[Bhargavi Vasa]

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