5.0

Table Of Contents
sourcedbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
sourcedbUrl=jdbc\:sqlserver\://192.168.1.130\:1433
sourcedbName=sa
sourcedbUserName=testSourceDB
sourcedbPassword=111
#source FSDB
sourcefsdbDriver=com.integrien.fsdbjdbcdriver.FSDBJDBCDriver
sourcefsdbUrl=rmi\://192.168.1.130\:1199/DBMS
#destination DB
destdbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
destdbUrl=jdbc\:sqlserver\://192.168.1.120\:1433
destdbName=sa
destdbUserName=testDestDB
destdbPassword=111
encrypted=false
#incremental = false means full for maxDays days
incremental = false
maxDays = 365
retryConnectCount = 5
#milliseconds
delayBetweenRetries = 10000
exportToCsv = true
csvFilePath = C:/csv.csv
csvDelimiter = ,
insertCommand Statement
You use the insertCommand statement in the conf.properties file to define where the Repository Adapter puts
exported data.
The insertCommand statement contains two sets of values in parentheses. The first set of values defines the
columns in the output database. The second set of values, which appears after values in the statement, defines
the source columns in the vCenter Operations Manager database and FSDB.
Field names that start with alive come from the vCenter Operations Manager database.
Table 11-2. vCenter Operations Manager Database Fields
Field Contents
alive.RID
Resource ID.
alive.RNAME
Resource name.
alive.MID
Metric ID.
alive.MNAME
Metric name.
alive.RKNAME
Resource kind name.
alive.MKNAME
Metric kind name.
alive.AKNAME
Adapter kind name.
Field names that start with fsdb come from the vCenter Operations Manager FSDB.
Table 11-3. vCenter Operations Manager FSDB Fields
Field Contents
fsdb.timestamp
Time of the metric value.
fsdb.min_threshold
Minimum threshold for the metric.
Chapter 11 Using System Tools
VMware, Inc. 133