Google's File Report comes in .csv format, and contains information that you will find useful, along with other information that you will not need.
This is a guide to understanding the report and getting the information you need out of the report.
There are three distinct sets of files that you may find interesting - details on each are below.
IMPORTANT: If you copied or downloaded any of the files listed in this report, but did not delete the original, then you will still see the original files in this list. Please do not confuse these original files with the ones you know you've copied or downloaded.
The files in My Drive reflect everything in your My Drive that is owned by your account.
In cases where you had created folders in your My Drive and shared them out to others, and those others saved files into your My Drive folders, you will also see the names of these files and which Google account owns them.
When the physics.ucsd.edu Google account is deleted, all files owned by that account are deleted. Any files in the My Drive that are owned by someone else will be returned to that owners's Google account (if that owner is a physics.ucsd.edu account, then those files would be deleted when that account is deleted).
What are Orphans?
At one point in time, you saved a file into someone else's shared folder.
Then, they deleted that folder, and your file became orphaned.
These files are still owned by your physics.ucsd.edu account, and since the "someone else" does not have permission to delete files you own, they were returned to your physics.ucsd.edu account, unfiled.
The file list in Shared With Me is valuable in the sense that you now have a list of anything that was shared with your @physics account, and the original owner, so you know who to contact if you need the file later.
Any files in the Shared With Me section that are owned by @physics.ucsd.edu accounts will be deleted when their account is fully deleted.
These are files that your physics.ucsd.edu Google account owns, and you put them in someone else's Shared Folder (in their My Drive, NOT in a Shared Drive).
Google Sheets does not work well with large .csv files. In this case, you will DOWNLOAD the .csv report, and then open it in Excel.
When you request a file list report, a file will be shared with you to your @ucsd.edu email address. You should receive a link to the file at your @ucsd.edu email address informing you that a file has been shared with you. The file has various columns and the definitions of the more important columns are as follows:
LocationCategory column: the first column will indicate where the files are located:
MyDrive
Orphans
Shared With Me
Owned By Me in Shared With Me
name column: provides you with the name of the file
owners.0.emailAddress column: shows the file owner's email address
path.0 column: provides you with the path of the file. This path is where you can find the file in your Google Drive for the @physics.ucsd.edu domain account
size (bytes) column: size of the file in bytes