Skip to content

Instantly share code, notes, and snippets.

@matt40k

matt40k/CognosReports_fromDb

Created May 28, 2015 13:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matt40k/3f78ae53c759580b3ebf to your computer and use it in GitHub Desktop.
Save matt40k/3f78ae53c759580b3ebf to your computer and use it in GitHub Desktop.
Download ZIP
Queries the Cognos BI database for the report and packages
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment