Deleting Archives with 0 items
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?