EKTRON ALIASMANAGER GETTARGET PDF
EKTRON ALIASMANAGER GETTARGET ARCHIVE

(u.first_name + ' ' + u.last_name) AS 'Created By', THEN 'Awaiting Completion of Associated Tasks' This is a collection of a few other scripts that I’ve posted here but this script concatenates widget and alias listings into one column so that you only have one row per content item. LEFT OUTER JOIN cft ON c.folder_id = cft.folder_id LEFT OUTER JOIN c ON c.content_id = em_id INNER JOIN menu_tbl mt ON mt.mnu_id = mtit.mnu_id THEN CAST(item_type AS VARCHAR(5)) + ' - Catalog Entry'įROM. THEN CAST(item_type AS VARCHAR(5)) + ' - Discussion Topic'

EKTRON ALIASMANAGER GETTARGET PDF

THEN CAST(item_type AS VARCHAR(5)) + ' - Archived PDF Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - Multimedia' THEN CAST(item_type AS VARCHAR(5)) + ' - PNG Image Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - MS Office Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - Non Library Content'

EKTRON ALIASMANAGER GETTARGET ARCHIVE

THEN CAST(item_type AS VARCHAR(5)) + ' - Archive Media' THEN CAST(item_type AS VARCHAR(5)) + ' - Archive Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - PDF Assets' THEN CAST(item_type AS VARCHAR(5)) + ' - Archive Forms' THEN CAST(item_type AS VARCHAR(5)) + ' - Archive Content' THEN CAST(item_type AS VARCHAR(5)) + ' - Forms' THEN CAST(item_type AS VARCHAR(5)) + ' - Content' THEN CAST(item_type AS VARCHAR(5)) + ' - AllTypes' GROUP BY c., content_type, cft.FolderPath LEFT OUTER JOIN uam ON uam.TargetID = c.content_id INNER JOIN cft ON c.folder_id = cft.folder_id THEN CAST(content_type AS VARCHAR(5)) + ' - Catalog Entry' THEN CAST(content_type AS VARCHAR(5)) + ' - Discussion Topic' THEN CAST(content_type AS VARCHAR(5)) + ' - Archived PDF Assets' THEN CAST(content_type AS VARCHAR(5)) + ' - Multimedia' THEN CAST(content_type AS VARCHAR(5)) + ' - PNG Assets' THEN CAST(content_type AS VARCHAR(5)) + ' - Non Library Content' THEN CAST(content_type AS VARCHAR(5)) + ' - Archive Media' THEN CAST(content_type AS VARCHAR(5)) + ' - Archive Assets'

THEN CAST(content_type AS VARCHAR(5)) + ' - Assets' THEN CAST(content_type AS VARCHAR(5)) + ' - Library Item' THEN CAST(content_type AS VARCHAR(5)) + ' - Archive Forms'

THEN CAST(content_type AS VARCHAR(5)) + ' - Archive Content' THEN CAST(content_type AS VARCHAR(5)) + ' - Forms' THEN CAST(content_type AS VARCHAR(5)) + ' - Content' THEN CAST(content_type AS VARCHAR(5)) + ' - AllTypes' If you have more than one person in the site administration you can sometimes get duplicates, this script will help you find them.

Ektron aliasmanager gettarget