search

​
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".
where
🔍Search everything and not case sensitive
search "*think*"
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 matched words with case sensitive
search kind=case_sensitive "THINK460"
Search matched words with case sensitive
🔍Search from specific tables
search in (IntuneDevices, UCClient) "THINK460"
Search from specific tables
🔍Search the value from the specified columnIntu
// Some code
IntuneDevices
| search DeviceName: "THINK"
​
🔍Search begins with and starts with
// Search startswith
IntuneDevices
| search * startswith "THINK" 
​
//Search endswith
IntuneDevices
| search * endswith "01" 
🔍Search combined logically
IntuneDevices
| search * endswith "01" and ("Windows" or "iOS")
🔍Search with regex
IntuneDevices
| search DeviceName matches regex "[A-Z]-"

Last modified 10mo ago