CSV file formatting using ansible

[Kethan R]

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

[J Hawkesworth]

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

[Kethan R]

I already used it, but still im getting output in this format which i cannot filter it ...

  tasks:

    - name: print date

      set_fact: temp="{{lookup('pipe','date \"+%Y-%m-%d-%H-%M\"')}}"

    - name: creates file

      file: 

        path: "/tmp/loadbalancer_{{ temp }}.csv"

        state: touch

    - name: creates file

      file: 

        path: "/tmp/loadbalancer_{{ temp }}.txt"

        state: touch

    - name: print date

      set_fact: files="loadbalancer_{{ temp }}.csv"

    - name: Run Health Checks on LoadBalancer servers

      bigip_command:

        commands:

          - show sys version

          - show sys service | grep tmm

          - show ltm

          - show sys memory

        provider:

          server: xxxx.xxxx

          password: "{{ xxxxx }}"

          user: "{{ xxxxx }}"

          validate_certs: no    

      register: version

      delegate_to: localhost

    - name: Updating variable

      copy: content="{{ version.stdout_lines | to_nice_yaml }}" dest="/tmp/loadbalancer_{{ temp }}.txt"

    - name: Parse the CSV file

      shell: 

        cmd: |

          cp -f "/tmp/loadbalancer_{{ temp }}.txt" /tmp/temp.txt

          cat /tmp/temp.txt| tr -s '[:blank:]' ' ' > "/tmp/loadbalancer_{{ temp }}.csv" 

[J Hawkesworth]

Unless you have a very old F5, you'd probably be better off gathering facts from the f5 - the console output looks really hard to parse.  https://docs.ansible.com/ansible/latest/modules/bigip_device_facts_module.html