Advanced Search

HomeRunbook's Advanced Search lets you find any device using powerful boolean queries, a visual query builder, and saved searches. Export results to CSV or PDF.

Quick Access

Access search using:

Navbar Search Dropdown - Click the Search button to see saved searches or start a new search
Search Page - Full advanced search interface at /search.php

Visual Query Builder

The easiest way to build complex searches without learning query syntax:

Select a Field - Choose from standard fields (Brand, Model, Category, Room, etc.) or any custom property
Choose an Operator - Contains, equals, greater than, less than, etc.
Enter a Value - Type or select from autocomplete options
Add More Conditions - Click "Add Condition" and choose AND, OR, or NOT

The query is built automatically as you make selections.

Tip: Fields with fixed options (like Category or Room) show autocomplete dropdowns for easier selection.

Query Syntax

For power users, type queries directly using this syntax:

Field Searches

Syntax	Description	Example
`field:value`	Contains (partial match)	`brand:Apple`
`field:"exact phrase"`	Exact phrase with quotes	`brand:"Apple Inc"`
`field=value`	Exact match	`category=Router`
`field!=value`	Not equal to	`brand!=Generic`
`field>value`	Greater than	`purchase_price>500`
`field>=value`	Greater than or equal	`purchase_date>=2024-01-01`
`field<value`	Less than	`purchase_price<100`
`field<=value`	Less than or equal	`purchase_date<=2023-12-31`

Boolean Operators

Operator	Description	Example
`AND`	Both conditions must match	`brand:Cisco AND category:Router`
`OR`	Either condition can match	`brand:Apple OR brand:Google`
`NOT`	Exclude matching devices	`NOT is_virtual:true`
`XOR`	One or the other, but not both	`brand:Dell XOR brand:HP`
`( )`	Group conditions	`(brand:Apple OR brand:Google) AND category:Phone`

Searchable Fields

Standard Fields

Field Name	Aliases	Description	Example
`brand`	`manufacturer`	Device manufacturer	`brand:Sony`
`model`		Device model name/number	`model:XPS`
`category_group`	`group`	Category group (Appliances, HVAC, Electronics, etc.)	`category_group:Appliances`
`category`	`type`	Specific device type	`category:Router`
`serial_number`	`serial`	Device serial number	`serial:ABC123`
`notes`		Device notes field	`notes:warranty`
`os_version`	`os`	Operating system or firmware	`os:Ubuntu`
`location_in_room`	`location`	Device location within room	`location:rack`
`ip`	`ip_address`	IP address (partial match)	`ip:192.168.1`
`hostname`	`host`	Device hostname (from Network Interfaces)	`hostname:web-server`
`mac`	`mac_address`	MAC address	`mac:00:11:22`
`nic_type`	`interface_type`	Interface type: wired, wireless, virtual, loopback	`nic_type:wireless`
`ssid`	`wifi`, `ssid_name`	WiFi network name (SSID)	`ssid:HomeNetwork`
`connection_type`	`connection`	Connection type between devices	`connection:Ethernet`
`room`	`room_name`	Room/map name	`room:Office`
`purchase_date`		Purchase date (YYYY-MM-DD)	`purchase_date>=2024-01-01`
`purchase_price`	`price`	Purchase price	`price>1000`
`is_virtual`	`virtual`	Virtual machine flag	`virtual:true`

Custom Properties

Search any custom property by its name. Properties are organized by property set across 10 industries:

Examples:
warranty_expires:2025 - Find devices with warranty expiring in 2025
refrigerant_type:R410A - Find HVAC units using R410A
amperage:20 - Find electrical devices on 20 amp circuits
vlan:100 - Find network devices on VLAN 100

Universal Property Sets

Property Set	Searchable Fields
Network Properties	`ip_address`, `subnet_mask`, `default_gateway`, `dns_primary`, `mac_address`, `vlan`, `hostname`
Warranty & Purchase	`purchase_date`, `purchase_price`, `purchased_from`, `warranty_expires`, `warranty_type`, `receipt_number`
Maintenance Schedule	`last_service_date`, `next_service_due`, `service_interval`, `service_provider`
Physical Location	`location_description`, `floor_level`, `mounting_type`, `rack_position`
Room Dimensions	`square_footage`, `length`, `width`, `ceiling_height`

HVAC Industry

Property Set	Searchable Fields
HVAC Unit Specs	`btu_rating`, `tonnage`, `seer_rating`, `refrigerant_type`, `voltage`
Filter Information	`filter_size`, `filter_type`, `merv_rating`, `last_changed`
Thermostat Config	`thermostat_type`, `protocol`, `heating_stages`, `cooling_stages`

Electrical Industry

Property Set	Searchable Fields
Electrical Panel	`main_breaker`, `bus_amperage`, `voltage`, `phase`, `panel_type`
Circuit Breaker	`amperage`, `poles`, `wire_gauge`, `circuit_description`, `panel_position`
Generator	`rated_watts`, `surge_watts`, `fuel_type`, `tank_size`

Plumbing Industry

Property Set	Searchable Fields
Water Heater	`tank_capacity`, `heater_type`, `btu_input`, `energy_factor`
Plumbing Fixture	`fixture_type`, `flow_rate`, `flush_volume`, `shutoff_location`

Security / Low Voltage

Property Set	Searchable Fields
Camera Properties	`resolution`, `camera_type`, `field_of_view`, `ir_range`, `nvr_channel`
Access Control	`reader_type`, `card_format`, `door_number`, `controller_address`
Alarm Zone	`zone_number`, `zone_type`, `sensor_type`, `loop_type`

IT / Networking

Property Set	Searchable Fields
Server Hardware	`cpu_model`, `cpu_cores`, `ram`, `operating_system`, `service_tag`
Network Switch	`port_count`, `port_speed`, `poe_budget`, `firmware_version`
Wireless AP	`wifi_standard`, `radio_bands`, `max_clients`, `ssids`

Industrial / Mechanical

Property Set	Searchable Fields
Electric Motor	`horsepower`, `rpm`, `voltage`, `frame_size`, `full_load_amps`
Pump Properties	`flow_rate`, `head_pressure`, `pump_type`, `fluid_type`
Compressor	`cfm`, `max_psi`, `tank_size`, `compressor_type`

Fire Protection

Property Set	Searchable Fields
Fire Alarm Device	`device_address`, `slc_loop`, `detector_type`, `last_tested`
Sprinkler Head	`sprinkler_type`, `k_factor`, `temp_rating`, `coverage_area`

Solar Installation

Property Set	Searchable Fields
Solar Panel	`panel_type`, `wattage`, `efficiency`, `cell_count`
Solar Inverter	`inverter_type`, `rated_power`, `mppt_channels`, `peak_efficiency`
Battery Storage	`battery_chemistry`, `capacity_kwh`, `cycle_life`, `depth_of_discharge`
Charge Controller	`controller_type`, `rated_current`, `max_pv_voltage`

Software Engineering

Property Set	Searchable Fields
Virtual Machine	`hypervisor`, `vcpus`, `ram_gb`, `operating_system`, `hostname`, `environment`
Container	`container_runtime`, `orchestration`, `image`, `namespace`, `replicas`
Cloud Service	`cloud_provider`, `service_type`, `region`, `resource_id`, `monthly_cost`
Database Instance	`database_engine`, `version`, `instance_type`, `storage_gb`, `port`
API Endpoint	`api_type`, `base_url`, `authentication`, `rate_limit`, `api_version`
Load Balancer	`lb_type`, `algorithm`, `frontend_port`, `backend_port`
Message Queue	`queue_type`, `queue_name`, `partitions`, `retention_hours`
Cache Instance	`cache_engine`, `node_type`, `memory_gb`, `eviction_policy`

Category Group Search

Search across all device types within a category group:

category_group:Appliances - Find all appliances (refrigerators, washers, air fryers, etc.)
category_group:HVAC - Find all HVAC equipment
category_group:Electronics - Find all electronics and networking gear

Available category groups: Appliances, Electrical, Electronics/Networking, Fire Protection, HVAC, Industrial/Mechanical, Plumbing, Property, Security/Low Voltage, Outdoor/Landscaping, General

Search Examples

Query	Finds
`brand:Cisco AND category:Router`	All Cisco routers
`(brand:Apple OR brand:Google) AND category:Phone`	Apple or Google phones
`ip:192.168.1 AND NOT is_virtual:true`	Physical devices on 192.168.1.x subnet
`purchase_date>=2024-01-01 AND purchase_price>500`	Devices purchased in 2024 costing over $500
`category_group:HVAC AND room:Basement`	All HVAC equipment in the basement
`warranty_expires>=2025-01-01`	Devices with warranty valid through 2025

Saved Searches

Save frequently used searches for quick access:

Run your search query
Click Save Current
Enter a name for the search
Optionally mark as Shared to make it available to your team

Accessing Saved Searches

Navbar Dropdown: Click the Search button in the navigation bar to see all your saved searches
Search Page: Select from the saved searches dropdown

Shared Searches: Searches marked as shared are visible to all users in your account. Only the creator can delete a shared search.

Client Filter (Service Providers)

Service providers can filter search results by client:

Use the Client Filter dropdown on the search page
Select one or more clients to restrict results
Save the search with client filters included

Export Options

Export your search results in multiple formats:

Format	Description
Print	Print-optimized view with logo, query, and results table. Hides controls and query builder.
CSV	Download results as a CSV file for spreadsheets. Includes device, model, type, room, serial, IPs, and MACs.
PDF	Generate a PDF document with logo, search name/query, results table, and timestamp.

Search Tips

Use the Visual Builder: Start with the visual query builder to learn the syntax, then type directly for speed
Partial matches work: ip:192.168 finds all devices on 192.168.x.x subnets
Network fields: Search by nic_type:wireless, ssid:MyNetwork, or connection_type:Ethernet
Case insensitive: brand:apple and brand:APPLE return the same results
Use quotes for phrases: notes:"main server" finds exact phrase
Category groups for broad searches: Use category_group:Appliances to find all appliances at once
Save complex queries: Save frequently used searches to avoid retyping
Export for reports: Use PDF export to create documentation or reports

Troubleshooting

If your search isn't returning expected results:

Check syntax errors: Error messages show the position of syntax problems
Try broader terms: Start with a single field and narrow down
Use the visual builder: Let it construct the query for you
Check field names: Click "Syntax Help" to see all available fields
Verify data exists: Make sure devices have the fields you're searching populated