Where are the ZCM Administrator-Defined Fields Stored?

  • 7007525
  • 10-Jan-2011
  • 27-Apr-2012

Environment

Novell ZENworks Configuration Management Inventory (ZCM)

Situation

Administrator-Defined Fields allow users to add custom data to an inventory report.
Data can be stored in these four field types:
  • User
  • Workstation
  • Component
  • Product

The Administrator-Defined Fields can be defined here:
ZCC > Configuration > Asset Inventory

Resolution

The Administrator-Defined Fields are stored in a table called 'nc_adf'.
The 'Label' column will give the name of the field defined within ZCM.

The actual data input into these fields are stored in one of the following tables:
  • nc_workstation
  • nc_user
  • nc_product
  • nc_component
  • lc_license
  • lc_contract