How to locate orphaned assets?

(Niraj Sachania) #1
Looking to archive files and images which are no longer in use.
 
How can I check usage without going through the Linking screen of each asset individually?
 
Lineage keyword in an asset listing is of no use in this instance as media is served directly via apache (__data).
(Nic Hubbard) #2

I built something like this for a client. You can build an asset listing and then use a second nested one with list_current_asset_id. Then, that second asset listing can list all links, even NOTICE links for those child assets. Then we used a bit of javascript so that you could hover over an asset to see the links.

(Benjamin Pearson) #3

If you have access to the server or have someone to access the server there is a couple of scripts (this one and this one) which can report back the assetids of orphaned assets. Otherwise you can use the database (data source db) and look for assets (with an ID greater than 1) that do not exist on the link table.

(Niraj Sachania) #4

Thanks Nic, that works.

 

Thanks Ben, good to be aware of those tools. I shall discuss with my colleagues who work on server side.

(Niraj Sachania) #5

For images within Page Contents, a NOTICE link appears: .. > Page Contents > Content DIV ASSET-ID

 

For images placed in WYSIWYG Metadata field, there's no NOTICE link on the Linking screen of the image. Is there a way to track the linking of these?

 

Squiz Matrix v4.16.2

(Barb Kempnich) #6

Hi Nic,

 

Are you able to provide a little more detail about how to construct those two asset listings? We have a large number of documents stored in folders and would like to be able to identify any that have no NOTICE links as we know many of them aren't being used. 

 

I've seen your post here http://forums.squizsuite.net/index.php?showtopic=12433&hl=%2Bdisplay+%2Blinked+%2Bparents+%2Basset#entry53961 butthat doesn't seem to be working for me. 

(Nic Hubbard) #7

Hi Nic,

 

Are you able to provide a little more detail about how to construct those two asset listings? We have a large number of documents stored in folders and would like to be able to identify any that have no NOTICE links as we know many of them aren't being used. 

 

I've seen your post here http://forums.squizsuite.net/index.php?showtopic=12433&hl=%2Bdisplay+%2Blinked+%2Bparents+%2Basset#entry53961 butthat doesn't seem to be working for me. 

 

You need to use the list_current_asset_id feature, check the manuals about that or the forums if you have not used it before. I also wrote a blog post about it a few years back:

 

http://www.zedsaid.com/blog/understanding-the-power-of-list_current_asset_id-in-squiz-matrix

 

Sorry, don't have a chance to write anything more detailed at the moment...

(Barb Kempnich) #8

Thanks - I'll give it a go.