# How to use an extended search?

There are four data input fields to specify query criteria.

1. Select
2. Where&#x20;
3. Order by
4. Return # entries

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2FVQgf0n4IJ2iKCuv41gn2%2Fimage.png?alt=media&#x26;token=45dd3327-dfd9-4a53-a25f-7fcde71e9913" alt=""><figcaption><p>Extended search is available under Devices --> Clients --> Extended search</p></figcaption></figure>

1. **Select** – which columns to display in the output table

* Default query criteria are: new (StifleRAgentID, NetId, ComputerName, Connected, InternalIPAddress, NetworkId)

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2F0Tg8Lui0yD23umNNQCn4%2FExtended%20search%2001.png?alt=media&#x26;token=e9df6096-5ec0-430f-a01c-f694965b9c3b" alt=""><figcaption></figcaption></figure>

* Use the \* (asterisk) symbol to display a list of all available columns in the output table

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2F3LpG9hvLK6GFb5BzYzDJ%2FExtended%20search%2003.png?alt=media&#x26;token=63c0d435-fde3-43a7-8847-5290d059ef0e" alt=""><figcaption><p>Column names are case-sensitive</p></figcaption></figure>

* Add two new columns in the output table by setting a new query criteria: new (StifleRAgentID, NetId, ComputerName, Connected, InternalIPAddress, NetworkId, ExternalIPAddress, NICSpeed)

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2FCnYONiOB2pomTFogslK7%2FExtended%20search%2002.png?alt=media&#x26;token=88f7d200-10b5-42e6-a4a5-28a5076d4286" alt=""><figcaption></figcaption></figure>

2. **Where** – which data to query with Extended search
   * Default query criteria are: x => x.Uptime > 0
     * Column name: Uptime
     * Any value higher than zero: > 0
   * x=>x.VPN = false
     * Column name: VPN
     * Any value equals false: = false
   * x=>x.ComputerName = "UAT-NET1-PC01"
     * Column name: ComputerName
     * Any value equals query criteria: = "UAT-NET1-PC01"
3. **Order by** – which column to sort by in the output table

* Default query criteria are: ConnectionId

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2FqGTpLj1cxV5qX54XuOGV%2FExtended%20search%2004.png?alt=media&#x26;token=7fb00c75-1134-483d-9205-c366087d87e1" alt=""><figcaption></figcaption></figure>

* Change the sort order by setting a column name criteria: ComputerName

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2FO3WQOcIgRa7ntzyYycXi%2FExtended%20search%2005.png?alt=media&#x26;token=dbd77e7c-283b-4b65-a94e-721af6d76e8f" alt=""><figcaption></figcaption></figure>

4. **Return # entries** – how many rows to return in the output table

* Default query criteria are: 1000

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2Fw3KlDlPkaCmjb3Lpd5iH%2FExtended%20search%2006.png?alt=media&#x26;token=0bcff682-29ef-49e1-8643-8e0fd9408736" alt=""><figcaption></figcaption></figure>

* Change the amount of rows to display: 2

<figure><img src="https://109907496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYUaU4nvWOjjzrdVpKtdy%2Fuploads%2FItTFLPw7MtVXPIXAXoXF%2FExtended%20search%2007.png?alt=media&#x26;token=3afc0618-5539-4010-b297-1f5a718f0166" alt=""><figcaption></figcaption></figure>
