Ektron Alias List

SET NOCOUNT ON

DECLARE @Domain VARCHAR(50)

SET @Domain = '<domain>'

SELECT AliasName
    ,(@Domain + alias_pagename) AS AliasURL
    ,(@Domain + alias_logical) AS ActualURL
    ,content_id
    ,content_language
FROM url_alias_tbl
LEFT OUTER JOIN UrlAliasManual_Tbl ON UrlAliasManual_Tbl.aliasid = url_alias_tbl.alias_id
ORDER BY AliasName

SET NOCOUNT ON

DECLARE @Domain VARCHAR(50)

SET @Domain = '<domain>'

SELECT (@Domain + [urlaliasnm]) AS AliasURL
	,(@Domain + [urltargetnm]) AS ActualURL
	,[TargetID] AS ContentID
	--,[NodeID]
	,uact.UrlAliasConfigTypeName AS [Type]
	,CASE
		WHEN IsDefault = 0
			THEN 'False'
		WHEN IsDefault = 1
			THEN 'True'
		END AS 'Default'
	,CASE
		WHEN [IsEnabled] = 0
			THEN 'False'
		WHEN [IsEnabled] = 1
			THEN 'True'
		END AS 'Enabled'
FROM UrlAliasMapping uam
INNER JOIN UrlAliasConfigType uact ON uact.UrlAliasConfigTypeId = uam.AliasTypeID
ORDER BY [IsDefault]
	,IsEnabled