Get report of external videos added on a sites

[Vani1012]

Hi 

I have a site 'XXX' I want to get a report of how many external videos are there for xxx.com site

For suppose I have created a page( /content/xxx/en-in/test-page) on this page I added an external video(youtube)

I used this query to get the list
path:/content/xxx
type:dam:Asset

property=metadata.videoSource 

property.value=YOUTUBE
also this query
path:/content/<XXX>//element(*, cq:Component)[@videosource-YOUTUBE]
orderby=path

I am not getting any result can anyone help me to fix this

[Saravanan_Dharmaraj · Accepted solution]

@Vani1012 , you can query by sling:resourceType and VideoSource property under path xxx. I am assuming the author add the youtube videos by card video component as shown in the picture above.

Query

path=/content/xxx

p.limit=-1

type=nt:unstructured

1_property=sling:resourceType

1_property.value=business/component/c.....

2_property=videoSource

2_property.value=YOUTUBE

orderby=path