Re: Deleting data from CMDB
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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Deleting data from CMDB
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
Re: Deleting data from CMDB
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