Custom columns

Use Custom columns to modify column names and fields. A name is the displayed name of the column, and a field contains the attributes that can appear in the column (if any attributes are present). Any column changes you make will not be seen by other users. Custom column changes will be seen in the My devices view.

This product includes a default column set with seven columns. You can't edit the default set, but you can define a custom column set to use as your default.

It is not advisable to create custom columns in which there can be multiple field names. For example, if you were to create a Computer.Software.Package.Name field and the device had multiple packages installed, Management Suite will list only one package name per line, even if the different package names are on the same device, making the All devices list have multiple entries for the same device.

To create a custom column set
  1. In the left navigation pane, click Administration > Preferences.
  2. Click the Custom columns tab.
  3. Click New.
  4. Type a name for the column set.
  5. In the top box, select each column heading you want in the column set and click Add.

    The box shows a list that represents all of the inventory data currently in the database. Drill down this list to select an attribute to display in the query results list. Remember to select attributes that will help you identify the clients returned in the query.

    If you're using an Oracle database, make sure you select at least one attribute that is natively defined by the inventory scanner (for example, Computer.Display Name, Computer.Device Name, Computer.Device ID, Computer.Login Name, and so on).

    NOTE: If you select an attribute in the database that has a 1:* relationship, you will get duplicate entries for the device. When you select attributes with a 1:1 relationship (only one possible attribute, like Computer.System.Asset Tag), you will not receive duplicate entries.

  6. To change the order of the columns, select a column heading and click Move up or Move down.
  7. To remove a column, select it in the lower box and click Remove.
  8. To change the heading displayed for a column, select the heading in the lower box, click Edit, make your modifications, and press Enter. The following extended characters are not supported: < , > , ' , " , !.
  9. Click OK to save the column set.
  10. To use the custom column set when you view the All devices list, select it and click Set as current column set on the toolbar.
To edit a custom column set
  1. In the left navigation pane, click Administration > Preferences.
  2. Click the Custom columns tab.
  3. Select the custom column set and click Edit.
  4. In the top box, select a column heading and click Add to add the column (see notes under step 5 above).
  5. To remove a column, select it in the lower box and click Remove.
  6. To change the heading displayed for a column, select the heading in the lower box, click Edit, make your modifications, and press Enter. The following extended characters are not supported: < , > , ' , " , !.
  7. To change the order of the columns, select a column heading and click Move up or Move down.
  8. Click OK to save your changes.