|
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 |
1 (TRUE) 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 |
1 (TRUE) if the code is valid; else 0. |
|
IsMerged |
|
smallint |
No |
1 (TRUE) 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" |