Is there a way to set monitoring for aired episodes?

Help & Support
1

Hi,
i am trying to move from sb to sonarr. When I add an existing show all its eps have the status monitored. Since I move watched eps to my archive sonarr would try to download all wached eps again.
Is there any way to set all eps that have already aired to unmonitored? This way only newly aired eps would be downloaded.
since I have more than 300 shows setting all eps manually seems like an endless task.
Thx for any help!

2

At the moment Season Pass is the easiest, but far from perfect. We’ll be working on improving this (as well as the options when adding a series to Sonarr).

3

set ignore deleted files to true?

4

Only applies when Sonarr saw the file on disk.

5

Is there some way to issue the SQL statement myself? Like update episodes set monitorstatus = unmonitored where airdate < today?

6

Not within the UI. But you could open up the DB in a sqlite editor and run an update on the Episodes table and the AirDateUtc column.

7

Works perfectly. Ty markus!

For those trying to achieve the same here is what i did on a synology:

  1. start /volume1/@appstore/nzbdrone/bin/sqlite3
  2. open the db file: .open /volume1/@appstore/nzbdrone/var/.config/NzbDrone/nzbdrone.db
  3. change the monitored status by issuing an update statement:
    update episodes set monitored = 0 where airdate < DATE('now');

This will set all episodes with an airdate older than now to unmonitored.

8

Awesome, we’re hoping to get this into the UI as well, we’ve made some changes that will facilitate this recently as well.