---
- name: Playbook to find the snowflakes having manage_server_db set
  hosts: all
  gather_facts: false
  tasks:
    - name: Get plesk info
      plesk_info:
      register: plsk
    - name: On plesk server get me the state
      when: plsk.plesk_found
      ansible.builtin.shell: |
        set -o pipefail
        plesk db -N -e "SELECT p.value FROM Permissions p LEFT JOIN clients c ON c.perm_id = p.id WHERE p.permission = 'manage_server_db' AND c.id IS NOT NULL"
      args:
        executable: /bin/bash
      register: snowflake
      changed_when: false
    - name: If snowflake make flag
      when: snowflake.stdout == 'true'
      ansible.builtin.debug:
        msg: "We have a snowflakes"