Number of Cognos Reports and Users?

[craigalaniz]

Hi All

I am new to Cognos and I have been asked to figure out how many reports we currently have in Cognos? Also, I need to know how many active users we have.

Thanks for any help

Craig

[blom0344]

Cognos 'loans' security and authorization from - for instance - windows active directory. There is a good chance that special AD groups have been defined storing all the users that need to have access to Cognos through AD.
For reports check the  CMCLASSES table in the contentstore.  Normally the class id of  a report is 10
The following SQL would then give a list of reports:
(SELECT NAMES.NAME AS REPORT,NAMES.LOCALEID,NAMES.CMID,VERSION
FROM CMOBJECTS
INNER JOIN CMOBJNAMES NAMES
ON CMOBJECTS.CMID = NAMES.CMID
WHERE CLASSID = 10 AND DISABLED IS NULL AND
NAMES.LOCALEID = (select max(LOCALEID) from CMLOCALES where LOCALE IN ('en'))
)
assuming the design language is english ('en')

[Olivier]

Hello,

I would recommend to use CMTools (provided by IBM) which is free of charge, which will answer your questions and some future questions :

http://www.ibm.com/developerworks/data/library/techarticle/dm-0808masters/

Best regards

Olivier