The negative is that it is a manual approach and requires you to track what you want done. We needed to delete all assets at I present customer and 175K records took almost the whole day to delete. We had both People relationships and component relationships that were also deleted by deleting the Base Element record.
-----Original Message----- From: Veeral Oza <veer...@gmail.com> To: arslist@ARSLIST.ORG Sent: Wed, Sep 2, 2009 10:01 am Subject: Re: Deleting data from CMDB ** Hi Roger, ? Deletion is not a problem. I need a phased approach to delete the records chunk by chunk. If i delete it from BaseElement form, say 5000 records at a time, from the User tool, will all the relationships be deleted? ? Is this the right approach to do it? ? Regards, Veeral Oza On Wed, Sep 2, 2009 at 7:10 PM, Roger Justice <rjust2...@aol.com> wrote: ** You can use the BMC:BaseElement form if you are able to do a search with the specific qualification needed and do a delete from there. Both entries and all relationships are removed. -----Original Message----- From: Veeral Oza <veer...@gmail.com> To: arslist@ARSLIST.ORG Sent: Wed, Sep 2, 2009 9:30 am 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"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"