sql2016_find_version.yml

- name: Install SQL 2016
  hosts: all

  tasks:
    - name: look for instance name
      win_reg_stat:
        path: HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server
      register: sql_server_instance_names

    - name: fail if no instance name found
      fail:
        msg: 'could not find MSSQL instance name'
      when: sql_server_instance_names.properties.InstalledInstances.value is undefined or sql_server_instance_names.properties.InstalledInstances.value | length == 0

    - name: find instance properties
      win_reg_stat:
        path: HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
        name: "{{ item }}"
      register: sql_server_instance_name_properties
      loop: "{{ sql_server_instance_names.properties.InstalledInstances.value }}"

    - name: find instance information
      win_reg_stat:
        path: HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\{{ item.value }}\Setup
      register: sql_server_instance_information
      loop: "{{ sql_server_instance_name_properties.results }}"

    - name: set version information
      set_fact:
        sql_server_edition: "{{ sql_server_instance_information.results[0].properties.Edition.value }}"
        sql_server_version: "{{ sql_server_instance_information.results[0].properties.Version.value }}"

    - name: show sql server version
      debug:
        msg: "SQL server: {{ sql_server_edition }} - {{ sql_server_version }}"