SQL Inventory Manager includes a feature that lets you add custom inventory fields to your servers, instances, and databases to allow for easier identification. When applied to an instance, this information appears in the Instance Summary section of the Instance Details view. For more information about changing the value(s) of a custom field, see Information available on Instance Details. When applied to a database, this information appears in the Database Details window.
Users who create or manage these fields must be administrators within SQL Inventory Manager. Product Users can edit the values of the custom inventory fields for the instances to which they have access.
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
- In SQL Inventory Manager Administration, click Manage Custom Inventory Fields. SQL Inventory Manager displays the Manage Custom Inventory Fields window.
- Click Add. SQL Inventory Manager displays the Add Inventory field dialog box.
- Type the name for the new inventory field. Names must be less than 30 characters and this field cannot be empty.
- Select the element level, whether Server, Instance, or Database.
- 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 by 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.
- 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.
- Click Save.
Edit a custom inventory field
Editing a custom inventory field lets you rename the field or change the 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.
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.
Remove a custom inventory field
To remove one or more custom inventory fields:
- 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.
- 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.
Change a custom inventory field value on an instance
Your custom inventory fields are applied to the servers, instances, and databases automatically.
Need more help? Search the Idera Customer Support Portal.