This is a list of code definitions for the content_status column in the content table Letter Meaning Content state More Information A Approved Through the workflow and published on the Web site. Approved Content O Checked Out Currently being edited. Has not been checked in. Checked Out Content I Checked In Checked in for other…
Will return you all the web alerts. The ID column represent the ID for the web alert Will return you the folder(s) where the web alert is assigned The column Value_number represents the ID column from subscriptions_tbl The column Object_ID represents the folder ID where the web alert is assigned Will return you the users…
In order to force a deletion from the Ektron user list you must follow the below path. DISCLAIMER: This will remove all content that was ever created/touched by the user.
After applying this update you will need to restart the services and in some case restart the server completely.
If you’re looking for more specific access lists look at Ektron – User Access List
Part of the Ektron Metrics Script, this query will help with metrics to give you an idea of how often your users login.