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
After the view is created, you can run SELECT queries on the view to obtain the necessary information.
Table 8-6 shows the sample output for a SELECT query on the CB_VIEW_VC_STAT_INVENTORY view.
Table 8-6. Sample Output for a SELECT Query on the CB_VIEW_VC_STAT_INVENTORY View
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 CPU 606 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Memory 2472619 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Disk Read and
Write
228 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Disk Read 5 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Disk Write 222 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Network
Received and
Transmitted
166 8/29/11
2:00
8/29/11
4:00
VM01 vm-444
2
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
DB Hierarchy 1 Network
Received
77 8/29/11
2:00
8/29/11
4:00
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.
Chapter 8 Administration Utilities
VMware, Inc. 133