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 <[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
> <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
> [email protected]
> <mailto:[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
> <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 [email protected].
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
