Assuming you have the data from your load balancer stored in a registered
variable you could run copy to write the file to disk on the controller,
and then a shell task to use 'tr' command to convert the whitespace, tabs
and : to a comma, and then you would have .csv file you could process.
Something like the following (which I have NOT tested):
- name: copy loadbalancer output to disk
copy:
content: "{{ output_from_load_balancer }}"
dest: /tmp/load-balancer-raw
delegate_to: localhost
- name: make raw loadbalancer into csv
shell: cat /tmp/load-balancer-raw | tr [:blank:] , | tr \: , > /tmp/load-
balancer-raw
delegate_to: localhost
Also worth investigating are the lookups that ansible has. See
https://docs.ansible.com/ansible/latest/plugins/lookup.html You might want
to use https://docs.ansible.com/ansible/latest/plugins/lookup/csvfile.html
to load the csv for further processing.
Also worth exploring to see if you can get more structured data out of your
load balancer, preferably json or yaml, both of which are much easier to
then use within ansible.
Hope this helps,
Jon
On Thursday, June 13, 2019 at 4:19:49 PM UTC+1, Kethan R wrote:
>
> Recently i wrote a playbook to pull the data from Loadbalancer server.
> Output is saving in 1st row of each column.
> output has : data separated with spaces, Tabs and :
> I want to apply delimit option only on tabs spaces and : which i am not
> able to. Kindly suggest if you have any solution.
>
>
> EX:
> xxx::Node: IP.ip.ip.ip (ip.ip.ip.ip)
> ------------------------------------------
> Status
> Availability : available
> State : enabled
> Reason : Node address is available
> Monitor : /Common/icmp (default node monitor)
> Monitor Status : up
> Session Status : enabled
> Traffic ServerSide General
> Bits In 0 -
> Bits Out 0 -
> Packets In 0 -
> Packets Out 0 -
> Current Connections 0 -
> Maximum Connections 0 -
> Total Connections 0 -
> Total Requests - 0
> Current Sessions - 0
>
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/09ca3d78-e6a0-4c39-996d-96f16ce3d125%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
