it is all in the database
If using Windows you can do so with the command prompt.
https://support.plex.tv/articles/201242707-plex-media-scanner-via-command-line/
it would be something like (the path to the scanner .exe may be different on your computer)
"C:\Program Files (x86)\Plex\Plex Media Server\Plex Media Scanner.exe" --list to get the library ID’s
then
"C:\Program Files (x86)\Plex\Plex Media Server\Plex Media Scanner.exe" --list --section 4 ( where 4 is the library ID) to list all the content in that library
or you can user the ExportTools portion of WebTools to export a .csv file you can import in a spreadsheet app. which can have all sorts of info it gets from DB.
