Page History

...

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

...

1. In SQL Inventory Manager Administration, click Manage Custom Inventory Fields. SQL Inventory Manager displays the Manage Custom Inventory Fields window.
2. Click Add. SQL Inventory Manager displays the Add Inventory field dialog box.
   
3. Type the name for the new inventory field. Names must be less than 30 characters and this field cannot be empty.
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 selectedby default on all the instances, servers, or databases until a user changes the value through editing. 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. The default value on the field level is empty until a user enters a value. This field is limited to 250 characters.
   • If you select Yes/No, select whether you want Yes or No to appear as the default value.This field is limited to 250 characters.
   • 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. Note that the default value is populated for the field for all servers, instances, or database depending on the field level that was selected.
6. Click Save.

Edit a custom inventory field

...

If you attempt to delete an item in the Options field and that item is assigned to a server, instance, or database, you can only change the option name and cannot delete the data. If you still want to delete that option, remove the assignment of that option from the server, instance, or database in use, and then re-attempt to delete that option.

You can edit the inventory field name and value, but cannot change the level and type. If you change the default value, the value is not updated for existing fields unless you cleared the value before making the update. From this point on, the default content is populated with the new value for new instances, servers, or databases depending on what field level is selected.

Make the appropriate changes, and then click SAVE.

...

...