Yeah I would prefer it does a Direct SQL.. I had done the exact same thing years ago on what used to be the CRM system from Viadyne and in fact had built a customer a stored procedure in SQL that ran from a console like form in Remedy for changing a Company Name. I do not recall if that design involved a group creation when a company was created but if it did, I might have run process arsignal to reset the group cache soon after it modified the Group form's underlying data.
Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Wednesday, July 16, 2014 6:01 PM To: [email protected] Subject: Re: Company Name change in ITSM 7.6.04... ** 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 :-).. 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/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_ _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"
