Query to get count of pages on which an image is used | Community
Skip to main content
New Participant
May 1, 2018
Solved

Query to get count of pages on which an image is used

  • May 1, 2018
  • 4 replies
  • 3319 views

Hi

I have a requirement where i need to run a query to get the count and page details on which a particular DAM image is used.

I have tried below querybuilder query but dont get all results

path=/content/test

1_property=jcr:primaryType

1_property.value=nt:unstructured

2_property=image

2_property.value=/content/dam/test/assets/home.jpg

p.limit=-1

p.properties=jcr:path

Any help will be really appreciated.

Thanks

Hina

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

See this thread for a related discussion - fetch image using JCR or Query Builder

4 replies

Hina29Author
New Participant
May 3, 2018

Thank you

Hina29Author
New Participant
May 3, 2018

Thank you its very helpful !

viveksachdeva
New Participant
May 2, 2018

The query you used looks only in property called image.. "References" in DAM does exactly what you are looking to do http://localhost:4502/bin/wcm/references?_dc=1525242342217&_charset_=utf-8&path=%2Fcontent%2Fdam%2Fgeometrixx-outdoors%2… and gets all references.. Does this help?

New Participant
January 30, 2023

Hey @viveksachdeva  Could please add more info on that URL, How do I get a report of all the images being used across website.

viveksachdeva
New Participant
January 31, 2023

Here is an article which talks about same requirement. Could possibly give this a shot. https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/find-unused-assets-in-aem/m-p/174281

smacdonald2008
smacdonald2008Accepted solution
New Participant
May 1, 2018

See this thread for a related discussion - fetch image using JCR or Query Builder