Stored Procedure Hash?

Question

Hi folks,

I would like to look up a stored procedure in the DPA repository to see if it exists and if so, look at the analysis done by DPA. How do I find a stored procedure name in the repository to see if it's been captured by DPA and if so, what the hash value is so I can plug it into the DPA activity URL?

Thanks,

Michael Murray

mandevil · Accepted Answer

We track by SQL statements, but trap the sproc it's running within. Perhaps the easiest way to check is to query the repo directly. First run this query to get the ID of the instance in question: select id, name from COND.

Next run this: select h, st, pname from const_<id from first query> where pname = '<name of sproc'