When querying the Ektron database for troubleshooting, sometimes it is necessary to find the location of the content item in the workarea or in the case of assets and library items, the actual file on the file system.
When querying the database, the following script can be run to return the location of the content item in the workarea as well as its folder path on the file system to locate the file. This query will return the path to the content in the workarea and the ID path for corresponding assets/privateassets on the file system
--Replace x with the content id
select content_folder_tbl.FolderPath, '/0/' + content_folder_tbl.FolderIdPath from content_folder_tbl
inner join content on content.folder_id = content_folder_tbl.folder_id
where content_id = x
Please sign in to leave a comment.