ansible json_query help | NetApp | Page 1

lilac badger May 16, 2024, 2:00 PM

#

Hi all, bit of a newbie to json out etc, anyone help me with command to get these onto one line each, as in one field from each group, many thanks

TASK [Display all devices] **********************************************************************************************************************************
ok: [localhost] => {
"msg": [
[
"MIATFLADQH004.edg.centurylink.net (fc:96:43:37:e5:40)",
"MIATFLADQH004.edg.centurylink.net (fc:96:43:37:e5:40)",
"LONDENEHQH003.edg.centurylink.net (00:cc:34:af:10:00)",
"LONDENEHQH003.edg.centurylink.net (00:cc:34:af:10:00)"
],
[
"MIATFLADSN0201SNC02",
"MIATFLADSN0201SNC01",
"LONDENEHSN0201SNC01",
"LONDENEHSN0201SNC02"
],
[
"et-0/0/2",
"et-0/0/0",
"et-0/0/0",
"et-0/0/2"
],
[
"e1a",
"e1a",
"e1a",
"e1a"
]
]
}

my msg params are as follows;

name: Display all devices
debug:
msg: "{{ echo | community.general.json_query('[results[].msg.records[].discovered_device,results[].msg.records[].node,results[].msg.records[].interface,results[].msg.records[].port]' ) }}"

native thorn May 16, 2024, 2:18 PM

#

Can you give a bit more context what you are trying to achieve?

lilac badger May 16, 2024, 3:59 PM

#

yes sorry, i didnt think I explained it well

#

MIATFLADSN0201SNC02, et-0/0/2, e1a

#

would like to see it in this format for each entry a line of results

lilac badger May 16, 2024, 4:01 PM

#

native thorn Can you give a bit more context what you are trying to achieve?

basically single line of multiple params, the above output would result in 4 lines

#

i can do it through a jq statement from a json file but would like to get it straight from the playbook

#

jq -r '.plays[].tasks[].hosts.localhost.results[].msg.records[]| [.discovered_device,.interface,.node,.port]|@tsv' device.json
MIATFLADQH004.edg.centurylink.net (fc:96:43:37:e5:40) et-0/0/2 MIATFLADSN0201SNC02 e1a
MIATFLADQH004.edg.centurylink.net (fc:96:43:37:e5:40) et-0/0/0 MIATFLADSN0201SNC01 e1a
LONDENEHQH003.edg.centurylink.net (00:cc:34:af:10:00) et-0/0/0 LONDENEHSN0201SNC01 e1a
LONDENEHQH003.edg.centurylink.net (00:cc:34:af:10:00) et-0/0/2 LONDENEHSN0201SNC02 e1a

acoustic tapir May 16, 2024, 4:20 PM

#

your playbook prints json. If you don't want to print json, you need to change the debug: part in your playbook. loop over the number of elements and do something like echo | results[].msg.records[i].node, results[].msg.records[i].port or something similar

lilac badger May 16, 2024, 4:22 PM

#

acoustic tapir your playbook prints json. If you don't want to print json, you need to change t...

I am happy with it printing json, I am just having problems translating the working jq statemnet into a debug msg one.

acoustic tapir May 16, 2024, 5:24 PM

#

yeah, as I said, I think you need to put the debug statement in a loop that iterates over the number of entries, and then print each entry by itself

#

I don't think you can do elaborate json transforms in the playbook itself

subtle patio May 16, 2024, 8:05 PM

#

acoustic tapir yeah, as I said, I think you need to put the `debug` statement in a loop that it...

Thanks,as I said bit of a newbie to this.

subtle patio May 16, 2024, 8:27 PM

#

Thinking cap back on

acoustic tapir May 16, 2024, 9:30 PM

#

I think you do something like with_sequence: start=1 end={{ something }} and then use {{ item }} in your debug statement for the index in the array... the something I'm not sure of, something about the length of results[].msg.records but not sure about the correct syntax there

#ansible json_query help