Possible to generate list of content fragments that have variations without editing or opening them?

[brianlplfinancial]

Trying to avoid having to verify one at a time which content fragments currently have variations within them. I have tried performing various queries but no luck. Any ideas? 

[lukasz-m · Accepted solution]

Hi @brianlplfinancial, you can try to run below SQL2 query

SELECT * FROM [dam:Asset] AS cf WHERE ISDESCENDANTNODE([/content/dam]) AND cf.[jcr:content/contentFragment] = true AND cf.[jcr:content/model/variations/jcr:primaryType] IS NOT NULL

[brianlplfinancial]

Brilliant! Thank you @lukasz-m