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-6. Column Details of the Performance Statistics Database View (Continued)
Column Name Data Type Nullable Description
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.
After the view is created, you can run SELECT queries on the view to obtain the necessary information.
Table 8-7 shows the sample output for a SELECT query on the CB_VIEW_VC_STAT_INVENTORY view.
Table 8-7. 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
vCenter Chargeback Manager User’s Guide
146 VMware, Inc.