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
These SQL scripts can be run from the SQL prompt by any database user having the required permissions.
These scripts are packaged with the application and are located in the following folders:
n
For SQL Server
Installation_Directory
\Database Scripts\main\
version
\mssql\gos-license-accounting
The script names are of the form
script_name_mssql
.sql.
n
For Oracle
Installation_Directory
\Database Scripts\main\
version
\oracle\gos-license-accounting
The script names are of the form
script_name_oracle
.sql.
Installtion_Directory refers to the complete path of the folder in which vCenter Chargeback Manager is installed.
version refers to a folder that has version number as the folder name. For example, v2.0.
Guest OS Licensing Script
The guest OS licensing script helps you identify the operating system running on a virtual machine and the
corresponding memory and vCPU details for that virtual machine. The script considers only the virtual
machines that are part of any hierarchy created in vCenter Chargeback Manager.
Running the Guest OS Licensing Script in SQL Server
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_GOS_LICENSE_INVENTORY database view.
n
The CB_FN_GOS_LICENSE_PAYG function.
The CB_VIEW_GOS_LICENSE_INVENTORY view contains the guest OS details and the corresponding memory,
vCPU, and power state details for all the virtual machines that are part of any hierarchy created in vCenter
Chargeback Manager. Table 8-2 lists the details of the columns in the CB_VIEW_GOS_LICENSE_INVENTORY view.
Table 8-2. Column Details of the GOS Licensing 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.
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 four rows, one each for the following
resource types:
n
VM_STATE: The power state of the virtual machine.
n
VM_MEM_SIZE: Amount of memory utilized in MB.
n
VM_VCPU_COUNT: Number of vCPUs.
n
VM_GUEST_FULL_NAME: Name of the guest operating
system running on the virtual machine.
RESOURCE_VAL
UE
NVARCHAR2(255
CHAR)
No The value for the resource.
Chapter 8 Administration Utilities
VMware, Inc. 141