How to search on Tower

Some examples to use the search box in Tower to filter or create smart inventory

see Automation Controller API Guide - Filtering

old URL https://docs.ansible.com/ansible-tower/latest/html/towerapi/filtering.html

Find disabled hosts

enabled:false

Find hosts with hostvar defined

variables.icontains:myvar

Use as host filter on tower-cli

tower-cli host list --host-filter 'variables__icontains=application'

Find hosts with ansible facts equal a value

ansible_facts.ansible_os_family:RedHat

Find hosts in organization

organization.name:Default

Find hosts in a group belongs to an inventory

First we need to find the group number using the api URL. For example, to list groups info for inventory id 18 https://tower-host.com/api/v2/inventories/18/groups/ Then use the group id in the filter

groups:482

Find hosts in a group name from any inventory

groups.name:mygroup

Find hosts that failed the last job

has_active_failures:true

Find hosts by name

name.startswith:dev
name.exact:devhost4
name.istartwith:dev
name.endswith:4
name.regex:^dev.*4$

Using the host filter on tower-cli

tower-cli host list --host-filter name__endswith=80 -vvv
tower-cli host list --host-filter name__startswith=RN
tower-cli host list --host-filter 'name__regex=fedora[0-9]'
tower-cli host list --host-filter 'name__startswith=RN and name__regex=01$'

Find dev hosts that are marked as ‘d’ on the 6th characters

name.regex:^.{5}d

Find a template ID by name using curl

curl -k -u john:secret https://192.168.0.101/api/v2/job_templates/?name='My Template' | python3 -c 'import json,sys; print (json.load(sys.stdin)["results"][0]["id"])'

Find a template ID by name using tower-cli

tower-cli job_template list --name 'Rolling Test' --format id

No space in any search string.