ETL, App Development and other tools > Automation

List of reports from Content Store

(1/1)

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.

Navigation

[0] Message Index