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