Report contains all Reports data.

Sriram_1

Hi All,

I want to generate a report contains all Reports names and scheduled reports with scheduled time. any way I can get this data.

Thankyou.

flackovic

Hello! 

You could create a custom Report using a Custom Table or Custom Query resource using a query similar to this:

SELECT TOP 100 

Name
, Description
--, Enabled
, AccountID
, LastRun
--, SchedulesData

, CASE
WHEN SubString(SchedulesData, (CharIndex(':', SchedulesData) + 1), 4) = 'null' THEN 'Specific Date(s)'
ELSE SubString(SchedulesData, (CharIndex(':', SchedulesData) + 2), (CharIndex('",', SchedulesData) - 2) - (CharIndex(':', SchedulesData))) END AS [Cron Schedule]

, FrequencyTitle

FROM Orion.ReportJobs
WHERE Enabled = True

This should give you results similar to this:



There is a column that includes the cron schedule for recurring jobs. If you're not familiar with cron, you can use an online cron expression generator and plug in the value(s) of the "Cron Schedule" column to see when your reports are scheduled to execute their action(s).