json_query & regular expression

[Kiran Kumar]

In jason query how can i add regular expression ? eg if have vm1, vm2,vm3 below query can be adjusted ? eg       query: "[?guest_name == 'vm*' ]" , seems does not work in below case 

https://jmespath.org/specification.html#filterexpressions  i tried few things but no luck 

Thanks

---
- hosts: localhost
  vars_files:
    - vcsim_vars.yml
  tasks:
  - name: Gather all VMs information
    vmware_vm_info:
      hostname: '{{ vcenter_hostname }}'
      username: '{{ vcenter_username }}'
      password: '{{ vcenter_password }}'
      validate_certs: no
    register: vm_facts
    delegate_to: localhost
  - debug:
      msg:  "{{ item.ip_address }}"
    with_items:
    - "{{ vm_facts.virtual_machines | json_query(query) }}"
    vars:
      query: "[?guest_name == 'vm1' ]"

[Vladimir Botka]

On Sat, 11 Apr 2020 21:26:28 -0700 (PDT)
Kiran Kumar <esxi...@gmail.com> wrote:

> In jason query how can i add regular expression ? eg if have vm1, vm2,vm3
> below query can be adjusted ? eg query: "[?guest_name == 'vm*' ]" ,
> seems does not work in below case
>

> > tasks:
> > - name: Gather all VMs information
> > vmware_vm_info:
> > hostname: '{{ vcenter_hostname }}'
> > username: '{{ vcenter_username }}'
> > password: '{{ vcenter_password }}'
> > validate_certs: no
> > register: vm_facts
> > delegate_to: localhost
> > - debug:
> > msg: "{{ item.ip_address }}"
> > with_items:
> > - "{{ vm_facts.virtual_machines | json_query(query) }}"
> > vars:
> > query: "[?guest_name == 'vm1' ]"

Filter "selectattr" should do the job. For example

- debug:
msg: "{{ item.ip_address }}"
loop: "{{ vm_facts|
selectattr('guest_name', 'match', '^vm1$')|
list }}"
- debug:
msg: "{{ item.ip_address }}"
loop: "{{ vm_facts|
selectattr('guest_name', 'match', '^vm(.*)$')|
list }}"

I'm not aware of regex in JMESPath.
https://jmespath.readthedocs.io/en/latest/

HTH,

-vlado

[Kiran Kumar]

Thanks for the Reply Valdo

I get error 

TASK [debug] *********************************************************************************************************************************************************************************************

fatal: [localhost]: FAILED! => {"msg": "'str object' has no attribute 'guest_name'"}

[Vladimir Botka]

On Sat, 11 Apr 2020 23:35:16 -0700 (PDT)
Kiran Kumar <esxi...@gmail.com> wrote:

> I get error
> TASK [debug]
***********************************************************************************************************************>

fatal: [localhost]: FAILED! => {"msg": "'str object' has no attribute
> 'guest_name'"}

Take a look at the structure of "vm_fact" and fix it. If you still have issues
post:

- debug:
var: vm_fact

[Kiran Kumar]

Thanks for your reply Valdo. This is a JSON output 

            {

                "attributes": {},

                "cluster": "xx",

                "esxi_hostname": "xx",

                "guest_fullname": "Microsoftxx",

                "guest_name": "xx",

                "ip_address": "xx",

                "mac_address": [

                    "xx"

                ],

                "power_state": "poweredOn",

                "tags": [],

                "uuid": "xx",

                "vm_network": {

                    "xx": {

                        "ipv4": [

                            "xx"

                        ],

                        "ipv6": []

                    }

I am reading about - selectattr - as i am new to this. 

Thanks 

[Vladimir Botka]

On Sun, 12 Apr 2020 00:26:39 -0700 (PDT)
Kiran Kumar <esxi...@gmail.com> wrote:

> {

> "attributes": {},
> "cluster": "xx",
> "esxi_hostname": "xx",
> "guest_fullname": "Microsoftxx",
> "guest_name": "xx",
> "ip_address": "xx",
> "mac_address": [
> "xx"
> ],
> "power_state": "poweredOn",
> "tags": [],
> "uuid": "xx",
> "vm_network": {
> "xx": {
> "ipv4": [
> "xx"
> ],
> "ipv6": []
> }
>

> > fatal: [localhost]: FAILED! => {"msg": "'str object' has no attribute
> > > 'guest_name'"}
> > > >

> > > > - debug:
> > > > msg: "{{ item.ip_address }}"
> > > > loop: "{{ vm_facts|
> > > > selectattr('guest_name', 'match', '^vm(.*)$')|
> > > > list }}"

There shouldn't be any problem with the dictionary "vm_facts" you posted. The
attribute "guest_name" is in place. I can't explain the error. It's up to you
to fix the JSON paths.

[Abhijeet Kasurde]

I would do this in a simpler way -

- name: Gather all VMs information

vmware_vm_info:

hostname: '{{ vcenter_hostname }}'

username: '{{ vcenter_username }}'

password: '{{ vcenter_password }}'

validate_certs: no

register: vm_facts

delegate_to: localhost

- debug:

msg: "{{ item.ip_address }}"

loop: "{{ vm_facts.virtual_machines }}"

when:

- item.guest_name | regex_search('^vm')

--
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 ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/20200412135631.0fd34f5a%40gmail.com.

--

Thanks,

Abhijeet Kasurde

[Abhijeet Kasurde]

Even this works for me -  notice ``vm_facts.virtual_machines``

- debug:

msg: "{{ item.ip_address }}"

loop: "{{ vm_facts.virtual_machines | selectattr('guest_name', 'match', '^vm(.*)$')| list }}"

--

Thanks,

Abhijeet Kasurde

[Kiran Kumar]

Thanks Abhijeet & Valdo for your time to check. This works !

To unsubscribe from this group and stop receiving emails from it, send an email to ansible...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/20200412135631.0fd34f5a%40gmail.com.

--

Thanks,

Abhijeet Kasurde

--

Thanks,

Abhijeet Kasurde