Thanks Vlado, I am new to Ansible. I tried "query_result.results' etc. But no luck. Will really appreciate and also will learn at the same time if you can help me crack the mystery.
Thanks for all your help. On Thursday, February 13, 2020 at 5:08:12 PM UTC-5, Vladimir Botka wrote: > > On Thu, 13 Feb 2020 13:33:32 -0800 (PST) > Anand Solomon <[email protected] <javascript:>> wrote: > > > - name: Display the query results > > debug: > > msg: "{{query_result.msg}} > > > > I get the below > > "msg": "All items completed" > > > > I couldn't get the below, what ever I put in my debug statement. Is > there > > is something I should do in order to get the below messages ? Thanks > again > > for your help. > > > > "msg": [ > > [ > > "Revoke EXECUTE on UTL_FILE from TESTDBA;" > > ], > > [ > > "Revoke EXECUTE on UTL_FILE from TSTSCH;" > > ] > > ] > > What you should do in order to get the above messages? Solve the mystery > and > find out how you get the "msg" below. Perhaps? > > > > > > TASK [Display the query results] > > > > > > > > ************************************************************************************************************ > > > > > > > > > ok: "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com] => { > > > > "msg": { > > > > "ansible_loop_var": "item", > > > > "changed": false, > > > > "failed": false, > > > > "invocation": { > > > > "module_args": { > > > > "host": > > > > "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com", > > > > "hostname": > > > > "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com", > > > > "mode": "normal", > > > > "password": > > > "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER", > > > > "port": "1521", > > > > "script": null, > > > > "service_name": "tstdb", > > > > "sql": "select 'Revoke ' || privilege || ' > on > > > > UTL_FILE from ' || grantee || ';' from dba_tab_privs where > > > > table_name='UTL_FILE' and grantee not like 'APEX%' and grantee != > > > 'CTXSYS' > > > > and grantee != 'DBSNMP' order by grantee;", > > > > "user": "SYSDBA", > > > > "username": "SYSDBA" > > > > } > > > > }, > > > > "item": { > > > > "key": "Script1", > > > > "value": "select 'Revoke ' || privilege || ' on > > > > UTL_FILE from ' || grantee || ';' from dba_tab_privs where > > > > table_name='UTL_FILE' and grantee not like 'APEX%' and grantee != > > > 'CTXSYS' > > > > and grantee != 'DBSNMP' and grantee != 'DMSYS' and grantee != > 'EXFSYS' > > > and > > > > grantee != 'MDSYS' order by grantee;" > > > > }, > > > > "msg": [ > > > > [ > > > > "Revoke EXECUTE on UTL_FILE from TESTDBA;" > > > > ], > > > > [ > > > > "Revoke EXECUTE on UTL_FILE from TSTSCH;" > > > > ] > > > > ] > > > > } > > > > ] > > > > } > > > > } > > > > ------------------------------------------------------- > > > > I just want to get extract the below value and pass it on to my > Jinja > > > > template. > > > > > > > > [ > > > > "Revoke EXECUTE on UTL_FILE from TESTDBA;" > > > > ], > > > > [ > > > > "Revoke EXECUTE on UTL_FILE from TSTSCH;" > > > > ] > > > > > > > > Here is my Jinja template > > > > > > > > - name: Generate Revoke Statement > > > > copy: > > > > dest: > > > /home/ansible/Playbooks/{{sname}}/sql/{{item.key}}_revoke.sql > > > > content: | > > > > spool > /home/ansible/Playbooks/{{sname}}/log/{{item.key}}.log > > > > {% for line in query_result | flatten %} > > > > {{ line }} > > > > {% endfor %} > > > > spool off; > > > > delegate_to: localhost > > > > connection: local > > > > loop: "{{ scripts|dict2items }}" > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com.
