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"

Reply via email to