Use search when you know what are looking for, but don't know from where.
For example, I know I have a device name that starts with THINK, I can't remember what exact name it is and I just want to see what data do I get
A faster way to filter the data that you are looking for is to **** use "where".
This will return all the results that contain think (not case sensitive) from all columns and all tables
search anything and not case sensitive
search kind=case_sensitive "THINK460"
Search matched words with case sensitive
search in (IntuneDevices, UCClient) "THINK460"
Search from specific tables
// Some code
| search DeviceName: "THINK"
// Search startswith
| search * startswith "THINK"
| search * endswith "01"
| search * endswith "01" and ("Windows" or "iOS")
| search DeviceName matches regex "[A-Z]-"