About Product Compliance Database Design

The compliance database is a tab-delimited ASCII text file located in the SMS\Prodcomp directory on your site server. This file is tab-delimited with character returns at the end of each product. A single tab separates each column, even if a column is empty. To keep your compliance database dynamic, you can:

Product Compliance Fields

The following table lists the fields in the product compliance database. The first six fields are friendly fields.

Important     Primary keys must match those already in your database during information imports.

WBEM property name and display name Description Maximum length
ProdName, Name Enables you to give an easily identified name to the product. When the product is displayed in the SMS Administrator console, the Product Name, Version, and Revision make up the complete product name. This field might be empty when you import compliance information. Text, 35 characters
ProdVer, Version Contains the product version. This field might be blank when you import compliance information. Text, 30 characters
ProdRev, Revision Enables you to identify the specific revision within the product version. Many products have several service packs in which the version stays the same, but the revision is increased through a letter or a number. This field might be empty when you import compliance information. Text, 30 characters
ProdCompany, Company Enables you to identify the company that produces each product. This field might be empty when you import compliance information. Text, 35 characters
ProdLang, Language Identifies the language of the product. This field might be empty when you import compliance information. If there is no information in the file being imported, SMS will attempt to use the HDR-Prod ID to map to the appropriate language; otherwise, "Unknown" will be entered for this field. Text, 35 characters
ProdPlatform, Platform Identifies the platform that the product was written for. This field might be empty when you import compliance information. If there is no information in the file being imported, "Unknown" will be entered for this field. Text, 35 characters
Source, Data Source Identifies where the database information for each line was obtained. If no information source is available when you import compliance information, your domain and user name in the format domain\username is used as the information source. Text, 50 characters
ResProdName, Product Name Identifies the product name exactly as it appears in the .exe file header. Text, 100 characters
ResProdVer Identifies the product version exactly as it appears in the .exe header. Text, 50 characters
ResProdLangID, Product Language ID Identifies the language ID for the product. SMS queries use the value 65535 for this field. During download, this field is ignored when the record match is occurring. As a result, if a product is listed as being compliant in all languages, the compliance data will be applicable to all language versions of that particular product. Numeric
FileName, File Name Identifies the complete product file name. Text, 255 characters
FileSize, File Size Lists the size of the file in bytes. Database integer, 4 characters
Type, Compliance Type Differentiates one type of compliance from another. Note that Y2K might have different compliance categories than other compliance types. Any record that does not have information in this field cannot be imported into the compliance database. Text, 20 characters
Category, Compliance Level Contains the various defined category types. For example, the Microsoft Year 2000 Resource Center has identified five values for Y2K compliance information. These strings must be exactly:
Testing yet to be completed
Will not test
Not compliant
Compliant with minor issues
Compliant Euro compliance and other compliance types might have different values for compliance levels. Any record that does not have information in this field cannot be imported into the compliance database.
Text, 30 characters
URL, URL Lists the Uniform Resource Locator (URL) path where additional information about this product and its compliance can be viewed. This field might be empty when you import compliance information. Text, 255 characters
Comment, Comment Enables you to list additional information about the product. This field might be empty when you import compliance information. Text, 255 characters

Related Topics

Topic Link

View Product Compliance Results

Topic Link

Import Product Compliance Information into Your Database

Topic Link

About Product Compliance Types and Levels

Topic Link

About WBEM Property Names

Topic Link

About the Year 2000 Problem

Topic Link

Product Compliance Overview