# XML data in database

**URL:** <https://forums.plex.tv/t/xml-data-in-database/794606>\
**Category:** Metadata & Adding Files\
**Tags:** server-windows\
**Created:** [May 28, 2022, 8:05am UTC](https://forums.plex.tv/t/xml-data-in-database/794606 "2022-05-28T08:05:05Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![meternich2](https://avatars.discourse-cdn.com/v4/letter/m/f1d935/32.png) [@meternich2](https://forums.plex.tv/u/meternich2)\
**Post date:** [May 28, 2022, 8:05am UTC](https://forums.plex.tv/t/xml-data-in-database/794606/1 "2022-05-28T08:05:05Z")

</div>

Hello. If I look in XML data of media, there is data about \<Part accessible=“1” exists=“1” .  
Is it possible to find this data in plex database? I can’t find the table which contains this data.

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [May 28, 2022, 11:48am UTC](https://forums.plex.tv/t/xml-data-in-database/794606/2 "2022-05-28T11:48:58Z")

</div>

AFAIK, those are calculated on the fly, when looking up a media, and having `checkFiles=1` as one of the parameters

But you can export a list, using 3rd. party tools like:

- [Exporter Guide · Tautulli/Tautulli Wiki · GitHub](https://github.com/Tautulli/Tautulli/wiki/Exporter-Guide)
- [Export · WebTools-NG/WebTools-NG Wiki · GitHub](https://github.com/WebTools-NG/WebTools-NG/wiki/Export)

---

<div class="post-metadata">

**Author:** ![meternich2](https://avatars.discourse-cdn.com/v4/letter/m/f1d935/32.png) [@meternich2](https://forums.plex.tv/u/meternich2)\
**Post date:** [May 28, 2022, 8:38pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/3 "2022-05-28T20:38:44Z")

</div>

Ok, thx. I already tried with export tools, but the job was very slow and I aborted it. I’ll try with tautulli, if it will be any quicker. Otherwise I’ll just have to wait, now that I know that this data cant be found in database.

---

<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:** [May 28, 2022, 8:46pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/4 "2022-05-28T20:46:46Z")

</div>

> [@meternich2](#):
>
> but the job was very slow

That’s normal. After all, it has to try and actually access the media file to make sure the results are correct.  
If you do it for one movie, you’ll probably not notice. But for a whole library worth of items, it can take a while.

---

<div class="post-metadata">

**Author:** ![Volts](https://avatars.discourse-cdn.com/v4/letter/v/a5b964/32.png) [@Volts](https://forums.plex.tv/u/Volts)\
**Post date:** [May 28, 2022, 9:28pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/5 "2022-05-28T21:28:35Z")

</div>

If you share what your end goal is & what you are trying to accomplish, there might be some other hints.

Building something?

Looking for Library entries with missing media?

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [May 28, 2022, 10:49pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/6 "2022-05-28T22:49:15Z")

</div>

> [@meternich2](#):
>
> I already tried with export tools, but the job was very slow and I aborted it

Export 2 items with level `all`

Then create a custom level with just the fields you need, and it’ll be a lot faster

---

<div class="post-metadata">

**Author:** ![meternich2](https://avatars.discourse-cdn.com/v4/letter/m/f1d935/32.png) [@meternich2](https://forums.plex.tv/u/meternich2)\
**Post date:** [May 29, 2022, 9:56pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/7 "2022-05-29T21:56:53Z")

</div>

Trying to find items with missing media.

---

<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:** [August 27, 2022, 9:57pm UTC](https://forums.plex.tv/t/xml-data-in-database/794606/8 "2022-08-27T21:57:47Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.