Thank you so very much Vlado
if I say
- 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;"
]
]
On Thursday, February 13, 2020 at 4:28:06 PM UTC-5, Vladimir Botka wrote:
>
>
> There is nothing to parse. The result is a dictionary with the attributes
> listed in "msg". Simply access the attributes of the dictionary to "take
> the
> values".
>
> On Thu, 13 Feb 2020 11:52:30 -0800 (PST)
> Anand Solomon <[email protected] <javascript:>> wrote:
>
> > I want to parse the json output and take the values
> > Here is the json debug output from the playbook I run,
> >
> > 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/b3c2dd89-b95e-4fe1-ba5e-1e5c083b9f51%40googlegroups.com.
