Yeah I was hoping for a lazy way to find a list too. Looks like I may have to use some fuzzy logic to identify fields containing Site Names. It doesn't help when the developers might have used different label and database names to store Site Names in different places across all the ITSM apps.. Else it still would have been a relatively easy task to write up a quick SQL script to change it.
Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Westbrock Sent: Monday, August 04, 2014 5:57 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. Silly me, I figured the Data Wizard would identify all the forms that would need to be changed, I didn't account for the fact that it might only have core forms and not extras like WO, SRM etc. I figured at least it might be a good starting point (and it was top of mind since I was using it for something else myself today). -Rick From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lucero, Michelle Sent: Monday, August 04, 2014 2:55 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** Hi, Joe: The Data Wizard is great, but just remember that it doesn't cover everything. Work Orders is one form that comes to mind. Obviously, custom forms that may have site fields are not covered. But, there are instructions on adding new forms that the Data Wizard will update. You'll also have to add your own workflow. BEWARE: Only the Site Name is updated using the Data Wizard. One cannot update Region or Site Group. See Ideas on the Data Wizard in BMC Community requesting enhancements to some of the limitations. Ability to rename Region and Site <https://communities.bmc.com/ideas/2663> Group Multiple Support Group Rename <https://communities.bmc.com/ideas/2872> Capability Ability to rename Organization <https://communities.bmc.com/ideas/3133> and Department Data Wizard to include currently <https://communities.bmc.com/ideas/3042> excluded elements Data Wizard <https://communities.bmc.com/ideas/6423> - Improved Reporting Hope that helps Michelle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, August 04, 2014 3:15 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** I didn't think of the Data Wizard. Let me give that a shot if I really need to do what I think I may have to. Thanks for your response.. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Westbrock Sent: Monday, August 04, 2014 4:03 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. Joe- Could you run the Data Wizard for Site Name to get a count of records? I think that should give you a good list of the forms affected. -Rick From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, August 04, 2014 10:30 AM To: [email protected] Subject: Impact of renaming Sites in ITSM 7.6.04.. ** Has anyone gone through the exercise of renaming Sites for whatever reasons? I would like a comprehensive list of forms (both foundation and other ITSM/CMDB application data) it has an impact on? I may not have to actually do it, but I see it as a possible solution to an automatic feed of new SIT:Site data that we have a requirement for to reconcile older Site Names to new ones that may be created now or in the future so a duplicate won't occur. Joe _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_ _____ This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _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"
