Skip to content

Instantly share code, notes, and snippets.

@matt40k
Created May 28, 2015 13:15
Show Gist options
  • Save matt40k/3f78ae53c759580b3ebf to your computer and use it in GitHub Desktop.
Save matt40k/3f78ae53c759580b3ebf to your computer and use it in GitHub Desktop.
Queries the Cognos BI database for the report and packages
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment