View all data source connection details

[kc9400]

Hi,

I've accessed the Cognos admin page and navigated to the Configuration > Data Source Connections

Is there a way I can see the detailed information for each connection without having to go into each one.

Is there an XML file somewhere which has them all listed?

Any help with this would be great.

Cheers.

[mrcool]

You can query content store to get the details of all your datasources.

[kc9400]

Thanks, I'll take a look into it.

[cognos810]

Hello kc9400,
This will list all the data sources, the connections within each and their respective connection strings.
This works for Cognos 10.1.1 and 10.2.1.

select Datasources.Name as "Data Source Name", objnm.NAME as "Connection Name", dconns.CONNECTSTR FROM CMOBJPROPS52 dconns
inner join CMOBJNAMES objnm on
dconns.CMID=objnm.CMID
inner join
(
select dconns.CMID, cmobj.CLASSID, cmobj.PCMID, objnm.NAME from
CMOBJPROPS52 dconns inner join CMOBJECTS cmobj
on dconns.CMID=cmobj.CMID and cmobj.CLASSID=9
inner join CMOBJNAMES objnm
on cmobj.PCMID=objnm.CMID) DataSources
on Datasources.CMID=dconns.CMID


-Cognos810

[kc9400]

Cheers Cognos810, that worked perfectly.

Much appreciated.