Video Screencast Help

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.