Extracting data from APS database directly

[fpostma]

Hi,
I'm looking for some sql that will enable me to show what instances of a specific report are scheduled and what the parameter values are for each scheduled instance by querying the APS database directly. Our APS database is SQL Server. Any help is appreciated.

Thx!

 

[FredHelm]

I had the exact same question as you. Your are going to have to use the CE SDK to gather the desired information as it is stored in the Binary field.
If you installed the Crystal Enterprise web samples, you can use Query Builder which uses the CE SDK and submit the following "Crystal Enterprise SQL" statement to get your information:

SELECT * FROM CI_INFOOBJECTS WHERE SI_Recurring = 1 ORDER BY SI_ID

I am using CE 10 but I'm sure that BOE XI has something equivalent.

Hope this helps