- Go to /crx/de/index.jsp
- Login as admin
- Go to
Tools
=>Query
- Select
SQL2
- In the
Query
box, paste one of the queries below: Find assets missing thejcr:content/metadata
node:
select * from [dam:Asset] as s where s.[jcr:content/metadata/jcr:primaryType] is null and ISDESCENDANTNODE(s,'/content/dam')
Find pages missing the jcr:content
node:
select * from [cq:Page] as s where s.[jcr:content/jcr:primaryType] is null and ISDESCENDANTNODE(s,'/content')
- Click
Execute