Getting Scheduled Activities of all WebReports

Usage and Config Platform
1

I would like to use the REST or SOAP API to get all the Scheduled Activities of Web Reports. The information I would like to gather is the Name, ID, Creator, Start, Expired, and Next time. Is this possible using the API? I am not able to find much information about how to gather this information so hope someone can shed some light on this for me.

2

Scheduled Activity details are not exposed currently through SOAP or REST, but they are accessible via the BESReporting database (in the SCHEDULED_ACTIVITY table).

1 Like
3

You could file an RFE to request that this be added in the future: How to ask for product help: PMRs, RFEs, and more

This will give you the raw data from a MSSQL db:

SELECT
      [ScheduledID]
      ,[UserID]
      ,[ScheduleInterval]
      ,[StartTime]
      ,[EndTime]
      ,[NextAttempt]
      ,[TypeParameters]
  FROM [BESReporting].[dbo].[SCHEDULED_ACTIVITY]
  WHERE [BESReporting].[dbo].[SCHEDULED_ACTIVITY].[IsDisabled] like 0

In order to really make sense of the results it will require much more complicated SQL:

The ReportID=14 found above in TypeParameters seems to correspond to the ID in here:

SELECT
      [ID]
      ,[ReportName]
      ,[Creator]
      ,[LastModified]
      ,[LastEditedBy]
  FROM [BESReporting].[dbo].[WEBREPORTS]

You should be aware that SQL queries could break at any time in the future.

4

Thank You this will work perfect in my .PS1 script.