Is there a way to export a list of all the custom reports created?

cgting

I need a report to list all the custom reports created with information on schedule and who created it.

Daran

Hi,

this is probably a good start for what you're looking for:

SELECT
    ReportJobID,
    Name,
    Description,
    Enabled,
    AccountID,
    LastRun,
    WebsiteID,
    SchedulesData,
    ActionsData,
    ReportsData,
    UrlData,
    ActionTitles,
    ReportTitles,
    FrequencyTitle,
    DisplayName,
    InstanceType,
    Uri,
    InstanceSiteId
FROM
    Orion.ReportJobs