SQL Inventory Manager includes a feature that lets you customize inventory fields to allow for easier searching and identification of the associated servers, instances, and databases. Users who create or manage these fields must be administrators within SQL Inventory Manager.

The Custom Inventory fields section on the Administration view allows you to manage the complete list of custom fields for all your environment.

Add a new custom inventory field

1. In SQL Inventory Manager Administration, click Manage Custom Inventory Fields. SQL IM displays the Manage Custom Inventory Fields window.
2. Click Add. SQL IM displays the Add Inventory field dialog box.
   
3. Type the name for the new inventory field.
4. Select the element level, whether Server, Instance, or Database.
5. Select the data type, whether Open Ended, Yes/No, or Picklist.
   • If you select Open Ended, use the Default Contents field to type the information that you want to appear when this inventory item is selected. If the default is a null or blank string, the Properties column of the Manage Custom Inventory Fields window displays Default: (empty) once you save this inventory item.
   • If you select Yes/No, select whether you want Yes or No to appear as the default value.
   • If you select Picklist, use the Options field to list the items you want available to the user when they select this inventory item. Add only one option per line. This field is limited to 100 characters. Note that the first line is the default option which displays (Default) next to the item in the Properties column once you save this inventory item.
6. Click Save.

Edit a custom inventory field

Editing a custom inventory field lets you rename the field or change the contents or options for the selected data type.

To edit a custom inventory field, select the checkbox next to the field you want to edit, and then click Edit. Note that you can only edit one custom inventory field at a time.

Make the appropriate changes, and then click SAVE.

Remove a custom inventory field

To remove one or more custom inventory fields:

1. In the Manage Custom Inventory Fields window, select the checkbox next to the field(s) you want to delete, and then click Remove. SQL Inventory Manager displays a warning message that requires a confirmation whether you want to remove the selection.
   
2. Click Yes. SQL Inventory Manager deletes the field(s) and users can no longer use those fields. If you did not mean to delete the selected fields, click No.

Need more help? Search the Idera Customer Support Portal.