Skip to Content
avatar image
Former Member

BusinessObjects Query Builder - How to find name of tagged events of publications?

I have attached success and trigger events in publications. I have about 2400 publication batches and I need to check each and every attachced event.
I don't want to go to each publication batch -> right click on properties -> go to events -> check manually for the name of the events, instead can I populate the details using SQL?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 14, 2018 at 01:09 PM

    You want to know which events are associated with your publications? You can do it, but not in one step.

    First, get the list of events with their infoobject IDs:

    select si_id,si_name,si_specific_kind from ci_systemobjects where si_kind = 'event'

    Next, get the recurring schedules that either wait for or fire events:

    select top 10000 si_name,si_scheduleinfo.si_dependants,si_scheduleinfo.si_dependencies from ci_infoobjects where si_recurring = 1 and (si_scheduleinfo.si_dependants.si_total > 0 or si_scheduleinfo.si_dependencies.si_total > 0)

    The "si_dependants" represent the events that the schedules fire when complete, "si_dependencies" are the events that the schedule waits for.

    Add comment
    10|10000 characters needed characters exceeded