Re: Best way to delete records

2017-12-11 Thread Misi Mladoniczky
List [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Jason Miller Sent: December-08-17 1:00 PM To: ARSList Subject: Re: Best way to delete records Using RRR|Chive was my favorite way before LJ built his tool (I was his guinea pig, I mean tester

RE: Best way to delete records

2017-12-10 Thread Ben Chernys
problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Jason Miller Sent: December-08-17 1:00 PM To: ARSList Subject: Re: Best way to delete records

RE: Best way to delete records

2017-12-08 Thread Kelly Logan
o:arslist-boun...@arslist.org] *On Behalf Of *Kelly > Logan > *Sent:* Friday, December 08, 2017 12:05 > *To:* ARSList > *Subject:* Re: Best way to delete records > > > > I will check it out, LJ - thanks! > > > > On Fri, Dec 8, 2017 at 9:55 AM, LJ LongWing wrote: &

Re: Best way to delete records

2017-12-08 Thread Jason Miller
e data, you can simply delete the arx and subfolders. > > > > Thanks, > > Mike > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Kelly > Logan > *Sent:* Friday, December 08, 2017 12:05 > *To:* ARSList > *Subject:* Re: Best way to dele

RE: Best way to delete records

2017-12-08 Thread Mike Galat
. Thanks, Mike From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kelly Logan Sent: Friday, December 08, 2017 12:05 To: ARSList Subject: Re: Best way to delete records I will check it out, LJ - thanks! On Fri, Dec 8, 2017 at 9:55 AM, LJ LongWing mailto:lj.longw...@gmail.com>>

Re: Best way to delete records

2017-12-08 Thread Kelly Logan
I will check it out, LJ - thanks! On Fri, Dec 8, 2017 at 9:55 AM, LJ LongWing wrote: > Kelly, > I have a tool on my website (http://remedylegacy.com/ > tools/delete-requests/) that might do what you want. It's designed to > allow you to issue SQL Queries to identify records that need to be remo

Re: Best way to delete records

2017-12-08 Thread LJ LongWing
Kelly, I have a tool on my website (http://remedylegacy.com/tools/delete-requests/) that might do what you want. It's designed to allow you to issue SQL Queries to identify records that need to be removed, and then removes them via the api. You could in theory issue a query to say the task form a

Re: Best way to delete records

2017-12-08 Thread LJ LongWing
he was saying that SP3 P1 was supposed to have fixed the issue, I haven't done any research on the subject, but I was just suggesting that it's possible something related to it was fixed in SP4:) On Fri, Dec 8, 2017 at 8:15 AM, Thomas Miskiewicz wrote: > Does the SP4 offer some functionality

Re: Best way to delete records

2017-12-08 Thread Kelly Logan
We are working on a mass delete system as well, to remove a section of data belonging to one group. In addition to the concerns of the mass delete of a number of records, I am also looking for an efficient way to remove their child/transactional records as well. While the parent records can be foun

Re: Best way to delete records

2017-12-08 Thread Thomas Miskiewicz
Does the SP4 offer some functionality in this respect or what do you mean LJ? > On 8. Dec 2017, at 15:58, LJ LongWing wrote: > > Todd, > SP4 was released earlier this week, so you might want to give that a try. > >> On Fri, Dec 8, 2017 at 7:20 AM, Arner, Todd wrote: >> We have a form in Remedy

Re: Best way to delete records

2017-12-08 Thread LJ LongWing
Todd, SP4 was released earlier this week, so you might want to give that a try. On Fri, Dec 8, 2017 at 7:20 AM, Arner, Todd wrote: > We have a form in Remedy that we upload user access information into on a > bi-weekly basis. (There is about 300,000 rows) Prior to uploading the data > to the fo

RE: Best way to delete records

2017-12-08 Thread Pattabiraman, Vishal
Hi, I had worked on a requirement were we had to purge records. What we did was, take SQL logs and check all the dependent tables that gets affected. Create a SQL job that mimics the same functionality and include it in Scheduled job. The best part of this solution was, it was powerful and silen