Hi Alex,
Todd's solution works for me -
```
- name: print query result
debug:
msg: "{{ cacti_query.query_result[0] | map(attribute='hostname') }}"
```
```
TASK [print query result]
****************************************************************
task path: /root/mysql.yml:13
ok: [localhost] => {
"msg": [
"host_A",
"host_B",
"host_C",
"host_D"
]
}
```
On Thu, Jul 20, 2023 at 11:48 AM Todd Lewis <[email protected]> wrote:
> You'd need to show what's registered to cacti_query. It appears to be
> saying it doesn't contain anything named "hostname". It may not contain "
> query_result" either. Like I said before, it makes me question what's
> registered by your query *in that particular run*. Stick another debug
> task before that showing what's being registered by the db query task.
> On Thursday, July 20, 2023 at 2:10:11 PM UTC-4 Alex Wanderley wrote:
>
>> Yes, I'm afraid we indeed are still in a transition process...
>>
>> But you did help a lot: I didn't think straight and did not try to run
>> the same playbook on one of our future servers, running 2.14.3.
>>
>> However, it did not like the map solution.
>>
>> msg: "{{ cacti_query.query_result | map(attribute='hostname') }}"
>>
>> Is giving me:
>> "The task includes an option with an undefined variable. The error was:
>> list object has no element AnsibleUndefined(hint=None, obj=missing,
>> name='hostname').
>>
>> Could you give one last insight about that?
>> (I have no intention to drag this out for longer and keep bothering our
>> list with something that I understand is simple but I don't have yet the
>> knowledge to solve.)
>>
>> Regards,
>>
>> Alex
>>
>> On Thu, Jul 20, 2023 at 11:17 AM Todd Lewis <[email protected]> wrote:
>>
>>> That's twice this morning a working solution was inapplicable b/c
>>> someone was still running Ansible 2.9. I know people don't always get to
>>> pick the version of whatever software they have to use because of factors
>>> beyond their control. We were stuck on 2.9 far longer than we would have
>>> liked.
>>>
>>> However, if it's at all possible, IMO, any time spent trying to make
>>> stuff work under 2.9 *rather than moving to a later version* is time
>>> seriously wasted. There have been so very many improvements.
>>>
>>> Adding "| list" as you did should have been enough, though. It makes me
>>> wonder what was in your registered result on that particular run.
>>>
>>> Sorry I can't offer any actionable suggestions. Good luck,
>>> --
>>> Todd
>>>
>>> On Thursday, July 20, 2023 at 12:43:50 PM UTC-4 Alex Wanderley wrote:
>>>
>>>> Hi Todd,
>>>>
>>>> Thanks for helping...
>>>>
>>>> {{ cacti_query.query_result | map(attribute='hostname') }}
>>>> Gave me the output:
>>>> "msg": "<generator object do_map at 0x7fe0c4e9f2b0>"
>>>>
>>>> Looking around I found that {{ cacti_query.query_result |
>>>> map(attribute='hostname') | list }} would be the solution for the
>>>> message above, but instead I got:
>>>> "msg": "[AnsibleUndefined]"
>>>>
>>>> Would that possibly be caused by Ansible/Python versions?
>>>> We have Ansible 2.9.7 and Python 3.6.8.
>>>>
>>>> Regards,
>>>>
>>>> Alex
>>>>
>>>> On Thu, Jul 20, 2023 at 9:52 AM Todd Lewis <[email protected]> wrote:
>>>>
>>>>> {{ cacti_query.query_result | map(attribute='hostname') }}
>>>>>
>>>>>
>>>>> On 7/20/23 11:42 AM, Alex Wanderley wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> I need to collect some hostnames from a MariaDB database but don't
>>>>> know exactly how to properly parse the result of my query... Could
>>>>> somebody
>>>>> help?
>>>>>
>>>>> This how the tasks look like:
>>>>>
>>>>> - name: Collect devices in down state
>>>>> community.mysql.mysql_query:
>>>>> login_db: cacti
>>>>> query: SELECT hostname FROM host WHERE status=1
>>>>> login_unix_socket: /run/mysqld/mysqld.sock
>>>>> register: cacti_query
>>>>>
>>>>> - name: print query result
>>>>> debug:
>>>>> msg: "{{ cacti_query.query_result }}"
>>>>>
>>>>> And this is the output:
>>>>>
>>>>> ok: [xxxxxxxxx] => {
>>>>> "msg": [
>>>>> [
>>>>> {
>>>>> "hostname": "host_A"
>>>>> },
>>>>> {
>>>>> "hostname": "host_B"
>>>>> },
>>>>> {
>>>>> "hostname": "host_C"
>>>>> },
>>>>> {
>>>>> "hostname": "host_D"
>>>>> }
>>>>> ]
>>>>> ]
>>>>> }
>>>>>
>>>>> How could I create a list with just the actual host names "host_A
>>>>> host_*B * host_C host_D" to be used/referenced in a loop further
>>>>> down my playbook?
>>>>>
>>>>> Thanks a lot,
>>>>>
>>>>> Alex
>>>>>
>>>>>
>>>>> --
>>>>> 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/7cbbf374-1d36-1fa6-c7ed-15b133d656f6%40gmail.com
>>>>> <https://groups.google.com/d/msgid/ansible-project/7cbbf374-1d36-1fa6-c7ed-15b133d656f6%40gmail.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> [image: Edmonton_sig_RGB_S.jpg]
>>>>
>>>> Alex Wanderley
>>>>
>>>> Application and Infrastructure Analyst II
>>>> Acting Team Lead Server Solutions & Automation
>>>>
>>>> Financial and Corporate Services | Open City and Technology
>>>>
>>>>
>>>>
>>>> 780-496-4156 <(780)%20496-4156> Office
>>>>
>>>> 780-819-0273 <(780)%20819-0273> Mobile
>>>>
>>>>
>>>>
>>>> City of Edmonton
>>>>
>>>> Century Place, 19th Floor
>>>>
>>>> 9803 102A Avenue NW
>>>>
>>>> Edmonton AB, T5J 3A3
>>>>
>>>>
>>>>
>>>> All information contained in this email post is proprietary to the City
>>>> of Edmonton, confidential and intended only for the addressed recipient. If
>>>> you have received this post in error, please disregard the contents, inform
>>>> the sender of the misdirection, and remove it from your system. The
>>>> copying, dissemination or distribution of this email, if misdirected, is
>>>> strictly prohibited.
>>>>
>>>> *The contents of this message and any attachment(s) are confidential,
>>>> proprietary to the City of Edmonton, and are intended only for the
>>>> addressed recipient. If you have received this in error, please disregard
>>>> the contents, inform the sender of the misdirection, and remove it from
>>>> your system. The copying, dissemination, or distribution of this message,
>>>> if misdirected, is strictly prohibited.*
>>>
>>> --
>>> 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/7c145dfa-5d9f-44b6-a7b1-4020d039a00fn%40googlegroups.com
>>> <https://groups.google.com/d/msgid/ansible-project/7c145dfa-5d9f-44b6-a7b1-4020d039a00fn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>>
>> --
>>
>>
>>
>> [image: Edmonton_sig_RGB_S.jpg]
>>
>> Alex Wanderley
>>
>> Application and Infrastructure Analyst II
>> Acting Team Lead Server Solutions & Automation
>>
>> Financial and Corporate Services | Open City and Technology
>>
>>
>>
>> 780-496-4156 <(780)%20496-4156> Office
>>
>> 780-819-0273 <(780)%20819-0273> Mobile
>>
>>
>>
>> City of Edmonton
>>
>> Century Place, 19th Floor
>>
>> 9803 102A Avenue NW
>>
>> Edmonton AB, T5J 3A3
>>
>>
>>
>> All information contained in this email post is proprietary to the City
>> of Edmonton, confidential and intended only for the addressed recipient. If
>> you have received this post in error, please disregard the contents, inform
>> the sender of the misdirection, and remove it from your system. The
>> copying, dissemination or distribution of this email, if misdirected, is
>> strictly prohibited.
>>
>> *The contents of this message and any attachment(s) are confidential,
>> proprietary to the City of Edmonton, and are intended only for the
>> addressed recipient. If you have received this in error, please disregard
>> the contents, inform the sender of the misdirection, and remove it from
>> your system. The copying, dissemination, or distribution of this message,
>> if misdirected, is strictly prohibited.*
>
> --
> 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/894210ad-f95c-4f95-9e20-c96fbe8de1a9n%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/894210ad-f95c-4f95-9e20-c96fbe8de1a9n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
Thanks,
Abhijeet Kasurde
--
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/CAFwWkHr3LdHZdvuckeSH-5kmL%3DCYmcNB_M-iwdEfoRhb6w%3DC8Q%40mail.gmail.com.
