Follow

Anonymize Visitors

WHAT

Pronestor Visitor does not per default delete or anonymize visitor information.

This article will explain how this can be performed - using a scheduled stored procedure.

The stored procedure can be configured to anonymize visitors back in time - with a parameters that states how old a badge/visit should be before it is anonymized. 

We will not remove/delete activities on visits - but will overwrite the visitors name and email with a "f" for first name and "l" as last name and email as "f_123@mail.mail" 

 

REQUIREMENTS

Knowledge of MSSQL Server Management Studio - and access to create stored procedures and jobs on SQL Server.

 

HOW

The steps to be performed are:

  • Create a stored procedure ([AnonymizeVistors])
  • Create a scheduled job

Creating the stored procedure

Run the attached script on the database for Pronestor.


When performed - a stored procedure with the name of "AnonymizeVistors" should appear within Programmability->Stored Procedures

 

Creating a scheduled job

  • Open SQL Server Agent
  • Open jobs
  • Right click and choose New Job
    • Within "Steps" - click "New"
    • Give it a name - ex. "AnonymizeVisitor"
    • In Database choose the Pronestor database
    • In Command - type (set daysbackintime for from when visitors should be anonymized)

      EXEC [dbo].[AnonymizeVistors]
      @daysbackintime = 120
      GO
    • Go to "Schedules" and configure it to run everynight

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk