User-defined filters allow you to define a customized overview of the computers and users.

How to configure a user-defined filter:

1. Right-click Computers or User and select Filter... from the popup menu.
   The Filter-Owner dialog box appears:
   
   If an existing filter is opened to be edited, the title bar displays the filter owner.
2. Define the filter name and the desired parameters and confirm your settings with OK.
   The newly defined filter appears on the left-hand side of the Administration tab.

The individual parameters of the dialog box will be described in the following sections.

• Filter name. Serves to specify the name of the user-defined filter.
• Import. Serves to import a filter.
• Export. Serves to export a filter.
• Public filter. If this checkbox is selected, the filter is visible for all users even if the All Filters option in the View menu has been disabled.
  

  Public filters are applied to both OneClick and action filters and can only be created and edited by users that have been assigned the EMP_ADMIN or EMP_M_ADMIN role.

• Table. Provides a selection of tables whose fields you can select under Parameters.
• Parameters. Shows the table fields of the selected table, which are to be used for filtering.
  Example: If all computers with DHCP are to be displayed, the parameter DHCP has to be selected.
• Criterion. Specifies the criterion according to which the value is to be assigned to the column.
• Value. Defines the value which is to be specified for the selected table column.
• AND/OR. Defines how the different filter criteria are to be linked.
  • AND: To display the computer, all settings have to be true.OR: To display the computer, one of the settings has to be true.
  •  
• Insert. Inserts the filter criterion under Filter.
• Edit. Edits the selected filter criterion.
• Delete. Deletes the selected filter criterion.
• Filter. Shows the complete filter criterion.
• Assigned. Allows you to restrict the filter further.
  • both. All computers/users are included.
  • assigned. Only the already assigned computers/users are included.
  • not assigned. Only the not yet assigned computers/users are included.
• Inventory. Allows you to restrict the filter further.
  • both. All computers/users are included.
  • takes an inventory. Only computers which already belong to the inventory are included.
  • does not take an inventory. Only computers/users which do not yet belong to the inventory are included.
• PXE enabled. Allows you to restrict the filter further.
  • both. All computers/users are included.
  • PXE enabled. Only computers which already belong to the inventory are included.
  • not PXE enabled. Only computers which are not PXE-enabled are included.
• Group, Ungroup. Allows you to group (brackets) or ungroup certain criteria. To group several criteria, you have to select them in the list, and click the corresponding button.
  To select several criteria, proceed as follows:
  • Select the first criterion. Press, and hold down the <Ctrl> key, while selecting further criteria.

The following examples describe the results of different filters:

Filter criteria with different table fields (parameters) in one table.

Example 1:

Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1'

Result: All Clients with a software with the product name 'Acrobat%', a software with version number 6.0 and a software with revision 1. Not all criteria must fit to the same software.

Example 2:

Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1'

Result: All Clients with a software with the product name 'Acrobat%' or a software with version number 6.0 or a software with revision 1. Only one criteria must be fulfilled.

Example 3:

(Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1')

Result: All Clients with a software with the product name 'Acrobat%', version number 6.0 and revision 1. All criteria inside the brackets relate to the same software.

Example 4:

(Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1')

Result: Same as described in example 2. The brackets are useless.

Example 5:

(Inventar - Fixed Disks.Volume = 'D' AND

Inventar - Fixed Disks. File System = 'NTFS')

Result: All clients that have a hard disk drive D and the file system is NTFS.

Filter criteria with table fields (parameters) in different tables.

Example 6:

Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: All clients with a software with the software name 'Acrobat%' and operating system 'Windows 11%'. Both criteria must be fulfilled.

Example 7:

Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: All clients with a software with the software name 'Acrobat%' or operating system 'Windows 11%'. Only one criteria must be fulfilled.

Example 8:

(Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Computer Operating System LIKE 'Windows 11%')

Result: Same as described in example 5. The brackets are useless.

Example 9:

(Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Computer Operating System LIKE 'Windows 11%')

Result: Same as described in example 6. The brackets are useless.

Filter criteria with table fields (parameters) in one table and different tables.

Example 10:

Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1' AND

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: All Clients with a software with the product name 'Acrobat%', a software with version number 6.0 and a software with revision 1. Not all criteria must fit to the same software. Also the operating system must be 'Windows 11%'.

Example 11:

Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1' AND

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: Result: All Clients with a software with the product name 'Acrobat%' or a software with version number 6.0 or a software with revision 1. Only one criteria must be fulfilled. Also the operating system must be 'Windows 11%'.

Example 12:

(Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1') AND

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: Result: All Clients with a software with the product name 'Acrobat%', version number 6.0 and revision 1. All criteria inside the brackets relate to the same software. Also the operating system must be 'Windows 11%'.

Example 13:

(Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1') AND

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: Same as described in example 10. The brackets are useless.

Example 14:

Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1' OR

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: All clients with a software with the software name 'Acrobat%' or a software with version number 6.0 or a software with revision 1 or the operating system 'Windows 11%'. Only one criteria must be fulfilled.

Example 15:

Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1' OR

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: Same as described in example 13.

Example 16:

(Inventar - Software.Productname LIKE 'Acrobat%' AND

Inventar - Software.Version = '6.0' AND

Inventar - Software.Revision = '1') OR

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: All Clients with a software with the product name 'Acrobat%', version number 6.0 and revision 1 or the operating system 'Windows 11%'. All criteria inside the brackets relate to the same software.

Example 17:

(Inventar - Software.Productname LIKE 'Acrobat%' OR

Inventar - Software.Version = '6.0' OR

Inventar - Software.Revision = '1') OR

Inventar - Computer Operating System LIKE 'Windows 11%'

Result: Same as described in example 13 and 14. The brackets are useless.