Category: Ektron
XML Site Map
Based Off of Ektron Code Library – http://developer.ektron.com/Templates/CodeLibraryDetail.aspx?id=4294967329&blogid=116
Ektron File Extension Asset Inventory
Following the logic in a previous post, File Extension, this query will list Ektron asset file extensions and count them.
Ektron Metrics Script
This is a compilation of some of the scripts on this site to get numbers to report to management
Ektron Content Status Codes
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…
Subscribed Web Alert
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…
Delete Ektron User
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.
Update Ektron License
After applying this update you will need to restart the services and in some case restart the server completely.
Ektron SQL – List All Users
If you’re looking for more specific access lists look at Ektron – User Access List
Ektron Metrics – User Count By User Group
Part of the Ektron Metrics Script, this query will help with metrics to give you an idea of how often your users login.