After you export the assets and the data that is related to the assets into a CSV file, you must arrange them in a specific format. A single CSV file can contain assets that belong to a specific asset type. Assets can belong either to a predefined asset type or to the asset types that are defined by you through Control Compliance Suite.
The CSV file must contain headers under which the assets along with the data that is related to the assets are arranged. A header is defined containing the name of the platform, the name of the asset type or entity, and the property or field that defines the asset. For every asset, you scan categorize the properties or fields into asset-specific and common.
The format of the headers for the asset-specific and common fields are as follows:
The asset-specific fields of an asset type comprise the unique identifiers of the asset type along with all fields that define the asset type.
The header format for the asset-specific fields is as follows:
The details of the fields are as follows:
The platform header represents the platform to which the asset type belongs. For example, the platform of a predefined asset type, Windows Domain is Windows.
The properties of the asset are Host (computer name), IP address, and DomainName.
Every asset is identified easily with their unique identifiers such as IP address, machine name, or domain name. In Control Compliance Suite, these identifiers are known as primary and mandatory fields. You must identify the primary and mandatory fields of an asset type during creation. These primary and mandatory fields are a part of the asset-specific fields and must be specified in the CSV file for every asset.
The common fields of an asset type are confidentiality, integrity, availability, and tags.
The header format for the common fields is as follows:
An example header format for the common fields of an asset type, Windows Domain is as follows:
The common fields of the asset are confidentiality and integrity.
For the predefined asset types, you can retrieve the headers directly into a CSV file from the Asset View of the console. You can use the option, Export CSV Headers of the Asset View to export the headers into the CSV file.
For example, the assets that belong to a predefined asset type, Windows File, the headers that are exported using the option, Export CSV Headers are as follows:
To import assets of the asset type, Windows File with directory as the scope using the CSV data collector, add a new column in the CSV file. The column, WntFile.PARENTDIRECTORYINT is added in the CSV file besides the other fields that are required for the asset type. The data for this column must contain the directory names, which are specified as the scope during the asset import.
For the custom applications, you need to define the headers for the asset type through the Create New Entity Schema wizard.