Configuring Common platform through CSV settings

In Control Compliance Suite, data for the common fields such as Confidentiality, Integrity, Availability and so on of a predefined asset type is not collected by the default data collector. To collect data for the common fields, you must manually create a CSV file and define all the common fields in a specific format. You must then configure a DPS as a CSV data collector to collect data for the common fields of the predefined asset type. So, to import the predefined asset types even if you select a default data collector you still require a CSV data collector to collect the common fields data.

The overall sequence to collect data for the common fields of an asset type are as follows:

Export the data fields of an asset type into a CSV file.
Create a CSV file that contains the data for the common fields.

See Common fields for all asset types.

Ensure that you know the primary fields of the predefined asset type for which the common fields are to be specified in the CSV file. The primary fields are asset type identifiers that are used to map the common fields of the asset type correctly. For example, for the predefined asset type, Windows directory of the predefined platform, you must know the primary fields, Host and DomainName.

See Predefined asset types.
Configure the CSV data collector.

See Configuring the CSV data collector.

Note:

Ensure that you select the platform, Common in the Common settings dialog box for configuring the CSV data collector.
Import the asset type using the Asset Import wizard.

See About the working of default data collectors in asset import.

To create and configure the common fields of an asset type through CSV settings

Select the platform and the asset type for which the common fields are to be defined.
Get the primary fields of the asset type.

If you want to specify the common fields of the predefined asset types, then you must know the primary fields of those asset types.

See Predefined asset types.

Create a CSV file with headers in the following format:

<platform.entity.primaryfield1>, <platform.entity.primaryfield2>, <Common.platformentity.baseattributefield1>, <Common.platform.entity.baseattributefield2>

For example, for the common fields of a predefined asset type, Windows directory, the CSV file headers are as follows:

Wnt.Domain.DomainName, Wnt.Domain.Host, Common.WntDomain.Confidentiality, Common.WntDomain.Integrity,...

Here, DomainName and Host are the primary fields of the predefined asset type and Wnt is the platform.

For an asset type, it is important that you ensure the correct correlation between the primary fields and the common fields. The data of the common fields correspond to the assets, whose unique identifiers are the primary fields.

For example, for an asset type, Windows directory, the data representation for the primary and common fields in the CSV file are as follows:

Wnt.Domain.DomainName	Wnt.Domain.HostName	Common.WntDomain.Confidentiality	Common.WntDomain.Integrity
TestDomain	Test1Machine	High	High
TestDomain	Test2Machine	Low	High

As per the example, common fields data for the assets, Test1Machine and Test2Machine are collected.

Place the CSV file in the network share path of the Windows computer.
In the console, go to System Topology > Grid View.

Right-click the Data Collection Service and click Edit Settings.
In the Components settings dialog box, select CSV under the Data Collector Sites option on the left pane of the dialog box.
Select the site to which the DPS is registered from the Site Name drop-down box on the right side pane of the dialog box.

Enter values for the fields to configure a DPS as a CSV data collector.

The fields and the descriptions are as follows:

Platform	Select the platform, Common from the drop-down box.
CSV File(s) Path	Enter the path where the CSV file is located. Click the browse button and in the Browse for folder dialog box, browse to the path where the CSV file is located. You must ensure that the CSV file path is specified in the format, \\<server name>\<folder name of the CSV file>. If a CSV file is shared on a DPS computer, which is configured as a data collector, then ensure that the user has either log on locally or log on as a batch job permission. This permission is required for the CSV data collector of both the single setup and distributed setup modes.
Windows Domain	Enter the domain of the Windows computer, where the CSV file is located. You need to provide the credentials of the Windows domain user in the dialog box, Credentials for the Platform.
User Name	Enter the user name of the specific domain.
Search Pattern	Enter the search pattern of the CSV file. For example, in a given share path there can be several CSV files for the same platform. In such a case, if you want to have data from the CSV file that starts with the alphabet, m, then the search option can be, m*.csv.
File Encoding	Enter the encoding type of the file. For example, Unicode (UTF -8). You can use the drop-down box to select the unicode of the CSV file.

Click Apply and OK
In the console, go to Settings > System Topology > Map View and click Infrastructure Tasks > Sync Configuration.