Assets Reports: Report for unreferenced Asset Items

Hi @lutzu ,
I have a similar task at hand.
I create a file report, and add the property jcr:content/usages/dam:score to my report.
This now gets me some some information if an asset is in use by InDesign files. 

To get deeper, i think you might have to move foreward with a developer.
I will investigate today a bit more about the topic and keep you updated via PM if you want.
There are some services that look promising - ReferenceSearch for example.

Hi @lutzu may i ask you something regarding your description?
You wrote that you have to manually check each asset individually.
How do you do that? - Go to properties and see the dependencies?
What other methods do you use to check? 
Do you use the asset search rail?

I am thinking about creating some search filters in the admin asset search rail for my librarians that meet your description, and then create a smart collection that is checking all of those boxes.
Is ./jcr:content/metadata/dam:score value set on 0
Is ./jcr:content/dam:portalReplicationAction value "deactivate" or empty
Is ./jcr:content/cq:lastReplicationAction value "deactivate" or empty
In addition - i created a tag for my librarians, that they can use to mark an asset to be investigated.
They than can use the report function to create a excel sheet, use excel functions to filter assets, alter the tag apropriatly and use this report as a csv import.
They then can use the other tag to search the system for every asset that is marked for deletion / archivation.
Not quite a OOTB solution, but it does not need any developer to get there.

@adilos-cantuerk Hi, well, currently the editor's only chance is to select the asset and check in left rail "References" the "Site References". But as said this is not applicable.

The search rail you mentioned has so many ootb filter but the information about if an asset is in use is not in! Do not understand why actually...

Hi @lutzu , i am pretty sure that your need can be done without Adobe having to implement this to be an OOTB feature for every user. So, in other words, good news - i think you can get what you need without having to wait for Adobe to approve this idea and upgrade the system 😄
I gave it a thumbs up, since i also see the usefulness and i believe that your idea will be an improvement for many.

The search rail is just one way to get there.

You can also think of some other trickery that is a bit more complicated but when you are already on that train, you would be able to tailor it to your exact needs. 

And here i come to your last sentence in your comment.
From what i have experienced with this system is, that the options and opportunities are a lot.
Like... really a lot. The documentation is fantastic, yet a bit overwhelming. Since the options are so many, the OOTB options are very generic.

Often times i had your exact words in my mouth.

Why is this very useful information not already OOTB available?
For example, one of my grudges:
Why does the Expiry filter only shows "Expired"? I would like to know more!
Show me all the assets that have no expiration Date.
Show me all the assets that will expire within the year!

I did what you are doing now! Come to the forum, ask people how and why... and why not.
Learn how to get what you need out of the system instantly with our feedback and (i love that we are in your idea section when i write this) share your ideas. That is brilliant! Our feedback will/can improve the system for everybody. Good stuff! Keep going!

You will be able to create almost everything that fits your needs BUT in order to do so, you need to have to understand how the system works a bit better. Just keep asking questions 😄 

@lutzu 

Hi @lutzu @adilos-cantuerk this is now available for early access - if you want to provide your IMS Org ID to us we can enable the Feature Toggle for your org. We'd like to get feedback before making this GA. Thanks!

Hi @alext-  Is this feature live? I am looking for same information!!

@rohitgu10 We managed it to get the feature flag enable on our STAGE system and could see an additional column to be selected in the report "Publish". But unfortunately it did not work at all - corresponding column showed always "No references found". We are still in contact with Adobe regarding this ...

Always wanted to see this feature in Assets. We always end up using custom code to create such reports. 

Based on Comments form Alex, we are marking this as delivered.