2.0
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
Generic Scripts
vCenter Chargeback Manager provides few generic SQL scripts that let you fetch certain statistical data about
the vCenter Chargeback Manager database.
Prerequisites for Running the Generic SQL Scripts
You must have the SELECT permission on the tables in the vCenter Chargeback Manager database to run
these scripts. Before running the generic scripts on an SQL Server database, you must replace $dbName with the
name of the vCenter Chargeback Manager database in the SQL scripts.
About the Generic SQL Scripts
Table 8-7 lists the generic SQL scripts provided with vCenter Chargeback Manager.
Table 8-7. Generic SQL Scripts
Script Name Description
countActiveConns
This script returns the number of active connections to the database.
countRows
This script returns the number of rows in each of the tables in the database.
dbSize
This script return the space occupied by the tables in the database.
Space Calculation Scripts
The space calculation scripts shipped with vCenter Chargeback Manager enable you to calculate the space that
can be retrieved by purging the old data from the database tables.
Prerequisites for Running the Space Calculation Scripts
You must have the SELECT permission on the tables in the vCenter Chargeback Manager database to run the
space calculation scripts. The v_months_in_history parameter in the Oracle scripts and the
@MONTHS_IN_HISTORY parameter in the SQL Server scripts is set to 6 months by default. You can change this in
the scripts to the desired number of months.
About the Space Calculation Scripts
Table 8-8 lists the space calculation scripts provided with vCenter Chargeback Manager.
Table 8-8. 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.
Chapter 8 Administration Utilities
VMware, Inc. 135