Content database: list of datasources?

[DTV12345]

Greetings!

I need to create a list of the datasources that are created on our production server and publish that list to  our developers.

I created a FM project that points to my content store db and from that, a simple tabular report. Problem is that the tables from the content store db I thought of using (NC*) are empty...???

Do you have any suggestions on how to do that? Has anyone do anything similar to that??  :-\

I am open to any ideas....etc.

TIA,

Al.

[bpeterson]

Trying to manually dig through the CS is futile, becuase of the lack of information regarding the structure. The SDK provides methods to build a very simple app to pull the datasources, there is a KB document on support.cognos.com that deals with this issue.

The knowledge document #1008149.2.

Let me know if that helps

[megatrack67]

If you are using Oracle as content store, here a select to find all the datasources with there english name

SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),
          cmobjects.created, cmobjects.modified, cmobjects.disabled,
          cmobjnames_base.isdefault
     FROM cmobjects, cmobjnames_base
    WHERE cmobjects.classid = 12
      AND cmobjects.pcmid = 49
      AND cmobjnames_base.mapdlocaleid = 24   <=====remove this line to see all names
      AND cmobjects.cmid = cmobjnames_base.cmid

regards

PC

[DTV12345]

Trying to manually dig through the CS is futile, becuase of the lack of information regarding the structure. The SDK provides methods to build a very simple app to pull the datasources, there is a KB document on support.cognos.com that deals with this issue.

The knowledge document #1008149.2.

Let me know if that helps

You are correct...this was a waste of time. We contracted a Java developer. The rest took care of itself.

[mrcool]

If you are using Oracle as content store, here a select to find all the datasources with there english name

SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),
          cmobjects.created, cmobjects.modified, cmobjects.disabled,
          cmobjnames_base.isdefault
     FROM cmobjects, cmobjnames_base
    WHERE cmobjects.classid = 12
      AND cmobjects.pcmid = 49
      AND cmobjnames_base.mapdlocaleid = 24   <=====remove this line to see all names
      AND cmobjects.cmid = cmobjnames_base.cmid

regards

PC

Hi,
Is it possible to link this with package to find the dependency?