Looking for active pages that contains deactivated assets/node

[akennan]

Hello All,

I am looking for a way to find all  the nodes/assets that are on a "cq page" , but  they are deactivated , is there a way to do that ?

Thank you in advance,

Aiman 

[Dinu_Arya]

If any page or asset is published, "cq:lastReplicationAction" property will be added to its jcr:content node and the value will be "Activate". You search by using this property.

[Sham_HC · Accepted solution]

When author try to deactivate the asset they will get a dialog the page that are referenced. So may be you do not have such page.  With single query I doubt it is possible but you can write a small script to get list of all deactivated asset & then go over that list to find if there is any reference.