I have a requirement where I need to get the file names or count of files that are uploaded under each account in Salesforce. I understood that the notes and attachments can be queried from content version object but there isn't any field that displays the account name or id.
I also understood that from file detail view, we can see the account name which the file was shared with but it cannot be queried.
Is there any way that we can get the account id or account name from files or content version object. Please suggest.