If you describe the structures of the meta data tables, you more or less get almost 70% of the columns that would hold server names and you could do a distinct search to return the server names in those columns and check to see if they return values other than @ and Field ID's (dynamic server names in advances workflow). Replace all IP addresses or host names that may appear on those lists with @.
If however you see the same in columns holding qualification values, you will need to be careful and then you need to account for the length of the server name. Its better to alter those from a xml def file. You will also need to consider server names embedded in the configuration data of ITSM applications in places like SRM settings, AIE settings etc. Joe ________________________________ From: "Egan, Anik" <[email protected]> To: [email protected] Sent: Wednesday, January 21, 2009 3:04:29 PM Subject: DB copy and restore with ITSM 7 - server name references ** Hi Listers, Has anyone uncovered all server name references that need to be replaced when doing a DB backup/restore to migrate an ARS/ITSM 7 DB to another server? I’ve seen a few postings on this but can’t find anything complete. All KB entries regarding server name changes appear to be really outdated. Any assistance would be greatly appreciated. Thanks …anik Copy ARS Server with ITSM 7 thru database copy? Rabi Tripathi Mon, 12 Nov 2007 13:19:00 -0800 Let me summarize what you guys said so far about copying ITSM 7 from one server to another one: (1)Copying the file system from one server to another one is a bad idea. Ok. I was not planning on doing this. Only want to copy the database, after I install all the software on the new server. (2)After I install all the applications, and copy the database to the new server, I need to: a)Update path to help files b)Update SHR:Application records. I see the server references to update on this form's records. c)Update CAI:Application Registry records. I see the server references on this form's records, so I will update them. d)Need to update Configure "Custom Form Info" form records. I can't find this form. Probably an alias. What's the actual form name? e)Update "Email form", meaning "AR System Email Configuration" form recrods. I can't find server reference on this form. Are you guys talking about a different form? f)Need to reinstall EIE and AIE after database copy. "To make EIE work after moving databases, read the note on how to configure EIE on a server group or a shared database." EIE=Event Integration Engine, AIE=Assignment Engine? g)May need to update User and "People" (CTM:People) forms. I can't find server name references here, but I guess I need to fix the license information. Is that it? It can't be that easy! May be it is. I will then need to spend some more time modifying some parameters in Server Info tab on Remedy Admin as well as ar.conf to account for the fact that I may want the new server to behave differently (in my case no server group setup). I'm trying to see if I can somehow do a database query to see which tables have my server name embedded. If I find anything new I will share with you guys. In the mean time, please validate or add to the list above. Wondering if there is any white paper on this. The likely answer is no. Or, if the partner implementation trainings covers such a copy, or any other way of copying apps. If not, that's an inexcusable omission. Or so I think. Regards. --- Joe D'Souza <[EMAIL PROTECTED]> wrote: > Neither will Help paths to OTB applications be > correctly configured. You > will manually need to configure these manually by > altering the paths in the > SHARE:Application Properties form by editing the > path to help. > > To make EIE work after moving databases, read the > note on how to configure > EIE on a server group or a shared database. > > Pardon my ignorance, but what is AIE? > > > Joe D'Souza > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [EMAIL PROTECTED] Behalf Of strauss > Sent: Monday, November 12, 2007 2:43 PM > To:[email protected] > Subject: Re: Copy ARS Server with ITSM 7 thru > database copy? > > > Another thing that will not copy correctly with a > database is EIE or AIE > - you will have to reinstall it after the move, but > that does work. > > Christopher Strauss, Ph.D. > Remedy Database Administrator > University of North Texas Computing Center >http://remedy.unt.edu/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

