Server Version#:1.17.0 1841
I’m attempting to have some logging for my Plex library within an Excel file. Ideally, I’d like to build a data connection to whichever appropriate XML files that Plex generates.
In a perfect scenario, I’d be able to capture the data that we are able to see from the “Get Info” screen.
I have been fiddling around with the Plex Media Scanner console commands, however, that appears to be limited and more for a one-off generation of the data. It’s obvious this data is stored somewhere, I am an admin on the local computer where the server is installed so there are no limitations from that perspective.
Also, I know there is the “View XML” option when you are on the “Get Info” screen, so is there a folder structure where this is all stored? Even if it is broken into numerous XML files that would be OK.
Any suggestions?
P.s. I intend on using Microsoft Excel’s Get & Transform Data (aka Power Query) so I can dynamically compile one large XML file in the spreadsheet from numerous files and folders that part is easy, it’s just finding the data…