IT Management Suite

hi

We plan to purge our full symantec_CMDB data base.

We purge as given with default configuration by changing 0 days but after purge now data purging too much slowly.

any other way so that we can purge full database quickly wihtout loosing configuration

Hi

You can mass delete object by using the following SQL Query, This will place all computers into the itemTodelete table. Running a daily task will begin deleting the items.

insert into ItemToDelete (guid)
select guid from vcomputer

This will take some time, but you can follow the progress by just checking how many objects that are left in the table

ItemToDelete

Torb

Hello,

After purge,maybe you can shrink the database(If auto shrink option is not enabled) to improve SQL performance.

Also, please go through the below article before shrinking the database:

http://msdn.microsoft.com/en-us/library/ms189035.aspx

Please take a backup of your CMDB database, before performing database shrinking operation.

I hope that this resolution will work for you.

Thanks,

~Abhishek