List albums that are missing art

Posted:
Sat Dec 08, 2018 3:26 am
by edimusrex
I was wondering if it is possible to sort all albums that are missing art work. This would be a useful feature if there was a way to accomplish this. I have a VERY large library and trying to go through it all to fill in what's missing is grueling.
Re: List albums that are missing art

Posted:
Thu Dec 27, 2018 8:04 pm
by ArtW
If you have access to your library from a windows computer you can use a small powershell script that I wrote for that exact purpose. It lists all folders at a given location that have files of one type (flac or mp3 for example) but are also missing another file, in my case: Folder.jpg
It's not a perfect "out of the box" solution but it is better than hunting for those folders with missing images. I'm not at home at the moment, I'll post the script later.
Re: List albums that are missing art

Posted:
Wed Jul 03, 2019 5:31 pm
by wendigo
How to list albums without album art:
1. Open http(s)://yourserver.subsonic.org/db.view
2. Run this query:
- Code: Select all
select * from ALBUM where COVER_ART_PATH is null and PRESENT=1