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 <jason.mil...@gmail.com> 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 <jdso...@shyle.net> 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
