Thanks Rache,
This didn't solve the issue. I need to read the content in the "msg" in 
"results" section 



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 <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...@googlegroups.com <javascript:> <mailto:
> ansible-project+unsubscr...@googlegroups.com <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?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/e951706a-a6bd-44c9-9df5-7308bde5d65a%40googlegroups.com.

Reply via email to