Online Help | Network Inventory

Designing an Advanced Filter by specifying an SQL WHERE clause

You can create, edit or remove the advanced filters by directly specifying an SQL WHERE clause.

To configure an advanced filter by specifying an SQL WHERE clause:

  1. Right-click anywhere in the grid and choose Filter > Advanced Filter from the pop-up menu. The Customize View - Advanced Filter window opens.

  2. If the Advanced Filter tab appears in the Design mode, click Switch to SQL Mode.

  3. In the SQL mode, configure the SQL WHERE clause, click OK.

ClosedClick here to show the examples of SQL WHERE clauses for the Computers grid

Meaning WHERE clause

Show computers with Windows 10 OS.

[Info_OS] Like N'%Windows 10%'

Show Windows 10 computers with CPU speed that is greater than 3 GHz.

([Info_OS] Like N'%Windows 10%') and ([Info_CPU_Speed] > 3)

Show Windows 10 computers with CPU Speed that is greater than 3 GHz located either in the ZEUS or NJ Domain.

([Info_OS] Like N'%Windows 10%') and ([Info_CPU_Speed] > 3) and ([Machine_Domain] IN ( N'ZEUS', N'NJ'))

NOTE: When you switch to the Design mode, all the data entered in the SQL mode is lost.

To remove an advanced filter created by specifying an SQL WHERE clause:

  1. Right-click anywhere in the filtered grid and choose Filter > Advanced Filter from the pop-up menu. The Customize View - Advanced Filter window opens. The Advanced Filter tab appears in the SQL mode.

  2. Clear the criteria box, click OK.