Jack Burton 94 Posted September 12, 2023 Share Posted September 12, 2023 I just lost a drive, and of course have no backup haha. Obviously the server has the missing items blank, but rather than physically going through each show and movie that's missing, is there a way to get a log that shows the media that's missing? Link to comment Share on other sites More sharing options...
Luke 37145 Posted September 12, 2023 Share Posted September 12, 2023 HI, did you already run a scan to cause them to get removed? If you still have the server log from when that happened then you could look for the "removing item" entries in the server log. Link to comment Share on other sites More sharing options...
Jack Burton 94 Posted September 12, 2023 Author Share Posted September 12, 2023 43 minutes ago, Luke said: HI, did you already run a scan to cause them to get removed? If you still have the server log from when that happened then you could look for the "removing item" entries in the server log. I have not, I've been keeping it to track for now. So if I remove the library, the new server log after that should have a removed items entry? Link to comment Share on other sites More sharing options...
Luke 37145 Posted September 13, 2023 Share Posted September 13, 2023 23 hours ago, Jack Burton said: I have not, I've been keeping it to track for now. So if I remove the library, the new server log after that should have a removed items entry? Yes it should, although actually, sorry. I'm not sure it will list out everything. It will list the highest folder that it finds that is gone, but then it does a bulk removal of everything underneath, so those won't get listed. If you by any chance use the emby backup plugin and have database backups, you could get data from those. Link to comment Share on other sites More sharing options...
Jack Burton 94 Posted September 13, 2023 Author Share Posted September 13, 2023 14 minutes ago, Luke said: Yes it should, although actually, sorry. I'm not sure it will list out everything. It will list the highest folder that it finds that is gone, but then it does a bulk removal of everything underneath, so those won't get listed. If you by any chance use the emby backup plugin and have database backups, you could get data from those. I have the Backup and Restore plugin, is that it? It has the backups for the last 5 days, what am I looking for? Link to comment Share on other sites More sharing options...
Solution Luke 37145 Posted September 13, 2023 Solution Share Posted September 13, 2023 8 minutes ago, Jack Burton said: I have the Backup and Restore plugin, is that it? It has the backups for the last 5 days, what am I looking for? You're going to have to be handy with databases. You'll need to use a sqlite viewer to open up library.db. Then you can get all movies for example using: select * from mediaitems where type=5 or all episodes using: select * from mediaitems where type=8 1 Link to comment Share on other sites More sharing options...
Jack Burton 94 Posted September 13, 2023 Author Share Posted September 13, 2023 18 minutes ago, Luke said: You're going to have to be handy with databases. You'll need to use a sqlite viewer to open up library.db. Then you can get all movies for example using: select * from mediaitems where type=5 or all episodes using: select * from mediaitems where type=8 Haha, ok wow. Might be easier to just got through manually for me haha. I'll give it a look though, thanks for your help. Just one of the reasons Emby is better than the rest! 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now