Extracting Event information from Database

[baskaran_8732]

Hi Team,

We are trying to extract the event information. Kindly help us with the query to extract the information.

Regards,
Baskaran K J

[Pete Wirfs]

This returns JSCH scheduling rules;

select oh_client as client
      , oh_name           as SCHEDULE
      , jpp_object       as OBJECT
      , JPP_ErlstStTime  as STARTTIME
      , jppc_calekeyname as CALENDAR
   from oh
      inner join jpp 
         on oh_idnr = jpp_oh_idnr
      left outer join jppc 
         on jppc_jpp_lnr = jpp_lnr and jppc_oh_idnr = oh_idnr
  where oh_otype = 'JSCH' and oh_deleteflag = 0 and oh_client = 100
  order by 4,3,5;​

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Frederic BERGERON]

hi,

I am looking for exactly this script but for time events

I can't see in which table this information is located
any idea ?