That's an 8.0 Wizard isn't it? Is something like that available for 7.6.04?
Sure if the documentation of that Wizard, speaks of all the forms it changes, we might be able to use that information to create something for 7.6.04 - assuming that those forms exist on 7.6.04 too, else we may have to rely on SQL to find all forms that have the Company name set to a field and then change it from behind API layer. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Wednesday, July 16, 2014 4:07 PM To: [email protected] Subject: Re: Company Name change in ITSM 7.6.04... ** 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/1fNwkJPuAdzGmUngGk5GNaIS7RuixSNylIUBogaUn 65E/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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
