You can still use a recon job but add a qualification group to select an appropriate set of entries that can be deleted in a single job. You would then just have to go back and update the qualification group and run the job again, etc., until you've deleted the entire set.
Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Veeral Oza Sent: Wednesday, September 02, 2009 7:30 AM To: arslist@ARSLIST.ORG Subject: Deleting data from CMDB ** Hi All, There are 2 custom classes along with their Asset views being created. There are more than 1 million records in each of these classes. Now the data needs to be deleted. However all of these records cannot be deleted by a single recon job because of some performance issue on the server we had in the past. The records need to be deleted chunk by chunk. Can anyone please suggest me any approach on how to delete data in phases? Regards, Veeral Oza _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"