While uploading assets in aem as a cloud," dc: forma" t property is not getting created for certain type of assets (like .sketch, .oft. .ase, .plist). I have set the value of  "cq.dam.detect.asset.mime.from.content" to true in osgi configurations and it's pulling the file type on my local AEM as a ...

Thank you @lukasz-m 

@Sachin_Arora_ @SantoshSai Thank you. I have looked into the above mentioned url.This document explains the manual step of reprocessing the images. I am trying to add the watermark automatically as soon as an image is expired. How can I do it automatically?

I am writing a scheduler which runs a query to find the expired assets but it's not working. Is there an existing method/function to retrieve the expired assets?

I have created a custom workflow to add a watermark on the expired images using the existing process -Add Watermark but it's not working. Can someone explain in detail how to add watermark using workflow in aem as a cloud please?

Thank you @ShaileshBassi . This is helpful. Can you also help explaining how can I trigger an event/action as soon as an asset is expired. I am looking for adding a watermark as soon as the status changes to expired for an asset.

How can I create a report on assets with an expiration within 60 days and run it daily Monday to Friday. Report should include custom fields as well.

Thankyou @sunil_kumar_ . This is helpful .How can I find out expired assets. I want to add a watermark as soon as an asset is expired. Also is there a way to remove the watermark when the expiry date is changed to a future date for an asset?