Purge Entries in SQL DB of Pcounter
Steps to Purge selected data from Pcounter SQL DB
1. Login to Pcounter DB server using DBA rights
2. Access SQL Management studio and navigate to Pcounter DB
3. Click on run query and execute below query to find out/list unique value.
SELECT TOP 1000 [pk]
,[submission_timestamp]
,[submission_time]
,[job_timestamp]
,[job_time]
,[username]
,[domain]
,[document]
,[server]
,[workstation]
,[printer]
,[client_code]
,[subcode]
,[auto_client_code]
,[group_name]
,[amount]
,[account_balance]
,[low_balance_limit]
,[allow_unlimited_credit]
,[free_quota]
,[color_quota]
,[directory_attribute]
,[ou]
,[size_bytes]
,[total_pages]
,[total_cost]
,[non_billable_cost]
,[non_billable_job]
,[driver_type]
,[job_type]
,[num_job_copies]
,[paper_size]
,[media_type]
,[is_duplex]
,[is_color]
,[med_color_pages]
,[color_cost]
,[color_pages]
,[pages_per_sheet]
,[fax_minutes]
,[fax_number]
,[staple]
,[booklet]
,[spooler_job_id]
,[printer_job_id]
,[transaction_id]
,[payment_type]
,[disbursement]
,[print_quality]
,[toner_usage]
,[comment_1]
,[option_1]
,[option_2]
,[exported_to_log]
,[pwr_convert]
,[log_convert]
,[custom1]
,[custom2]
,[custom3]
,[custom4]
,[ts]
,[mark]
4. Once unique value is found or desired data is found which needs to be purged, note the PK value and execute below command to purge that entry.
USE [pcounter]
GO
DELETE FROM [dbo].[job_records]
where pk =
GO
5. Post this step, clear the same entry from CSV file of Pcounter as well.
6. With this steap data is successfully purged, You can check generating report and the purged data should not be seen in the report.
7. If you are still facing any problems Please raise support ticket on below link: https://support.foresightho.com/portal/home