The Where Clause functionality is used in Thresholds, Displays, Database Collections and Database Summaries to specify which data is to be selected from the many Records available.
For example, you can create a Where Clause to collect data only from CPU’s that are greater than 80% busy, or disks that have less than 10% free space. The Where Clause is created by nominating a specific field from a Record (e.g. NtCpu.BusyPercent), then applying the required collection criteria to it (e.g. >80).
The Where Clause enables you to filter incoming data according to the specified criteria. The default Where Clause is ALL, which allows all data from a record to be collected.