How to configure and use CSV Data Collector in Control Compliance Suite 9.0
Article ID: 151896
Updated On:
Products
Control Compliance Suite Windows
Issue/Introduction
Resolution
STEP 1
To configure the CSV data collector
Go to Settings > System Topology
Do one of the following:
In the System Topology > Map View, right-click a registered DPS component 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 the CSV data collector.
The fields and the descriptions are as follows:
Platform : Enter the platform of the application whose data is to be queried. (You can use the drop-down box to select the platform of the application)
CSV File(s) Path : Enter the path where the CSV file is placed. 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 UNC format,\\\\\.csv.
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.
Click OK.
STEP 2
To export and use CSV Headers do the following:
Go to Manage > Assets > Asset System.
Select an asset type from the Display drop-down list (e.g. Windows Machines)
From the Asset Tasks in the taskbar , select Export CSV Headers
Select the location where you want to save the CSV file. (It has to be a shared location)
Click Save.
STEP 3
Modifying the CSV file e.g. a Machines CSV file
NOTE: CSV does not support comments. Delete the lines till the last header line.
The CSV file created in Step 2 will need to be modified depending on the customers requirement. The minimum headers that you need to keep in a machines CSV file are:
Wnt.Machine.DomainWorkgroupName,Wnt.Machine.HostName,Wnt.Machine.OSMajorVersionNumber, Wnt.Machine.OSMinorVersionNumber,Wnt.Machine.OSVersionType,Wnt.Machine.Server,Wnt.Machine.BDC,Wnt.Machine.PDC,Wnt.Machine.HostMachineInDomain
The Description of these items is as follows:
Domain/Workgroup Name = Wnt.Machine.DomainWorkgroupName
This field returns the name of the domain or Workgroup of which the machine is a member. This field obtains the name from the Query Engine's reporting domain settings. Use the field 'Domain / Workgroup Name (Machine Setting)' to determine the domain or Workgroup that the machine is a member of.
Machine Name = Wnt.Machine.HostName
This field returns the Pre-Windows 2000 computer name of the machine.
OS Major Version Number = Wnt.Machine.OSMajorVersionNumber
This field returns the major version number of the machine's NT operating system. Ex. For NT 3.51 the major version is 3. The "OS Major Version Number (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
OS Minor Version Number = Wnt.Machine.OSMinorVersionNumber
This field returns the minor version number of the machine's NT operating system. Ex. For NT 3.51 the minor version is 51. The "OS Minor Version Number (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
OS Type = Wnt.Machine.OSVersionType
This field returns machine's Windows operation system type. It also indicates if the machine has Terminal Services capability.
Machine Is Server = Wnt.Machine.Server
This field returns true if the machine is running the NT Server operating system. The "Machine Is Server? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Machine Is BDC = Wnt.Machine.BDC
This field returns true if the machine is a backup domain controller. The "Machine Is BDC? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Machine Is PDC = Wnt.Machine.PDC
This field returns true if the machine is a primary domain controller. The "Machine Is PDC? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Member of Domain = Wnt.Machine.HostMachineInDomain
This field returns true if the machine is a member of a domain.
A typical row in a machine CSV file would look like this:
Symantec,User_One,5,2,WINDOWS SERVER 2003,TRUE,FALSE,TRUE,TRUE
You can add any number of rows here in this format and do an Asset import Job by choosing 'CSV data collector' in the 'Data Collector' box of the 'Select Platform, Asset type and Data Collector' screen of the Asset Import Wizard.
To configure the CSV data collector
Go to Settings > System Topology
Do one of the following:
In the System Topology > Map View, right-click a registered DPS component 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 the CSV data collector.
The fields and the descriptions are as follows:
Platform : Enter the platform of the application whose data is to be queried. (You can use the drop-down box to select the platform of the application)
CSV File(s) Path : Enter the path where the CSV file is placed. 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 UNC format,\\
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.
Click OK.
STEP 2
To export and use CSV Headers do the following:
Go to Manage > Assets > Asset System.
Select an asset type from the Display drop-down list (e.g. Windows Machines)
From the Asset Tasks in the taskbar , select Export CSV Headers
Select the location where you want to save the CSV file. (It has to be a shared location)
Click Save.
STEP 3
Modifying the CSV file e.g. a Machines CSV file
NOTE: CSV does not support comments. Delete the lines till the last header line.
The CSV file created in Step 2 will need to be modified depending on the customers requirement. The minimum headers that you need to keep in a machines CSV file are:
Wnt.Machine.DomainWorkgroupName,Wnt.Machine.HostName,Wnt.Machine.OSMajorVersionNumber, Wnt.Machine.OSMinorVersionNumber,Wnt.Machine.OSVersionType,Wnt.Machine.Server,Wnt.Machine.BDC,Wnt.Machine.PDC,Wnt.Machine.HostMachineInDomain
The Description of these items is as follows:
Domain/Workgroup Name = Wnt.Machine.DomainWorkgroupName
This field returns the name of the domain or Workgroup of which the machine is a member. This field obtains the name from the Query Engine's reporting domain settings. Use the field 'Domain / Workgroup Name (Machine Setting)' to determine the domain or Workgroup that the machine is a member of.
Machine Name = Wnt.Machine.HostName
This field returns the Pre-Windows 2000 computer name of the machine.
OS Major Version Number = Wnt.Machine.OSMajorVersionNumber
This field returns the major version number of the machine's NT operating system. Ex. For NT 3.51 the major version is 3. The "OS Major Version Number (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
OS Minor Version Number = Wnt.Machine.OSMinorVersionNumber
This field returns the minor version number of the machine's NT operating system. Ex. For NT 3.51 the minor version is 51. The "OS Minor Version Number (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
OS Type = Wnt.Machine.OSVersionType
This field returns machine's Windows operation system type. It also indicates if the machine has Terminal Services capability.
Machine Is Server = Wnt.Machine.Server
This field returns true if the machine is running the NT Server operating system. The "Machine Is Server? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Machine Is BDC = Wnt.Machine.BDC
This field returns true if the machine is a backup domain controller. The "Machine Is BDC? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Machine Is PDC = Wnt.Machine.PDC
This field returns true if the machine is a primary domain controller. The "Machine Is PDC? (Browser)" field is a faster method of retrieving the same information but avoids directly accessing the machine by getting the data from the browser if the browser is available.
Member of Domain = Wnt.Machine.HostMachineInDomain
This field returns true if the machine is a member of a domain.
A typical row in a machine CSV file would look like this:
Symantec,User_One,5,2,WINDOWS SERVER 2003,TRUE,FALSE,TRUE,TRUE
You can add any number of rows here in this format and do an Asset import Job by choosing 'CSV data collector' in the 'Data Collector' box of the 'Select Platform, Asset type and Data Collector' screen of the Asset Import Wizard.
Feedback
Yes
No
Powered by
