Re: Relating SQL from AWR to Remedy Workflow [I]

Hi, What you need to do is to look at the ar.h file in the API-directory, and also a def-file export of the objects. This should help you find what is actually behind the scenes. A much easier way would be to write a C- or Java-API program that access the Remedy-server to get this information. T

Re: Relating SQL from AWR to Remedy Workflow [I]

Classification: For internal use only Thanks Misi, Yes indeed... not an easy task at all but think I am making progress via the assignlong/short fields within the actlink_xxx tables. If I can crack it I will post here. Regards, Paul Nicolaides --- This e-mail may contain confidential and

Re: Relating SQL from AWR to Remedy Workflow [I]

Hi, That is NOT an easy task. I would recommend that you turn API/ESCL/FLTR/SQL logging on, and sample enough data to catch these same SQL-calls, and you will have a better hope of finding what you are looking for. Our commercial RRR|Log tool has one goal, and that is to make that search easier.

Relating SQL from AWR to Remedy Workflow [I]

Classification: For internal use only Hi, I am currently working through all high cost SQL identified in an Oracle (10g) AWR report. Does anyone know the best way to relate these SQL statements to the Remedy active links and filters? I am querying the actlink_set/push etc table via SQL Develop