Filtering Source Hosts continue

[shrutebattlestargalactica]

Hello - I am successfully connecting to our snow instance and yml looks to parse properly but unable to query any data, as it returns no results, I am also referencing https://docs.servicenow.com/bundle/quebec-platform-user-interface/page/use/common-ui-elements/reference/r_OpAvailableFiltersQueries.html for the operators to use in yml.

This is what I am using (Issue):

plugin: servicenow.itsm.now
table: cmdb_ci_server
columns:
  - operational_status
  - support_group
  - name
  - ip_address
  - fqdn
  - install_status
  - class
query:
  - operational_status: IN XYZ
    support_group: LIKE XYZ
    u_patch_cycle: LIKE XYZ
compose:
  ansible_host: ip_address
  support_group: support_group
  fqdn: fqdn
  ipaddress: ip_address  
groups:
  windows_servers: (u_os_details|lower).startswith('windows')
  linux_servers: (u_os_details|lower).startswith('linux')

when using this however - ansible yields no results (debugging enabled) here is the results from tower:

ansible-inventory [core 2.11.7rc1.post0] 
  config file = /runner/project/ansible.cfg
  configured module search path = ['/home/runner/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/lib/python3.8/site-packages/ansible
  ansible collection location = /runner/requirements_collections:/home/runner/.ansible/collections:/usr/share/ansible/collections:/usr/share/automation-controller/collections
  executable location = /usr/local/bin/ansible-inventory
  python version = 3.8.8 (default, Aug 25 2021, 16:13:02) [GCC 8.5.0 20210514 (Red Hat 8.5.0-3)]
    jinja version = 2.10.3
  libyaml = True
Using /runner/project/ansible.cfg as config file
setting up inventory plugins
Loading collection servicenow.itsm from /runner/requirements_collections/ansible_collections/servicenow/itsm
[WARNING]: 'ansible_host_source' option is deprecated since version 1.2.0 and
will be removed in 2.0.0.
Parsed /runner/project/now.yml inventory source with ansible_collections.servicenow.itsm.plugins.inventory.now plugin
   51.322 INFO     Processing JSON output...
   51.322 DEBUG    Loaded group: all
   51.323 INFO     Loaded 0 groups, 0 hosts
   51.324 DEBUG    Inventory variables unmodified
   51.372 INFO     Inventory import completed for ServiceNow in 0.1s

any help appreciated, thanks so much!

SOLVED:

plugin: servicenow.itsm.now
table: cmdb_ci_server
columns:
  - operational_status
  - support_group
  - name
  - ip_address
  - fqdn
  - install_status
  - class
query:
  - operational_status: =  1
    support_group: LIKE XYZ
    u_patch_cycle: LIKE XYZ

[shrutebattlestargalactica]

I found my answer here and updated the original post of my now.yml - the attribute type of the operational_status column is of integer type. Once I found this article and updated my condition/operator to match the = 1 per this part of the document

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/configuration-management/concept/cmdb-ci-lifecycle-mgmt.html

Also shortened the now.yml for troubleshooting purposes so I could at least validate I am able to query the cmdb_ci_server table with the provided filters

now.yml

plugin: servicenow.itsm.now
table: cmdb_ci_server
columns:
  - operational_status
  - support_group
  - name
  - ip_address
  - fqdn
  - install_status
  - class
query:
  - operational_status: =  1
    support_group: LIKE XYZ
    u_patch_cycle: LIKE XYZ

[shrutebattlestargalactica]

@tadeboro do you have any great ideas on what we could do if wanting to use 3 columns to create one group? I am using this logic, but it does not create the group in tower:

windows_mydomain: (fqdn|lower).endswith('.mydomain.com')and(os|lower).startswith('windows')and(used_for|lower).startswith('Production (P)')

it will create a group if I use just one and operator like this:
windows_mydomain: (fqdn|lower).endswith('.mydomain.com')and(os|lower).startswith('windows')

Thanks for your help!