Hi @Mark
You can use below tsql query statement :
;with CTE as (SELECT
[Path]
, CASE [Type]
WHEN 2 THEN 'Report'
WHEN 5 THEN 'Data Source'
END AS TypeName
, content = CAST(CAST(content AS varbinary(max)) AS xml)
, [Description]
FROM ReportServer.dbo.[Catalog] CTG
WHERE
[Type] IN (2, 5))
SELECT [Path],TypeName,[xmlns] = content.value('namespace-uri((/*:Report)[1])','nvarchar(max)') from CTE
Best Regards,
Isabella