String search through all tables (do not use in production!)
search "memory"
Limit string search to a specific range of tables
search in (Perf, Events) "memory"
Limit string search to one table
Perf| search "memory"
Search for exact string "Available MBytes
"
Perf | search CounterName == "Available MBytes"
Search for string in column that contains MBytes
Perf | search CounterName:"MBytes"
Search for string in all columns containing string Bytes
Perf | search "Bytes"
Search for string in all columns starting with Bytes
Perf | search * startswith "Bytes"
Search for string in all columns ending with Bytes
Perf | search * endswith "Bytes"
Search for string in all columns that starts with Free and ends with Bytes
Perf | search "Free*bytes"
Search for string in all columns that starts with Free and ends with Bytes that contain either C: or D:
Perf | search "Free*bytes" and ("C:" or "D:")
Search table column for string using regex
Perf
| search InstanceName matches regex "[A-Z]:"