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