Export rename history

Help & Support
1

I have imported 5 season of a TV show that is messed up (wiki / imdb / tvdb / scene disagree) blindly hoping that XEM would fixe everything but turns out i had the wiki ordering so it did not work.

Is there a way to find the full rename history ? i could parse and filter with excel and vba but from the log on windows I can only find the source episode number, not the full original name. If it’s too complex, I’ll probably just redownload

2

Should be there if trace logging is enabled.

3

I have the minimum logging :frowning: . Is there a way (easy) to access the “activity db”, I can see the original filename in the activity tab of each episode

4

Thats from the history table, this query will get the item from history, link the episode and the file and give you the source name from history and the current filename on disk, just replace SERIES_NAME_HERE with the series name

SELECT History.SourceTitle, EpisodeFiles.Path from History
INNER JOIN Series
ON Series.Id = History.SeriesId
INNER JOIN Episodes
ON Episodes.Id = History.EpisodeId
INNER JOIN EpisodeFiles
ON EpisodeFiles.Id = Episodes.EpisodeFileId
WHERE History.EventType = 3
AND Series.Title LIKE '%SERIES_NAME_HERE%'

Just open up nzbdrone.db in any program that can access a sqlite3 db.

5

great thanks