Hello,

When you navigate to the given document in your CMSDesk / Content section and go to Properties / General tab, author is stored in -> "Created by" property? "Created by" property you could find as DocumentCreatedByUserID column in the CMS_Document table. So, you can get it also using the SQL query... then by ID of respective user, as you can find them in CMS_User table.

Or can also follow the Dev Guide API examples: Managing Documents where you can get the document node, and then via the NodeOwner property get the document owner ID (Created By)... and all the users info and appropriate user IDs are stored in the database table CMS_User.

simple example of getting author ID of the "Home" document:

TreeProvider tree = new TreeProvider(CMSContext.CurrentUser);

TreeNode node = tree.SelectSingleNode(CMSContext.CurrentSiteName, "/Home", "en-us");

string authorID = node.NodeOwner;

Best regards,
Martin Danko