Hi Guys... There is a utility that came with ITSP4 called the Data Wizard.
It allowed you to do Search & Replace on: 1) Product Categorization 2) Product Model Version 3) Product Type 4) Service Categorization 5) Generic Categorization 6) Support Groups 7) Support Group Shift 8) Site Name 9) Site Location Information 10) Site Zone 11) Login ID 12) Person Name 13) Login ID 14) Company Name This feature was requested after the release of ITSM7, but has not yet been deployed. They appear to still be doing R&D - as far as I know no beta testers have been requested yet... On Feb 20, 6: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 Centerhttp://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: [EMAIL PROTECTED] > 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.comARSlist: "Where the > Answers Are" html___ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
