Hi All,
I am currently working on a playbook where in i need to write the output of
SQL statement into a file .
I have 4 SQL statement and 4 hosts thus want the output in such a way that:
1st host
SQL1 output
SQL2 Output
SQL3 output
SQL4 Output
2nd host ... and so on
Currently i am using this code:
- name: trying something new
lineinfile:
line: "{{ item }}"
path: "{{ VlclFile }}"
insertafter: EOF
loop: "{{ testing }}"
delegate_to: localhost
which gives output in the format as i want for eg:
xxx:xxVC1:user: control_file_record_keep_time integer 365
yyy:yyy:user: control_file_record_keep_time integer 365
but the output comes in a random order and thus statement 1 output for host
1 is followed by statement 1 for host 2 and not statement 2 of host 1.
Anyone can help me with this .
Other block of code which i tried is as followed:
#- name: Add output of task for getting content to the local
# local_action:
# module: blockinfile
# path: "{{ VlclFile }}"
# marker: ""
# state: present
# block: "{{ hostvars[item]['testing']}}"
# insertafter: EOF
# run_once: True
# with_items:
# - "{{ play_hosts }}"
but in this its giving me output in the form of a list and not items per se
eg:
host1
[a: value 1,b:value2]
host2
[a: value 1,b:value2]
--
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/ecc3dfa5-b963-4cc4-9976-acc28196f4fbn%40googlegroups.com.
