That was reading the first msg
"msg": "All items completed"
We want to read the msg in results
"msg": [
[
"Revoke EXECUTE on UTL_FILE from TESTDBA;"
],
[
"Revoke EXECUTE on UTL_FILE from TSTSCH;"
]
]
On Friday, February 14, 2020 at 8:28:12 AM UTC-5, Stefan Hornburg (Racke)
wrote:
>
> On 2/14/20 2:10 PM, Anand Solomon wrote:
> > Thanks Rache,
> > This didn't solve the issue. I need to read the content in the "msg" in
> "results" section
> >
>
> What's the output when you run it in a loop as suggested?
>
> Regards
> Racke
>
> >
> >
> > On Friday, February 14, 2020 at 7:52:31 AM UTC-5, Stefan Hornburg
> (Racke) wrote:
> >
> > 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> <
> http://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>
> > <http://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>
> > <http://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] <javascript:> <mailto:
> [email protected] <javascript:>
> <javascript:>>.
> > > 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>
>
>
> > >
> > <
> https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com?utm_medium=email&utm_source=footer
>
> > <
> 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] <javascript:> <mailto:
> [email protected] <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/e951706a-a6bd-44c9-9df5-7308bde5d65a%40googlegroups.com
>
> > <
> https://groups.google.com/d/msgid/ansible-project/e951706a-a6bd-44c9-9df5-7308bde5d65a%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/96402ce4-7f82-4b2f-98d8-559ef6b83664%40googlegroups.com.
