On 2/14/20 1:31 PM, Anand Solomon wrote: > 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.
Amand, you need to use the loop in the debug task as well:
- name: Display the query results
debug:
msg: "{{query_result.msg}}
loop: "{{ scripts|dict2items }}"
Regards
Racke
>
> 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 <anand....@gmail.com <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
> <http://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
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>",
> > > > "hostname":
> > > > "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://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
> ansible-project+unsubscr...@googlegroups.com
> <mailto:ansible-project+unsubscr...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 ansible-project+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/971c12e8-7977-3885-0ff1-f04fa297fcd0%40linuxia.de.
signature.asc
Description: OpenPGP digital signature
