2.34 NC_Product Table

The NC_Product table contains product information.

Column

Key

Type

Null

Description

ProductOID

PK

binary(16)

No

An internal ID number used as a primary key.

Code

int

The product’s unique ID where 0 as the leading digit represents hardware and 1 represents software.

ProductType

smallint

No

The product type. See "Notes"below.

ProductCategoryOID

FK

binary(16)

Product classification information.

Manufacturer

nvarchar(35)

The manufacturer’s name.

Product

nvarchar(100)

The product name.

Model

nvarchar(25)

The model of the product.

Source

smallint

No

How the product was created:

  • 0=Novell Defined
  • 1= Collection
  • 2=Field Editor
  • 3 = ZENworks Control Center
  • 4=Translator/Migrator
  • 5=Palm Translator
  • 6=UNIX Translator
  • 7=OS X Translator.

SWPlatform

smallint

The platform under which a software product runs. See "Notes" below.

NotInUse

smallint

No

True(1) indicates if the product is a local product that has been reconciled into another product; else 0.

Classification

smallint

No

The classification of a product: 0=hardware, 1=software.

Platform

smallint

No

The platform. See "Notes" below.

Language

smallint

No

The language. See "Notes" below.

IsCodeValid

smallint

No

True(1) indicates if the code is valid; else 0.

IsMerged

smallint

No

True(1) indicates if the local product has been merged into the product KB files; else 0.

DistributionModel

 

smallint

 

How the product is sold:

  • 0 = Unknown
  • 1 = Commercial
  • 2 = Freeware
  • 3 = Shareware
  • 4 = Open Source
  • 5 = Multiple
  • 6 = Public Domain

LicenseProductType

 

smallint

 

The type of license that is associated with the software:

  • 0 = Unknown
  • 1 = Full
  • 2 = Eval
  • 3 = OEM
  • 4 = Multiple
  • 5 = Network

CurrentManufacturer

 

nvarchar(35)

 

 

CreateDate

DateTime

The time and date the product was created.

DateLastModified

DateTime

The time and date the product was last modified by a ZENworks Asset Management User.

IsDeleted

DateTime

The date and time the record was deleted;else null.

ADF0

 

nvarchar(256)

 

Description of "Administrator Defined Field 0"

ADF1

 

nvarchar(256)

 

Description of "Administrator Defined Field 1"

ADF2

 

nvarchar(64)

 

Description of "Administrator Defined Field 2"

ADF3

 

nvarchar(64)

 

Description of "Administrator Defined Field 3"

ADF4

 

nvarchar(64)

 

Description of "Administrator Defined Field 4"

ADF5

 

nvarchar(64)

 

Description of "Administrator Defined Field 5"

ADF6

 

nvarchar(64)

 

Description of "Administrator Defined Field 6"

ADF7

 

nvarchar(64)

 

Description of "Administrator Defined Field 7"

ADF8

 

nvarchar(64)

 

Description of "Administrator Defined Field 8"

ADF9

 

nvarchar(64)

 

Description of "Administrator Defined Field 9"

ADF10

 

nvarchar(64)

 

Description of "Administrator Defined Field 10"

ADF11

 

nvarchar(64)

 

Description of "Administrator Defined Field 11"

ADF12

 

nvarchar(64)

 

Description of "Administrator Defined Field 12"

ADF13

 

nvarchar(64)

 

Description of "Administrator Defined Field 13"

ADF14

 

nvarchar(64)

 

Description of "Administrator Defined Field 14"

ADF15

 

nvarchar(64)

 

Description of "Administrator Defined Field 15"

ADF16

 

nvarchar(64)

 

Description of "Administrator Defined Field 16"

ADF17

 

nvarchar(64)

 

Description of "Administrator Defined Field 17"

ADF18

 

nvarchar(64)

 

Description of "Administrator Defined Field 18"

ADF19

 

nvarchar(64)

 

Description of "Administrator Defined Field 19"

NOTE:

  • The ProductType can be one of the following:

    1

    BIOS

    16

    Partition

    2

    CPU

    17

    Printer

    3

    CD-ROM

    18

    Bus Adapter

    4

    DMI

    19

    Serial Port

    5

    Floppy

    20

    Sound Card

    6

    Hard Disk

    21

    Software

    7

    Keyboard

    22

    System

    8

    LAN Adapter

    23

    System Board

    9

    Memory Module

    24

    Video Adapter

    10

    Modem

    25

    Removable Media

    11

    Monitor

    26

    Other

    12

    Mouse

    29

    Hot Fix

    13

    Network Driver

    30

    USB Port

    14

    Current Operating System

    31

    Docking Station

    15

    Parallel port

  • SWPlatform and Platform can have one of the following values:

    0

    DOS

    1

    Windows 3.x

    2

    Windows 95

    3

    Windows 98

    4

    Windows 32-bit

    5

    Windows NT

    6

    Windows 9x

    7

    OS/2

    8

    Unassigned

    9

    Palm OS

    10

    Windows 2000

    11

    Windows XP

    12

    UNIX

    13

    OS X

    14

    Windows Vista

  • Language can have one of the following values:

    1

    Afrikaans

    15

    Hungarian

    2

    Arabic

    16

    International

    3

    Chinese

    17

    Italian

    4

    Simple Chinese

    18

    Japanese

    5

    Traditional Chinese

    19

    Korean

    6

    Danish

    20

    Norwegian

    7

    Dutch

    21

    Polish

    8

    English (U.K.)

    22

    Portuguese

    9

    English (U.S.)

    23

    Brazilian Portuguese

    10

    Finnish

    24

    Russian

    11

    French

    25

    Spanish

    12

    German

    26

    Swedish

    13

    Greek

    27

    Turkish

    14

    Hebrew

  • The ProductCategoryOID foreign key references the ProductCategoryOID primary key column of the NC_ProductCategory table.

  • ProductType + Manufacturer + Product + Model + Source + Language + IsDeleted has a unique constraint named UQ_Product_Names.