If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

List of reports from Content Store

Started by Mike Reaves, 23 Sep 2009 02:47:55 PM

Previous topic - Next topic

Mike Reaves

My manager's requested a list of the 1500 reports we have in C8 with attributes such as schedule, data source, recipients.

REPORT TITLE, PUBLICATION FREQUENCY, LAST PUBLISHED, NEXT PUBLISHED, DATA SOURCE, DELIVER TO.

That would be an example of the headings of the list.

Shouldn't this be possible from a query against the content store?
Here's how I can get the Queries & Reports:

SELECT     TOP 100 PERCENT dbo.CMOBJNAMES.NAME AS ObjName, dbo.CMOBJECTS.PCMID, dbo.CMCLASSES.NAME AS ClassName
FROM         dbo.CMOBJECTS INNER JOIN
                      dbo.CMOBJNAMES ON dbo.CMOBJECTS.CMID = dbo.CMOBJNAMES.CMID INNER JOIN
                      dbo.CMCLASSES ON dbo.CMOBJECTS.CLASSID = dbo.CMCLASSES.CLASSID
WHERE     (dbo.CMOBJECTS.CLASSID IN (10, 37))
ORDER BY dbo.CMOBJECTS.PCMID

How can I get the schedule joined into this?
You help is greatly appreciated.