SQL Query to remove the old entries of endpoint status.

SQL Query to remove the old entries of endpoint status.

Below is the SQL query to delete the Old Endpoint status entries from the DLP console.

DELETE FROM PA_DYNAMIC_STATUS_PROPS WHERE dynamic_status_id IN
(SELECT ID FROM PA_DYNAMIC_STATUS WHERE UPDATE_DATE < '2020-10-01')
DELETE FROM PA_DYNAMIC_STATUS WHERE UPDATE_DATE < '2020-10-01'

Above query will delete the endpoint status entries before 1st OCT.
You can modify the data as per you need. Ensure format is correct.  

    • Related Articles

    • Uninstalling Endpoint Clients Through Command Line

      Problem What is the proper procedure to uninstall the Endpoint through the command line as mentioned in the Endpoint deployment documentation? Resolution The command to remove an Endpoint takes the following format:   msiexec /x "{ProductCode}" /qn ...

    • HTTP Status 404" Error Occurs within the Forcepoint Security Manager

      Forcepoint Web Security: Issue : "HTTP Status 404" Error Occurs within the Forcepoint Security Manager. Action taken: 1. Observed that the issue occurred post patch update on the server. 2. Stopped the services on the server in below order and ...

    • DLP endpoint applications monitoring

      https://www.websense.com/content/support/library/endpoint/v85/dlp_apps/Endpoint%20apps.pdf

    • Forcepoint Cloud Web Endpoint Deployment

      Table of Contents 1. Creating Endpoint package for deploying Forcepoint Cloud Endpoint. 2. Installing the endpoint from Windows 3. Uninstalling the endpoint from Windows (Classic Proxy Connect and Direct Connect) 4. Stop and Start the endpoint client ...

    • Hybrid endpoint installation guide

      https://partners.forcepoint.com/s/article/How-do-I-install-Hybrid-web-endpoint-client