informatique-cdc/ansible-role-win_sqlserver_ceip

Ansible module to enable or disable the Customer Experience Improvement Program (CEIP) for SQL Server on Windows-based systems.

win_sqlserver_ceip - Enables or disables the CEIP for SQL Server

Synopsis

• Ansible module to enable or disable the Customer Experience Improvement Program (CEIP) for SQL Server on Windows-based systems.
• This module examines all specific registry locations and services where a value indicates that the CEIP is enabled.
• Before SQL Server 2016, you had the possibility to check the case "Send Windows and SQL Server Error Reports...." during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP).
• In SQL Server 2016, after the installation, all of the CEIP are automatically turned on.

Parameters

Parameter	Choices/Defaults	Comments
state string / required	Choices: present absent	Specifies the state needed for the Customer Experience Improvement Program (CEIP) for SQL Server.

Examples

---
- hosts: all

  roles:
      - win_sqlserver_ceip

  tasks:

      - name: Disable all CEIP services
        win_sqlserver_ceip:
          state: absent

      - name: Enable all CEIP services
        win_sqlserver_ceip:
          state: present

Notes

• This module uses some partial or full parts of open source functions in PowerShell belows.
• SQL Server Tips - Deactivate the Customer Experience Improvement (https://blog.dbi-services.com/sql-server-tips-deactivate-the-customer-experience-improvement-program-ceip/)
• How to turn off telemetry for SQL 2016 (https://stackoverflow.com/questions/43548794/how-to-turn-off-telemetry-for-sql-2016)

Authors

• Stéphane Bilqué (@sbilque)

License

This project is licensed under the Apache 2.0 License.

See LICENSE to see the full text.