Hi Vikes,
There should be a table in your vault store DB called "HoldSaveset"
This will show you all of the savesets on hold, and also the ArchivePointIdentity associated with each saveset.
If you look at the advanced tab when looking at the properties of the Archive in the Vault Administration Console, you will see the Archive ID - you can use this to write a query to see if there is anything int he HoldSaveset table from that archive.
Best Regards,
Frank