Maintenance

Connected to: WebScraperDb_CNDS

Clear System Logs Only

Deletes all entries from ScrapingLogs and resets the ID counter. Jobs, reports and credentials are not affected.

Clear API Login Logs Only

Deletes all entries from ApiLoginLogs and resets the ID counter. Everything else is not affected.

CLEAR ALL — Jobs, Reports, Logs & Hangfire Queue
This is irreversible. The following will be permanently deleted from WebScraperDb_CNDS:
  • All Scraping Jobs
  • All Extracted Reports
  • All Scraping Logs
  • All API Login Logs
  • All Hangfire queued/scheduled jobs
Credentials and WebsiteConfigs are preserved.

To confirm, type the exact database name WebScraperDb_CNDS in the box below, then click Clear All.

The button activates only when the database name is typed exactly.
SQL Script being executed 
-- Database: WebScraperDb_CNDS
BEGIN TRANSACTION;

DELETE FROM [ApiLoginLogs];
DELETE FROM [ScrapingLogs];
DELETE FROM [ExtractedReports];
DELETE FROM [ScrapingJobs];

DBCC CHECKIDENT ('[ApiLoginLogs]',    RESEED, 0);
DBCC CHECKIDENT ('[ScrapingLogs]',    RESEED, 0);
DBCC CHECKIDENT ('[ExtractedReports]',RESEED, 0);
DBCC CHECKIDENT ('[ScrapingJobs]',    RESEED, 0);

DELETE FROM [HangFire].[JobParameter];
DELETE FROM [HangFire].[State];
DELETE FROM [HangFire].[Job];
DELETE FROM [HangFire].[List];
DELETE FROM [HangFire].[Set];
DELETE FROM [HangFire].[Hash];
DELETE FROM [HangFire].[Counter];
DELETE FROM [HangFire].[AggregatedCounter];
DELETE FROM [HangFire].[Server];

COMMIT TRANSACTION;