Hello,
We’re trying to migrate away from our in house Exchange server. There’s a number of method directives that are using C# code to send mail that’s pointing at the old Exchange server. Is there any easy way to search in Epicor or in the SQL Server to look at the code that’s in these method directives?
Thanks.
Yes, had to do something similar a couple weeks ago. Try this query:
select * from BpDirective where cast(Body as nvarchar(max)) like ‘%ServerName%’
BpDirective.Body
Yes there is. Check the BpDirective.Body field of each row. Alternately, I have created a python script to do exactly what you’re trying to.
Perfect, that’s exactly what I’m looking for.
If you have access to the server directory, all the code for the MD/DD can be found in the \Server\BPM\Sources directory. They are organized a little differently than expected, but a text search at that level should also produce the results you are looking for. I use this to find code inside the configurators as well…
I have been using cmder on the server since haso posted about it. I am used to grep and this gets me what I need quickly. See link below from @hkeric.wci on it.
Greg