Product
Cognos BI 8.4
Oracle database
Problem:
How do i get a list of all Packages in the Cognos Connection?

Solution:
Start SQL developer for ORACLE, connect to the Cognos BI Content Store.
Run below script (you need to adjust it for Microsoft SQL):

SELECT cmobjnames.cmid,
cmstoreids.storeid,
cmobjects.pcmid,
cmobjnames.name,
cmobjnames.mapdlocaleid,
cmobjnames.localeid,
cmlocales.locale,
cmclasses.name as type
FROM cmobjects, cmobjnames, cmclasses, cmstoreids, cmlocales
WHERE
cmobjects.cmid = cmobjnames.cmid
AND cmobjects.classid = cmclasses.classid
AND cmobjects.cmid = cmstoreids.cmid
AND cmclasses.name in(‘package’)
AND cmobjnames.localeid = cmlocales.localeid and cmlocales.locale in (‘en’)