How does Plex identify if a file has been "Deeply Analyzed"

General Discussions
1

What field or set of conditions in the Plex database indicates if an item has been deeply analyzed or not? I’m referring to the process that occurs during the Scheduled Tasks for " Perform extensive media analysis during maintenance". I’m interested to see how many additional files i have that need to go through this process.

2
  • install ExportTools
  • export your video library(s) with the detail level 666
  • import the exported CSV file in a spreadsheet calc app
  • sort the table after the Part Deep Analysis Version column
  • count the rows which don’t have a 2 (or several 2s ) in this column yet - these are the items which are yet to be analysed
3

i’m having some trouble with Exporttools timing out when running it’s process, possibly because my media is stored in the cloud. Any ideas which database field the “Part Deep Analysis Version” is looking at when generating the export from Exporttools? I can then take that and query directly with SQL against the media objects.

4

Take a look at this script:

5

That’s perfect! It looks like the entry is in the extra_data column for the media_parts table. The specific entry is a component of the entire field and is deepAnalysisVersion. deepAnalysisVersion=2 appears to show a file that has been deeply analyzed and anything besides 2 has not been deeply analyzed.

6

Don’t use cloud storage with the ‘desktop’ version of Plex server. It just doesn’t make sense. And ‘deep analysis’ is only one of the pitfalls with cloud storage.

‘Plex Cloud’ is being made specifically to deal with the particularities of cloud storage. Especially to avoid the ‘rate limiting’ of cloud providers.

7

@OttoKerner said:
Don’t use cloud storage with the ‘desktop’ version of Plex server. It just doesn’t make sense.

I disagree with that statement, cloud storage hooked to a regular PMS works excellent when configured correctly

8

I have to agree with hthighway. I haven’t had any problems when i have it setup correctly. I just recently had it set expecting a 1gbps bandwidth when i was in fact getting closer to 50mbps, thus the troubles i was working through.