Listing of Content Editors

Sebastian Savard asked on October 8, 2015 22:26

Hello,

We have many different content editors, each assigned different roles which restrict their page access. Is there a way to create a list, spreadsheet, etc of what users are able to edit each page? Ideally if someone spots a typo, we want them to be able to check the list and let the user responsible know about the issue.

Thanks for the help!

Recent Answers

Brenden Kehren answered on October 9, 2015 02:30

Get all the documents and join in the users and print your list. You should have both the person who created the page and who last edited it.

A SQL statement might look like this:

SELECT DocumentName, NodeAliasPath, DocumentCreatedWhen, DocumentModifiedWhen, UserName, FullName, Email
FROM View_CMS_Tree_Joined
LEFT OUTER JOIN CMS_User ON NodeOwner = UserID

1 votesVote for this answer Mark as a Correct answer

Roman Hutnyk answered on October 9, 2015 20:19

Agree with Brenden, but I'd recommend to join on DocumentModifiedByUserID instead of Owner - this will give you the last user, who updates the document, meanwhile Owner might be some admin or developer (creator):

SELECT DocumentName, NodeAliasPath, DocumentCreatedWhen, DocumentModifiedWhen, UserName, FullName, Email
FROM View_CMS_Tree_Joined
LEFT OUTER JOIN CMS_User ON DocumentModifiedByUserID = UserID

0 votesVote for this answer Mark as a Correct answer