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-2. Column Details of the GOS Licensing Database View (Continued)
Column Name Data Type Nullable Description
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-3 shows the sample output for a SELECT query on the CB_VIEW_GOS_LICENSE_INVENTORY view.
Table 8-3. Sample Output for a SELECT Query on the CB_VIEW_GOS_LICENSE_INVENTORY View
VM_NA
ME
VM_M
OID
VC_SERVER_U
UID
HIERARCHY_
NAME
RESOURCE_TY
PE
RESOURCE_
VALUE
START_
TIME
END_TI
ME
vm01 vm-104
4
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Dev-Hierarchy VM_STATE poweredOff 2011-06-0
1
12:12:21.4
63
vm01 vm-104
4
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Dev-Hierarchy VM_MEM_SIZE 2668 2011-06-0
1
12:12:21.4
63
vm01 vm-104
4
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Dev-Hierarchy VM_VCPU_COU
NT
1 2011-06-0
1
12:12:21.4
63
vm01 vm-104
4
7BF5FFD5-
F56C-4205-808D-
329BB92636F0
Dev-Hierarchy VM_GUEST_FUL
L_NAME
Red Hat
Enterprise
Linux 5 (64-
bit)
2011-06-0
1
12:12:21.4
63
vm02 vm-112 07F6FF05-9546-4
D01-
B9C0-0170AA21
9579
QA-Hierarchy VM_STATE poweredOn 2011-06-0
1
12:12:21.4
63
vm02 vm-112 07F6FF05-9546-4
D01-
B9C0-0170AA21
9579
QA-Hierarchy VM_MEM_SIZE 4096 2011-06-0
1
12:12:21.4
63
vm02 vm-112 07F6FF05-9546-4
D01-
B9C0-0170AA21
9579
QA-Hierarchy VM_VCPU_COU
NT
2 2011-06-0
1
12:12:21.4
63
vm02 vm-112 07F6FF05-9546-4
D01-
B9C0-0170AA21
9579
QA-Hierarchy VM_GUEST_FUL
L_NAME
Microsoft
Windows
Server 2003
(32-bit)
2011-06-0
1
12:12:21.4
63
The CB_FN_GOS_LICENSE_PAYG function returns the guest OS details and the corresponding memory, vCPU, and
power state 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.
vCenter Chargeback Manager User’s Guide
142 VMware, Inc.