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.