I haven't looked too closely at how it does it but if I remember correctly it perform direct SQL so I think you will be ok.
On Wed, Jul 16, 2014 at 2:56 PM, Joe D'Souza <[email protected]> wrote: > ** > > Cool J.. > > > > Hopefully it doesn’t touch the Last Modified By and Last Modified > information on tickets? If it does it might be a better idea to write a SQL > job to do the same thing.. > > > > Joe > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Wednesday, July 16, 2014 5:53 PM > > *To:* [email protected] > *Subject:* Re: Company Name change in ITSM 7.6.04... > > > > ** > > This was delayed in my spam box. Thanks for confirming it is available in > 7.6.04. > > > > Jason > > > > On Wed, Jul 16, 2014 at 1:47 PM, Ars Lister <[email protected]> wrote: > > ** > > I second on that Joe. The only way to successfully update Company or Site > info in ITSM 7.6.04 is with the Data Management tool which has the Data > Wizard mentioned by Mr. Miller. It will modify whatever company names you > want to change in all the ITSM forms and the Atrium CMDB where appropriate > with one action. It takes a while, but it gets it done. > > Good luck with that! > > > > On Wednesday, July 16, 2014 4:07 PM, Jason Miller <[email protected]> > wrote: > > > > ** > > Hey Joe, > > > > Have you looked at the Data Wizard? > > > > https://docs.bmc.com/docs/display/public/itsm80/Overview+of+the+data+wizard > > > > Here are some screenshots I took from our Dev (has an orange skin) that > shows you can rename a company, the forms it touches and the record counts > in each form. > > > https://docs.google.com/document/d/1fNwkJPuAdzGmUngGk5GNaIS7RuixSNylIUBogaUn65E/pub > > > > Jason > > > > On Wed, Jul 16, 2014 at 12:15 PM, Joe D'Souza <[email protected]> wrote: > > ** > > Has anyone attempted this successfully? If so do you have a whole list of > places where this name might be needed to be changed? > > > > I have noticed that the design of the ITSM application is not very > consistent about where it uses the Request ID (Entry ID or Field 1) or > instanceID or some GUID to relate such data and where it uses something > like Company Name itself to relate data. For e.g. in the SIT:Site Company > Association table, it looks like the Company Name is used in the > relationship, while in some other places either the Company Entry ID or the > instanceId is used. > > > > This could mean that a name change could possibly break a few data > relationships, if the name change doesn’t propagate to all the forms that > use the name in the relationship.. > > > > Does anyone have a complete list of forms where this relationship might be > broken in the event one needs to change the Company Name? I’m suspecting > there is no OTB workflow, which would propagate this change to all forms > that might need to reflect this change. > > > > > > > > A simple SQL search show 737 forms that have data fields that Company in > the field name where the field is a data field. > > > > SQL> select count(*) from aradmin.arschema where schemaid in (select > schemaid from aradmin.field where fieldname = 'Company' and fieldtype = 1) > order by name; > > 458 > > > > SQL> > > SQL> select count(*) from aradmin.arschema where schemaid in (select > schemaid from aradmin.field where fieldname like '%Company%' and > fieldtype = 1) order by name; > > 737 > > > > > > Regards > > > > Joe > > > > PS: Does ITSM 8.x handle name change of a company better than 7.6.04?? > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
