Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Deleting Archives with 0 items

Created: 03 Jul 2013 | 3 comments
FBD's picture

Due a broken administrative process many of our users have multiple vaults created.  We wish to tidy these up by deleting the vaults contain 0 items and 0 item size.  However in the Admin Console the vaults listing show there have the same vault names.   I managed to use a SQL query to output list of vault IDs which are empty contain 0 items and 0 item size.  It's a long list and too resource intensive to use the Admin Console to delete them as vault IDs is not displayed in the vault listing, I must view the vault properties then go to Advanced tab.

Is there any way I can delete a vault based on the vault ID, a store procedure?

Operating Systems:

Comments 3 CommentsJump to latest comment

MichelZ's picture

Hey, that's an easy one... :)

update Archive set ArchiveStatus = 4 where RootIdentity in (select RootIdentity from Root where vaultentryid in (
'12D5ACB7D59979E4C84122567CFAFBAA51110000ABCDEF',
'1G74BAF79E4C84122567CFAFBAA51110000ABCDEF'
))

 Just list all your vault id's there...

Be careful however to have really selected the proper vault id's

AndrewB's picture

please please please perform a FULL BACKUP of the entire EV system and all its components before you attempt to run this.

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

FBD's picture

Thanks Guys, I'll give your response a try and will be careful.