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: [image: 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]> 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]] *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 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] <[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] <[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] <[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_ _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"
