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
I got all the BPMs with the following SQL code:
select * from BpDirective where cast(Body as nvarchar(max)) like ā%servername%ā
But I canāt think of how to do this for customizations. I feel like Iām missing something obvious. Much of our code base is still foreign to me, and while I have spent a ton of time lately pouring over it all, I donāt quite feel comfortable enough banking on the knowledge I haveā¦
I already have plans to improve all this, but for right now I just need to put a band-aid on it and identify everything with āservername1ā and change it to āservername2ā.
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.