gistfile1.txt

---
- hosts: conformanceMain
  tasks:
  - name: Retrieve version from mysql
    no_log: True
    command: >
      mysql --user=root --password='{{mysqlpwd}}' db
      --batch
      --skip-column-names
      --execute="SELECT dbversion from SystemStatus"
    register: versionResult
    check_mode : no
    changed_when: False
  - name: Record Version Result
    ara_record:
      key: "versionResult"
      value: "{{ versionResult.stdout }}"
    register: version