We're not supposed to do this since BMC doesn't support it, but word on the streets is that my uncle's brother's son would run this against BMC_CORE_BMC_BaseElement and add a WHERE clause looking for ClassId = 'BMC_MONITOR' to avoid the potential join form issues that could arise especially if you are going the direct sql route.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Garrison, Sean (Norcross) Sent: Wednesday, October 17, 2012 2:05 PM To: [email protected] Subject: Re: Updates via Import into Asset ** Direct SQL would work great :) UPDATE AST_MONITOR SET SERIAL_NUMBER = replace(SERIAL_NUMBER, '-',''); Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Lisa Kemes Sent: Wednesday, October 17, 2012 2:09 PM To: [email protected]<mailto:[email protected]> Subject: Updates via Import into Asset ** Hello all!! :) We import assets into the AST:XXX forms (for example AST:Monitor). We do not use AIE. Customer imported records into the AST:Monitor form and put hyphens in the serial number and would like to take them out (the hyphens). We exported the data into a .csv file, cleared out the hyphens and now would like to import the updates. Is there an easy way to do this? I tried doing an import using the data import tool (using the Update Old Record with New Record's Data option under "Handle Duplicate Request IDs by") and it wants to add this to the database, not update it. Any ideas? ARS 7.5 ITSM 7.5 Windows 2003 SQL Thanks! Lisa _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
