Our auditData table is growing and growing. I was able to delete some data using the powershell script:
foreach ($site in get-spsite -Limit ALL)
Write-host 'Deleting from ' $site
The problem I have is there seems to be lots of garbage still stored in the table. Sites that have been long deleted from SharePoint are still stored in the table.
How do I delete these short of writing a delete statement in the DB itself?