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

**URL:** <https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418>\
**Category:** General Discussions\
**Created:** [June 3, 2017, 11:03pm UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418 "2017-06-03T23:03:45Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![hassetbj](https://avatars.discourse-cdn.com/v4/letter/h/65b543/32.png) [@hassetbj](https://forums.plex.tv/u/hassetbj)\
**Post date:** [June 3, 2017, 11:03pm UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/1 "2017-06-03T23:03:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [June 4, 2017, 12:45am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/2 "2017-06-04T00:45:49Z")

</div>

- install [ExportTools](https://forums.plex.tv/discussion/254248/rel-exporttools/p1#top "ExportToolsPlex2CSV")
- 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 `2`s ) in this column yet - these are the items which are yet to be analysed

---

<div class="post-metadata">

**Author:** ![hassetbj](https://avatars.discourse-cdn.com/v4/letter/h/65b543/32.png) [@hassetbj](https://forums.plex.tv/u/hassetbj)\
**Post date:** [June 4, 2017, 4:14am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/3 "2017-06-04T04:14:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![hthighway](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/hthighway/32/82003_2.png) [@hthighway](https://forums.plex.tv/u/hthighway)\
**Post date:** [June 4, 2017, 4:34am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/4 "2017-06-04T04:34:39Z")

</div>

Take a look at this script:

> <https://github.com/ajkis/scripts/blob/master/plex/plex-library-stats.sh>

---

<div class="post-metadata">

**Author:** ![hassetbj](https://avatars.discourse-cdn.com/v4/letter/h/65b543/32.png) [@hassetbj](https://forums.plex.tv/u/hassetbj)\
**Post date:** [June 4, 2017, 6:46am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/5 "2017-06-04T06:46:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\
**Post date:** [June 4, 2017, 1:15pm UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/6 "2017-06-04T13:15:28Z")

</div>

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](https://support.plex.tv/hc/en-us/sections/205949648-Plex-Cloud "Plex Cloud")’ is being made specifically to deal with the particularities of cloud storage. Especially to avoid the ‘rate limiting’ of cloud providers.

---

<div class="post-metadata">

**Author:** ![hthighway](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/hthighway/32/82003_2.png) [@hthighway](https://forums.plex.tv/u/hthighway)\
**Post date:** [June 5, 2017, 4:53am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/7 "2017-06-05T04:53:55Z")

</div>

> @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

---

<div class="post-metadata">

**Author:** ![hassetbj](https://avatars.discourse-cdn.com/v4/letter/h/65b543/32.png) [@hassetbj](https://forums.plex.tv/u/hassetbj)\
**Post date:** [June 6, 2017, 4:55am UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/8 "2017-06-06T04:55:57Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [January 7, 2020, 11:22pm UTC](https://forums.plex.tv/t/how-does-plex-identify-if-a-file-has-been-deeply-analyzed/194418/9 "2020-01-07T23:22:10Z")

</div>


