We have many BPMs and Customizations containing hard-coded server names, which I need to identify ASAP. I know, I know, this is an awful idea, that is why I am trying to clean it up :slight_smile: I got all the BPMs with the following SQL code: select * from BpDirective where cast(Body as nvarcha…

This post may shed some guidance… [image] Grab Custom Controls on forms ERP 9 I was wondering if anyone knows of an easy way to search for forms that use the generic columns(Character01, CheckBox01, Date01, Number01, ShortChar01). I tried Inspect.exe, spy++and other UI te…

This will do the job for you: select * from ice.XXXDef where content like '%YOUR_SEARCH_TERM_HERE%'

The post @Mark_Wonsil referenced works for older versions. The more current versions store the Client customizations in plain text (xml) in the xxxDef table Content field. If your system has the Content field on xxxDef, that is where you would look.

Thanks, all. Looks like I missed out on the easy way; our Live system is on 10.1.400 and XXXDef.Content doesn’t exist in the database. But I’ll keep this in mind for when we finish upgrading. The post Mark referenced might be a bit much for me, I think I’ll just skim through manually.

Search through all Customizations containing a string value?

Epicor ERP 10

Mark_Wonsil (Mark Wonsil) May 29, 2020, 8:12pm 2

This post may shed some guidance…