Page History

IDERA 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 see Information available on Instance Details. When applied to a database, this information appears in the Database Details window.

Image Removed

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

Image RemovedImage Added

Add a new custom inventory field

1. In IDERA SQL Inventory Manager Administration, click click Manage Custom Inventory Fields. IDERA SQL Inventory Manager displays the Manage Custom Inventory Fields window.
2. Click Click Add. IDERA 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 whether Server, Instance, or or Database.
5. Select the data type, whether whether Open Ended, Yes/No,  Picklist, or Picklist Date.
   • If you select Open Ended, use the the Default Contents field  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 displays Default: (empty) once  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 want Yes or  or No to  to appear as the default value.
   • If you select Picklist, use the the Options field  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 displays (Default) next  next to the item in the the Properties column  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.
   • If you select Date, use the Date Picker control to choose a date. 
6. Click Click Save.

Edit a custom inventory field

...

Make the appropriate changes, and then click click SAVE.

Remove a custom inventory field

...

1. In the Manage Custom Inventory Fields window, select the checkbox next to the field(s) you want to delete, and then click click Remove. IDERA SQL Inventory Manager displays a warning message that requires a confirmation whether you want to remove the selection.
   Click Click Yes. IDERA 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 click No.

Change a custom inventory field value on an instance

Your custom inventory fields are applied to the servers, instances, and databases automatically.