Author Topic: List of reports from Content Store  (Read 5952 times)

Offline Mike Reaves

  • Associate
  • **
  • Join Date: Sep 2009
  • Posts: 1
  • Forum Citizenship: +0/-0
List of reports from Content Store
« on: 23 Sep 2009 02:47:55 pm »
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.


 


       
Twittear