Is the site you mentioned a website or a site collection?
All data of sites is stored on the related web application content database (its name is like WSS_Content_xxx), there is a table UserInfo stores descriptive properties and security information about principals with access to a site collection. In the table, tp_ID
is the User Identifier of the principal. Certain User Identifiers are predefined, such as the system account (1073741823), the site collection owner (1), and the secondary site collection contact (2).
So, you can use where tp_ID=1
to find the site collection owner's information, like the following query:
More information about UserInfo table:
https://learn.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/6c3a31c9-475c-42ef-b5e4-689d60b1ee82
Please have a try and let's know the result.
If I misunderstand your meaning, please feel free to reply.
---------------------
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.