3 - A script to do this in Meta-Update takes less than 5 minutes to make.
[Main] ArgNm = arg PrmReq = 1, Usage: SthMupd $CTL, ScriptFx$ Do -p "'Short Description' LIKE \"%text%\" [Do] Query = WL, HPD:WorkLog, Attach1 != $NULL$ or Attach2 != $NULL$ or Attach3 != $NULL and ($Arg, qry$) Update = WL Assign = asg [asg] Attach1 = $NULL$ Attach2 = $NULL$ Attach3 = $NULL$ Trial licenses are free and fully functional. Note that I have not verified the field names above. Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, LJ CTR MDA/IC Sent: August-06-12 08:49 To: [email protected] Subject: Re: removing attachments Marcelo, I have two solutions that come to mind 1 - Export affected records to ARX with the request ID and the attachment field, update the ARX to not have an attachment defined, and re-import the arx, this should effectively eliminate the attachments from those records 2 - Programmatically (Java API maybe) take a list of request id's and set the attachment field to null -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Martinez, Marcelo A Sent: Monday, August 06, 2012 8:39 AM To: [email protected] Subject: removing attachments ** I have a request from one of our IT teams to remove attachments from a large number of incident tickets (I'm sure you can imagine why...). My question is, is there a systematic way of removing these attachments? ARS7.1/ITSM 7.0.03 Win2003/SQL2005 Thanks, Marcelo _attend WWRUG12 <http://www.wwrug.com> www.wwrug.com ARSlist: "Where the Answers Are"_ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org attend wwrug12 <http://www.wwrug12.com> www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image002.jpg>>
smime.p7s
Description: S/MIME cryptographic signature
