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: [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.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"
