How to use an extended search?

This page describes how to set query criteria in the Extended search.

There are four data input fields to specify query criteria.

1. Select

2. Where

3. Order by

4. Return # entries

Extended search is available under Devices --> Clients --> Extended search

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

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

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

Column names are case-sensitive

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

1. 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"

2. Order by – which column to sort by in the output table

• Default query criteria are: ConnectionId

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

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

• Default query criteria are: 1000

• Change the amount of rows to display: 2