1.6

Table Of Contents
Table 9-2. Space Calculation Scripts
Script Description
spaceCostData
This script returns the amount of space that can be retrieved by purging the cost data that is older
than the specified number of months.
spaceHierarchyData
This script returns the amount of space that can be retrieved by purging the hierarchy data that
is older than the specified number of months.
spaceReportData
This script returns the amount of space that can be retrieved by purging the report data that is
older than the specified number of months.
spaceTablesData
This script returns the amount of space that can be retrieved by purging the cost, hierarchy, and
report data that is older than the specified number of months.
spaceStatsData
This script returns the amount of space that can be retrieved by purging the performance statistics
data (from the CB_VC_PERFORMANCE_STAT table) that is older than the specified number of
months.
Data Purging Scripts
The data purging scripts enable you to remove data older than the specified number of months from the vCenter
Chargeback database tables.
Prerequisites for Running the Data Purging Scripts
You must have the SELECT and DELETE permissions on the vCenter Chargeback database tables to run the
data purging scripts. Before you run the scripts, take a backup of the vCenter Chargeback database.
About the Data Purging Scripts
Table 9-3 lists the data purging scripts provided with vCenter Chargeback.
Table 9-3. Data Purging Scripts
Script Description
purgeCostData
This script removes the cost-related data that is older than the specified number of months. The
number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script. The script removes the data from the following tables:
n
CB_BASE_RATE
n
CB_BILLING_POLICY
n
CB_ENTITY_METERING
n
CB_RATE_FACTOR
n
CB_FIXED_COST
purgeHierarchyData
This script removes the hierarchy-related data that is older than the specified number of months.
The number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script. The script removes the data from the following tables:
n
CB_VC_ENTITY_RELATION
n
CB_VC_ENTITY_PROPERTY
n
CB_VC_ENTITY_MAPPING
n
CB_HIERARCHY_RELATION
purgeReportData
This script removes the report-related data that is older than the specified number of months
from the CB_REPORT table. The number of months is specified using the MONTHS_IN_HISTORY
parameter in the Oracle script and the @MONTHS_IN_HISTORY parameter in the SQL Server script.
You can set this parameter appropriately before running the script.
vCenter Chargeback User’s Guide
136 VMware, Inc.