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-4. Column Details of the Storage Allocation 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.
RESOURCE_TYPE NVARCHAR2(255
CHAR)
No The type of resource. Applicable value is Storage.
RESOURCE_VAL
UE
NUMBER(19,4) No Storage allocation value in KB.
START_TIME DATETIME No 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-5 shows the sample output for a SELECT query on the CB_VIEW_STORAGEALLOC_INVENTORY view.
Table 8-5. Sample Output for a SELECT Query on the CB_VIEW_STORAGEALLOC_INVENTORY View
VM_NAM
E
VM_MOI
D
VC_SERVER_U
UID
RESOURCE
_TYPE
RESOURCE_
VALUE START_TIME END_TIME
vm01 vm-1044 7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Storage 80 28-AUG-11
07.12.56 PM
30-NOV-99 11.59.59
PM
vm02 vm-4417 7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Storage 80 30-AUG-11
10.53.57 AM
30-NOV-99 11.59.59
PM
vm03 vm-4418 7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Storage 80 30-AUG-11
10.54.04 AM
30-NOV-99 11.59.59
PM
vm04 vm-1049 7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Storage 80 30-AUG-11
10.54.38 AM
30-NOV-99 11.59.59
PM
The CB_FN_STORAGE_ALLOC_PAYG function returns the storage allocation details 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_STORAGE_ALLOC_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_STORAGEALLOC_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_STORAGE_ALLOC_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.
vCenter Chargeback Manager User’s Guide
144 VMware, Inc.