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
Table 8-7. Sample Output for a SELECT Query on the CB_VIEW_VC_STAT_INVENTORY View (Continued)
VM_NA
ME
VM_M
OID
VC_SERVER_U
UID
HIERARCHY_
NAME
RESOURCE_TY
PE
RESOURCE_
VALUE
START_
TIME
END_TIM
E
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Network
Transmitted
87 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Storage 4096 8/29/11
2:00
8/29/11
4:00
The CB_FN_VC_STAT_PAYG function returns the average usage details of different resources for all the virtual
machines in a given hierarchy in the Pay As You Go model. You must provide values for the following input
parameters when running the function:
n
hierarchy name: Name of the hierarchy for which the virtual machine details must be retrieved.
n
start time: The start time in the format YYYY-MM-DD hh:mm:ss:mls.
n
end time: The end time in the format YYYY-MM-DD hh:mm:ss:mls.
For example,
SELECT * from CB_FN_VC_STAT_PAYG('Test Hierarchy', '2011-01-14 00:00:00.000', '2011-07-14
23:59:59.999');
The function returns values similar to the output of a SELECT query on the CB_VIEW_VC_STAT_INVENTORY database
view. However, in this case the data for only a given hierarchy and for a specific duration is returned.
NOTE The CB_FN_VC_STAT_PAYG function assumes 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.
Running the Guest OS Licensing Script in Oracle
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. The CB_FN_VC_STAT_PAYG
function returns the average usage details of different resources for all the virtual machines in the Pay As You
Go model for a given hierarchy ($hierarchy_name) and for the specified time period ($start_time : $end_time).
Table 8-6 lists the details of the columns in the CB_VIEW_VC_STAT_INVENTORY database view. The
CB_VIEW_VC_STAT_PAYG function returns values similar to the output of a SELECT query on the
CB_VIEW_VC_STAT_INVENTORY database view. However, in this case the data for only a given hierarchy and for
a specific duration is returned.
For example,
SELECT * from TABLE(CB_FN_VC_STAT_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_VC_STAT_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.
Chapter 8 Administration Utilities
VMware, Inc. 147