Cognos Auditing Table - Data Source and Connection String Query

[Cognos KW]

Hi guys,

Can someone please provide me SQL content store query to get data source name, connection string, owner.

Any help will be much appreciated!

[cognos810]

hello wadhwa.kanul,
This should give you the data source related information. You may have to alter a little bit to get the owner.

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

[Cognos KW]

Thanks for a quick response cognos810.

Much appreciated!