Isn't there a Nickname field for companies? Could that be leveraged in some way?
Rick On Wed, Feb 20, 2008 at 3:01 PM, strauss <[EMAIL PROTECTED]> wrote: > ** BMC was supposedly going to release a "utility" for that this year > (2008), but if they release something like Data Management (patch 9003) it > will only work half-way, and only half of the time (and only with jato > bottles strapped to its butt). > > If they release it on the same "schedule" we have seen for updating > Incident Task Templates (patch 9002), you should see it sometime in calendar > year 2009. > > You'll probably have to give them Doug Mueller's stock answer for people > requesting customizations to ITSM 7: several iterations of NO. > > We have not faced company renaming (and plan to reject it outright), but > we have seen some shuffling of support group names which is almost as bad > since you have to move the support staff over and reassign the related > records; your obsolete/recreate solution is the only one available to us > right now. > > Christopher Strauss, Ph.D. > Call Tracking Administration Manager > University of North Texas Computing & IT Center > http://itsm.unt.edu/ > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Jase Brandon > *Sent:* Wednesday, February 20, 2008 4:24 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Changing Company Name on 7.0.01 > > ** Hello All, > I am getting several requests to change the Company field in version > 7.0.01 > Ex. Joe's Computers is now changing it's name to Joseph's Computers. > > > > Field ID 1000000001. > When I search this field ID in ARutilities, it returns 417 references to > that field. > > Has anyone come up with a way to change Company name and ensure it is > propogated throughout the database? > > Other than a monster SQL script to update the field in all locations, I > don't think this is possible. > My current answer to this question is: Set Joe's computers to "Obsolete" > and recreate as "Joseph's Computers". > But then we lost historical reporting data, etc. > > Has anyone else encountered this? I just thought we couldn't possibly be > the only company who has dealt with this situation. > > 7.0.01 Unpatched > SQL Server 2005 > > Thanks, > > Jase > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"