2.5
Table Of Contents
- vCenter Chargeback Manager User’s Guide
- Contents
- About the User's Guide
- Introduction to vCenter Chargeback Manager
- Configuring Administration Settings
- Authenticating and Managing Users, Roles, and Permissions
- Resource Based Authorization in vCenter Chargeback Manager
- Permissions Defined in vCenter Chargeback Manager
- Managing Roles
- Managing Users
- vCenter Chargeback Manager User Authentication
- Managing Chargeback Hierarchies
- Creating a Chargeback Hierarchy
- Managing a Chargeback Hierarchy
- View a Chargeback Hierarchy
- Add a vCenter Chargeback Manager Entity
- Add a vCenter Server Entity
- Rename a Chargeback Hierarchy or a Chargeback Entity
- Delete an Entity from the Hierarchy
- Delete a Chargeback Hierarchy
- Assign Attributes
- Move Entities Within a Hierarchy
- Allocate Computing Resource Units for a Chargeback Entity
- Share Virtual Machine Cost
- Backdate a Chargeback Hierarchy
- View Properties of a vCenter Server Entity
- Managing and Configuring vCenter Chargeback Manager Cost Elements
- Generating Reports
- Monitoring System Health
- Administration Utilities
- Index
About the Space Calculation Scripts
Table 8-9 lists the space calculation scripts provided with vCenter Chargeback Manager.
Table 8-9. 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 Manager database tables.
Prerequisites for Running the Data Purging Scripts
You must have the SELECT and DELETE permissions on the vCenter Chargeback Manager database tables
to run the data purging scripts. Before you run the scripts, take a backup of the vCenter Chargeback Manager
database.
About the Data Purging Scripts
Table 8-10 lists the data purging scripts provided with vCenter Chargeback Manager.
Table 8-10. 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
Chapter 8 Administration Utilities
VMware, Inc. 149