Queries the Cognos BI database for the report and packages

CognosReports_fromDb

select
	names.NAME as 'ReportName'
	,packageNames.NAME as 'PackageName'
	,convert(nvarchar(512),reportpath.PATHS) as 'ReportPath'
from
	CMOBJNAMES names
	inner join cmrefnoord1 ref on
		names.CMID = ref.CMID
	inner join CMOBJNAMES packageNames on
		packageNames.CMID = ref.REFCMID
	inner join CMOBJPROPS18 reportpath on
		names.CMID = reportpath.CMID
where
	names.LOCALEID IN ( 24, 34, 106 )
	and packageNames.LOCALEID IN ( 24, 34, 106 )
	and ref.PROPID = 31