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
For example,
SELECT * from TABLE(CB_FN_STORAGE_ALLOC_PAYG('Test Hierarchy',to_timestamp('20110114 00:00:00',
'YYYYMMDD HH24:MI:SS'), to_timestamp('20110714 23:59:59', 'YYYYMMDD HH24:MI:SS')));
NOTE The CB_FN_STORAGE_ALLOC_PAYG function is created based on the assumption that all the virtual machines
in vCenter Chargeback Manager under the Pay as You Go model for any hierarchy organization is present
under Pay as You Go > Any_OrgVDC > vApps Folder > vApps.
Performance Statistics Script
The performance statistics script helps you obtain the average resource usage details for the virtual machines
that are part of any hierarchy created in vCenter Chargeback Manager.
Running the Guest OS Licensing Script in SQL Server
You must have the SELECT permission on the tables in the vCenter Chargeback Manager database to run the
guest OS licensing script.
On running the script, two database objects are created.
n
The CB_VIEW_VC_STAT_INVENTORY database view.
n
The CB_FN_VC_STAT_PAYG function.
The CB_VIEW_VC_STAT_INVENTORY view contains the average usage details of different resources for all the virtual
machines that are part of any hierarchy created in vCenter Chargeback Manager. Table 8-5 lists the details of
the columns in the CB_VIEW_GOS_LICENSE_INVENTORY view.
Table 8-5. Column Details of the Performance Statistics Database View
Column Name Data Type Nullable Description
VM_NAME NVARCHAR2(255
CHAR)
No Name of the virtual machine.
VM_MOID NVARCHAR2(255
CHAR)
No Managed Object ID of the virtual machine.
VC_SERVER_UUI
D
NVARCHAR2(255
CHAR)
No UUID of the vCenter Server on which the virtual machine
exists.
HIERARCHY_NA
ME
NVARCHAR2(255
CHAR)
No Name of the chargeback hierarchy in which the virtual
machine exists.
RESOURCE_TYPE NVARCHAR2(255
CHAR)
No The type of resource. For each virtual machine, the view
contains at least nine rows, one each for the following
resource types:
n
Average CPU usage in MHz.
n
Average memory consumed in KB.
n
Average disk read and write in KB/s.
n
Average disk read in KB/s.
n
Average disk write in KB/s.
n
Average network received and transmitted in KB/s.
n
Average network received in KB/s.
n
Average network transmitted in KB/s.
n
Average storage usage in KB.
RESOURCE_VAL
UE
NUMBER No The value for the resource.
START_TIME DATETIME Yes The start time for the resource type.
END_TIME DATETIME Yes The end time for the resource type or the end time of the
virtual machine in the hierarchy, whichever is earlier.
vCenter Chargeback Manager User’s Guide
132 VMware, Inc.