Hey, Leonard –(blast from the past from CW ) ☺ You are right, "DLD:SYS:DataWizAudit_Forms" is a good starting point.
FYI: Because, we had to update tens of thousands of unique sites AND since the Data Wizard is restricted to updating the Site Name and NOT the Site Group and Region; we couldn’t use the Data Wizard either. Like others, had to build our own solution. The fact that one can only update one site name, Support Group, login, Categorization at a time is one reason for the Ideas being submitted on BMC Communities for the Data Wizard. -------------------------------------------------------- @Joe, I created two SQL scripts to assist me with the initial research. 1. Finds all references to foundation fields including Site, Categories, Support Group, etc. The results list contains the form name, schema Id, fieldname, fielded, data type, etc., of custom and ITSM forms and fields. 2. Unions the list of Region /Site Group / Site combinations found in active records of multiple application and configuration forms that are either custom or base. This will be your target data to update. The workflow to update is all Direct SQL. Warning – this update can still take hours depending on the amount of data you’ll have to change. Sorry for rambling, but hope it helps. Michelle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Neely, Leonard Sent: Monday, August 04, 2014 10:35 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** In 8.1 (probably earlier versions as well), you can take a look at data in the "DLD:SYS:DataWizAudit_Forms" form, which should give you a pretty good list of candidate forms to be updated. That may be a good starting point. HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: Monday, August 04, 2014 5:15 PM To: [email protected]<mailto:[email protected]> Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** Joe, The data wizard does use SQL to make all of it's updates (at least in 7.0.3, I haven't had to dig that deep in 8.1 yet). Take a look at the "DLD:SYS:DataWizardFormFields" form (and the other DLD:SYS.. forms). That should get you a good ways toward your goal. Sample screenshot: [Inline image 1] And one other thing that drive me bat-shtir-crazy... On the asset forms, the field labeled "Site", has a database name of "Building" (the field ID is 260000001, which is site name everywhere else). The kicker is that the field labeled "Site Group" has a database name of "Site" (and a field id that match Site Group every where else). Read that again, this time more carefully. :-) Now, that is only true for the AST forms - on the underlying CMDB forms, the label matches the database name. I hope that helps, Thad On Mon, Aug 4, 2014 at 3:55 PM, Joe D'Souza <[email protected]<mailto:[email protected]>> wrote: ** 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]<mailto:[email protected]>] On Behalf Of Rick Westbrock Sent: Monday, August 04, 2014 5:57 PM To: [email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of Lucero, Michelle Sent: Monday, August 04, 2014 2:55 PM To: [email protected]<mailto:[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 Group<https://communities.bmc.com/ideas/2663> Multiple Support Group Rename Capability<https://communities.bmc.com/ideas/2872> Ability to rename Organization and Department<https://communities.bmc.com/ideas/3133> Data Wizard to include currently excluded elements<https://communities.bmc.com/ideas/3042> Data Wizard – Improved Reporting<https://communities.bmc.com/ideas/6423> 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]<mailto:[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]<mailto:[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]<mailto:[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_ _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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
