Audit query

query um dr Audit Trail vomene User uf eme bestimmte Objekt azluege

select ad.doc_id, ad.timestamp, get_obj(ad.obj_id) asset

      ,ok.key_val isin

      ,ca.name addition

      ,al.old_item_val

      ,al.new_item_val

      ,asset_cutoff_time_bnp 

      ,asset_cutoff_time_ubs  

from   aud            ad

      ,aud_item       ai

      ,table(ai.log)  al

      ,meta_script_fld f

      ,doc             d

      ,obj_rel_key    ok

      ,obj_asset_add  oa

      ,code_obj_add   ca

where 1=1

  --and ad.doc_id = 1118690581

  and d.id = ad.doc_id

  and d.meta_typ_id = 100

  and d.ins_by_sec_user_id = 123076

  and ad.id = ai.aud_id

  and d.trx_date > '31-JUL-2016'

  and ad.obj_id = ok.obj_id (+)

  and ok.obj_key_id (+) = 1

  and f.id = al.item_id

  and f.name = 'val'

  and oa.obj_id (+) = ad.obj_id

  and ca.id = al.key_val

  and al.key_val in (5085, 5086)

order by ok.key_val, ad.timestamp

---

Besprich das Bocksnip

Kei Kommentar zur Diskussion gfunde

---

Du muesch igloggt si, um über das Bocksnip z'diskutiere

Bocksnip Tags

Teil din Code

---