Michael_Lowry

Find SQLI VARAs based on the content of the queries

Discussion created by Michael_Lowry on Aug 23, 2017
Latest reply on Aug 23, 2017 by Wolfgang_Brueckler_1288
The Search function in the Automation Engine does not appear to allow one to search for SQLI VARA objects based on the content of the queries stored in those objects. To work around this limitation, I came up with an SQL query that does the trick.
select * from OH
join OVD on OVD_OH_IDNR = OH_IDNR
where 1=1
and OH_Client = 120
and OH_DeleteFlag = 0
and OH_OType = 'VARA'
and OH_SubType like 'SQLI%'
--and OH_Name like '%'
and OVD_SQLORA like 'with orig_job as%'
Enjoy!

Outcomes