Clear Secondary Site Installation
Run First Before Removing of SCCM Secondary Site.
Follow the below.
Run with in SCDB server management console SQL Query
use CM_IDC
declare @ServerName varchar(15)
set @ServerName='VCWCCT-VPN-MGT1.vpn.advtech.co.za'
delete from statusmessages where machinename=@ServerName
delete from Summarizer_Components where MachineName like '%'+@ServerName+'%'
delete from summarizer_sitesystem where sitesystem like '%'+@ServerName+'%'
delete from statusmessageinsstrs where insstrvalue like '%'+@ServerName+'%'
delete from sysreslist where servername=@ServerName
delete from sc_sysresuse where nalpath like '%'+@ServerName+'%'
Once Completed Follow the removal of Sccm Secondary site document in the Advtech Articals.
Once secondary site has been uninstalled all then proceed to clear the Inboxes on the Primary SCCM Site