Skip to content

Unable to see column names in data  #4

@thedarkmucko

Description

@thedarkmucko

After running a playbook and returning data payload I cannot see as per documentation the column names

`cat tablespace.yaml

  • hosts: localhost
    gather_facts: no
    vars:
    conn_sysdba: &conn_sysdba
    hostname: "{{ hostname }}"
    port: 1521
    service_name: "{{ service }}"
    user: sys
    mode: sysdba
    password: "{{ sys_password }}"
    module_defaults:
    ari_stark.ansible_oracle_modules.oracle_sql: *conn_sysdba

    tasks:

    • name: Query DB
      ari_stark.ansible_oracle_modules.oracle_sql:
      sql: "select file_id, bytes, maxbytes from dba_data_files where tablespace_name='SYSAUX'"
      register: output

    • name: Return values
      debug:
      msg: "{{ output.data }}"`

it returns only the values.

`ansible-playbook tablespace.yaml -e "hostname=myhost service=orcl sys_password='orcl'"
[WARNING]: provided hosts list is empty, only localhost is available. Note that the implicit localhost does not match 'all'

PLAY [localhost] *******************************************************************************************************************************************************

TASK [Query DB] ********************************************************************************************************************************************************
ok: [localhost]

TASK [Return values] ***************************************************************************************************************************************************
ok: [localhost] => {
"msg": [
[
3,
1541406720,
34359721984
]
]
}

PLAY RECAP *************************************************************************************************************************************************************
localhost : ok=2 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
`

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions