Search and tag null metadata fields

[dmescia2]

It would be amazing if we could search in the DAM based on null fields. Also, if we could bulk tag assets with nothing if we have to bulk remove a tag. Does this functionality exist?

[Saravanan_Dharmaraj]

if you know the property you could search for asset which doesnt have that property like below

type=nt:unstructured
path=/content/dam/<path>
property=jcr:content/metadata/propertyName
property.operation=not
p.hits=full
p.limit=-1

 You can set the property to null will remove the property for a resource.

[diksha_mishra]

@dmescia2 

You might need to customize her as bulk removal isn't available OOTB. Here are some options:

1. Create groovy script - here you can find an example that in general will do what you need - you will of course have to adjust properties/metadata you would like to remove - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-asset-metadata-delete/...
2. You will be able to get similar results using on deploy scripts - https://adobe-consulting-services.github.io/acs-aem-commons/features/on-deploy-scripts/index.html
3. Interesting option is also a small extension for ACS Commons Manage Control Process - here is detailed description what should be done to use it for bulk deletion of properties/metadata - https://kiransg.com/2021/12/10/bulk-add-update-and-delete-properties-in-aem-without-using-groovy-con...

Hope this helps. 

[Adilos-Cantuerk · Accepted solution]

You have already working options here from the others.
I use the metadata CSV export import and some excel powerquery to clean the system in such cases.
This provides me with a good before and after report, as well the option to go back with an import of the originaly exported CSV file if something went wrong with my import.