Filtering source hosts

[Dominixol]

Hi Team,

I am using below solution to fetch data from ServiceNow CMDB. It works fine, I got list of servers only for organization XYZ, however I would like to add one more filter to narrow the list of hosts.

plugin: servicenow.itsm.now
table: cmdb_ci
columns: []
query:
  - company: LIKE XYZ
compose:
  ansible_host: ip_address
  company: company
  fqdn: fqdn
  ipaddress: ip_address  
groups:
  grp_Windows_Server_2016: (u_os_details|lower).startswith('windows server 2016')

If I add another entry under query (example below) it will take second one as higher priority and ignore fist entry.

query:
  - company: LIKE XYZ
  - install_status: = 5003

How can I add another filter?

[tadeboro]

There are two ways of combining filtering conditions: using the AND and OR operators. Your query

query:
  - company: LIKE XYZ
  - install_status: = 5003

will return CMDB items that contain the XYZ string in the company name OR whose install status is equal to 5003. If you change your query to

query:
  - company: LIKE XYZ
    install_status: = 5003

inventory plugin will return CMDB items that contain the XYZ string in the company name AND whose install status is equal to 5003. Of course, you can also combine those things. For example:

query:
  - company: LIKE XYZ
    install_status: = 5003
  - install_status: = 5004

[Dominixol]

It helped, thank you! :)