vCenter Chargeback Manager User’s Guide vCenter Chargeback Manager 2.5.0 This document supports the version of each product listed and supports all subsequent versions until the document is replaced by a new edition. To check for more recent editions of this document, see http://www.vmware.com/support/pubs.
vCenter Chargeback Manager User’s Guide You can find the most up-to-date technical documentation on the VMware Web site at: http://www.vmware.com/support/ The VMware Web site also provides the latest product updates. If you have comments about this documentation, submit your feedback to: docfeedback@vmware.com Copyright © 2012 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws.
Contents About the User's Guide 5 1 Introduction to vCenter Chargeback Manager 7 What Is Chargeback 7 Chargeback Solution for Virtual Environments Overview of vCenter Chargeback Manager 8 Supported Product Integration 9 7 2 Configuring Administration Settings 11 Activate the Application 11 Configuring Generic Settings 12 Managing LDAP Servers 16 Managing vCenter Servers 18 Managing Data Collectors 24 Managing the Application License 31 Manage Report View 32 Managing Attributes 34 Manage System Health Th
vCenter Chargeback Manager User’s Guide 6 Generating Reports 103 About Reports 103 Generate a Cost Report 106 Generate a Usage Report 108 Generate Cost Comparison Report 109 Generate Showback Report 111 Scheduling Report Generation 113 Managing Reports 119 Managing Archived Reports 124 Managing Automatic Report Scheduler 127 Report Dashboard 129 7 Monitoring System Health 133 Configure System Health Alert Notification vCenter Chargeback Manager Events 135 134 8 Administration Utilities 137 Database P
About the User's Guide The vCenter Chargeback Manager User's Guide provides information about configuring and using the chargeback solution for virtual environments that use VMware Infrastructure or VMware vSphere. Intended Audience This book is intended for anyone who wants to use vCenter Chargeback Manager. The information in this book is written for experienced Windows system administrators who are familiar with virtual machine technology and datacenter operations. VMware, Inc.
vCenter Chargeback Manager User’s Guide 6 VMware, Inc.
Introduction to vCenter Chargeback Manager 1 vCenter Chargeback Manager is an end-to-end cost reporting solution for virtual environments using vSphere. vCenter Chargeback Manager can also be used with VMware vCloud Director. Before you install and start using vCenter Chargeback Manager, an understanding of what is chargeback and about chargeback solutions for a virtual environment would be helpful.
vCenter Chargeback Manager User’s Guide To support chargeback, the virtual environment and the chargeback solution must provide ways to measure resource usage and associate the usage with a specific pricing model. The chargeback solution must also support the use of different pricing models so as to charge the various departments or cost centers differently.
Chapter 1 Introduction to vCenter Chargeback Manager vCenter Chargeback Manager runs on an Apache Tomcat server instance. Users interact with vCenter Chargeback Manager through a load balancer (Apache httpd Server). vCenter Chargeback Manager connects to the vCenter Chargeback Manager database that stores application-specific information, such as the defined chargeback hierarchies, pricing models, users, roles, and so on.
vCenter Chargeback Manager User’s Guide VMware vShield Manager To obtain the usage data associated with the network entities from your vCloud Director setup in to vCenter Chargeback Manager, you must install and configure the vShield Manager data collector. This enables metering and charging for external network bandwidth. VMware vCenter Operations Manager vCenter Chargeback Manager can be integrated with vCenter Operations Manager to generate dashboard reports on vSphere inventories.
Configuring Administration Settings 2 As an administrative user, you can perform various administrative tasks, such as configuring the LDAP and SMTP servers in the application and adding as well as updating vCenter Server information. To perform these administrative tasks, you must have the Super User or Administrator role. The user account details provided during the installation has the Super User role defined on it. Log in to the application by using this administrative user account.
vCenter Chargeback Manager User’s Guide Configuring Generic Settings Before you start using the various features of vCenter Chargeback Manager, you must configure few settings in the application. Some of the generic settings can be configured from the Settings tab. You can configure the SMTP server settings and the log level from the General page of the Settings tab. The General page of the Settings tab lists all the vCenter Chargeback Manager instances added to the cluster.
Chapter 2 Configuring Administration Settings Procedure 1 In the Settings tab, click General. 2 Click Edit in the Email Setting section. The Manage Email Server screen is displayed. 3 4 Modify the required SMTP server settings. Option Description Server HostName Static IP address of the SMTP server. If the sever does not have a static IP address, ensure that you provide the FQDN. Server Port Port number on which the SMTP server is listening for requests.
vCenter Chargeback Manager User’s Guide Procedure 1 In the Settings tab, clickGeneral. 2 In the Log Setting section, select the required log level from the Select Log level list. 3 Option Description trace The trace level is the most informative level providing fine-grained information about the events. debug The debug level provides event information that are most useful to debug an application.
Chapter 2 Configuring Administration Settings What to do next You must run the ModifyLBWorkers.bat file to remove the corresponding vCenter Chargeback Manager entry from the load balancer. Run the following commands from the command-line prompt: > cd Installation_Folder\vCenter-CB-Tools\load-balancer\bin\ > ModifyLBWorkers delete Server_Instance_Name is the complete folder path provided during the vCenter Chargeback Manager installation. The default installation folder is C:\Program
vCenter Chargeback Manager User’s Guide Managing LDAP Servers You can configure one or more LDAP servers in vCenter Chargeback Manager. vCenter Chargeback Manager supports only Microsoft Windows Server 2003 Active Directory and Microsoft Windows Server 2008 Active Directory. You can view and manage the LDAP servers from the LDAP Servers page of the Settings tab. You can also configure the LDAP server for secure communication using SSL certificates.
Chapter 2 Configuring Administration Settings What to do next You can now add the Windows Active Directory users and groups to vCenter Chargeback Manager so that they can access the application using their Windows Active Directory login credentials. To know more about adding LDAP users and groups to the application, see “Creating Users,” on page 47.
vCenter Chargeback Manager User’s Guide 5 Option Description LDAP Limit The maximum number of Windows Active Directory users or groups to be fetched and displayed in the Add User Account screen of the application. Enable LDAPS Select this option to enable LDAP over SSL. Click Save. If you have selected Enable LDAPS during the modify LDAP Server setting operation or the SSL certificate on the LDAP server has changed, then a dialog requesting you to accept the SSL certificate is displayed.
Chapter 2 Configuring Administration Settings Add vCenter Server Information vCenter Chargeback Manager can calculate overall resource utilization and corresponding cost only for vCenter Servers that are added to the application. You can add one or more vCenter Server instances to vCenter Chargeback Manager. You must have the Super User role or the Administrator role to perform this task. IMPORTANT We recommend that you do not add a vCenter Server 5.0 or vCenter Server 5.
vCenter Chargeback Manager User’s Guide 3 Enter information about the vCenter Server and its corresponding database that has to be added to the application. Option Description vCenter Server Hostname/IP FQDN or IP address of the vCenter Server. The IP address or host name cannot be edited after the vCenter Server is added to the application. vCenter Server Display Name A display name for the vCenter Server. vCenter Server Description A description of the vCenter Server. This is optional.
Chapter 2 Configuring Administration Settings 4 Option Description Register As vSphere Client Plug-in Select this option if you would like to register vCenter Chargeback Manager as a plug-in to vSphere Client. If this option is selected, each time you log in to this vCenter Server using the vSphere Client, the vCenter Chargeback Manager plug-in is displayed on the vSphere Client. You can access the vCenter Chargeback Manager from the vSphere Client as a vCenter Server user.
vCenter Chargeback Manager User’s Guide Procedure 1 In the Settings tab, clickvCenter Servers. A table listing information about the vCenter Server instances added to the application is displayed. 2 Select the vCenter Server for which you want to modify the details, and click Edit. The vCenter Server Information screen is displayed. 3 Modify the required vCenter Server details. Option Description vCenter Server Hostname/IP FQDN or IP address of the vCenter Server.
Chapter 2 Configuring Administration Settings 4 Option Description Database Username A database user name to access the vCenter Server database. Ensure that this is not the same user that vCenter Server uses to connect to the vCenter Server database. If you have selected Windows Authentication, then provide a domain user name to access the vCenter Server Database. The domain user name must be of the form user@domain.com or domain\user.
vCenter Chargeback Manager User’s Guide Managing Data Collectors When you install vCenter Chargeback Manager, you can optionally install a data collector. You can register more than one data collector with a vCenter Chargeback Manager instance. You can also install the vCloud Director data collector and the vShield Manager data collector. All the data collectors registered with the application can be managed from the Settings tab. You must have the Super User role to view and manage the data collectors.
Chapter 2 Configuring Administration Settings Registered Data Collectors The Data Collectors page displays a table listing all the synchronization jobs that each registered data collector is running for each vCenter Server added to the application. If multiple data collectors are running, synchronization jobs are equally distributed among them. The data collector runs two types of synchronization jobs: polling jobs and listening jobs.
vCenter Chargeback Manager User’s Guide Table 2-1. Information About Data Collectors Registered in the Application (Continued) Information Type Description Job Type The type of the synchronization job. n n n n n n 26 Storage Synchronization: The data collector obtains the storage information for all the virtual machines managed by the vCenter Server. For vSphere 4.0 and later, the data collector fetches all the files of a virtual machine and the datastore information of each file. For vSphere 5.
Chapter 2 Configuring Administration Settings Modify Job Interval You can control the time interval between two consecutive job runs for jobs that do not run eternally. Ensure that the job interval time specified is sufficient enough to run the job completely. The data collector starts a job run only after the earlier job run is completed. If the specified interval is too small, then the job might not start exactly after the specified minutes post the last synchronization time.
vCenter Chargeback Manager User’s Guide Delete Data Collector A data collector registered with the application can be removed or deleted. IMPORTANT If only a single data collector is running, do not delete it. If deleted, the synchronization jobs will not run and the data in the vCenter Chargeback Manager database will not be in sync with the data in the vCenter Server. Procedure 1 In the Settings tab, clickData Collectors.
Chapter 2 Configuring Administration Settings Property Description VMware vCloud Director Administrator Password Password for the vCloud Director Administrator user. VMware vCloud Director database host IP address of the vCloud Director database. This option is available only for vCloud Director 1.5 and vCloud Director 1.5.1. VMware vCloud Director database type The type of database used to create the vCloud Director database. The permissible values are SQL_Server and Oracle.
vCenter Chargeback Manager User’s Guide What to do next If you modify the vCloud Director URL, the database details, or the unprocessed event lifetime values, you must restart the data collector for the change to take effect. You can test the connection to the vCloud Director database by clicking the Test VMware Cloud Director database connection link. This link is available only if you integrate with a vCloud Director 1.5.x setup.
Chapter 2 Configuring Administration Settings Modify Super User Password for Cloud Data Collectors If you change the password of the super user that was used when installing the vCloud Director data collector and vShield Manager data collector, you must change the same from the Data Collectors page to ensure that these data collectors function correctly. You must have the Super User role to perform this task. Procedure 1 On the Settings tab, click Data Collectors. 2 Select the VMware Cloud Director tab.
vCenter Chargeback Manager User’s Guide Replace the Application License You must replace an expired license with a valid license. You can also replace an existing valid license with another valid license. You must have the Super User role to perform this task. Procedure 1 In the Settings tab, clickLicense. A table listing the details of the license added to the application is displayed. 2 Click Replace. The Replace License screen is displayed. 3 Enter a valid license key and click Replace.
Chapter 2 Configuring Administration Settings 3 Select a sub-section from the Header section of the report view. 4 Select an option from the Header Settings section to display the required information in the selected subsection. Option Description Text The text that you want the report header to contain. For example, the name of the organization. Image An image that you want the header section to display. For instance, the company logo. Ensure that the image size does not exceed 1MB.
vCenter Chargeback Manager User’s Guide 12 Click Save. The report view is saved and will be used when the next report is generated. In each section, the configured sub-sections will use the space available in the adjacent empty sub-sections. A configured sub-section will first try to expand and use the unused space in the sub-section to its right, then to its left, then to its bottom, and lastly in the sub-section above it. The content of a sub-section is center-aligned.
Chapter 2 Configuring Administration Settings Procedure 1 In the Settings tab, click Manage Attributes. The page displays a table with all the attributes available in your vCenter Chargeback Manager installation. 2 Select the attribute that you want to modify and click Edit. 3 Modify the required information. 4 Click Save. The modified attribute details are listed in the table. Delete an Attribute The attributes that are not required can be deleted from the application.
vCenter Chargeback Manager User’s Guide 2 In the vCenter Chargeback Manager Server section, set the Normal and Alert response time limits. The Normal, Warning, and Alert latency ranges are defined as follows: 3 Option Description Normal The Normal latency range is (0, normal response time limit). The default range is (0, 30000). If the response time is in the Normal latency range, the server is responding fine.
Authenticating and Managing Users, Roles, and Permissions 3 vCenter Chargeback Manager provides user management features that enable you to manage the various users, roles, and permissions defined in the application. vCenter Chargeback Manager provides resource-based authorization. The application defines different permissions for each resource. The application also provides few predefined roles. In addition, you can create new roles and users as per your requirements.
vCenter Chargeback Manager User’s Guide Table 3-1. Resource Types Defined in vCenter Chargeback Manager (Continued) Resource Type Description Chargeback Hierarchical Entity This resource type refers to any entity created or added to a hierarchy in vCenter Chargeback Manager. A user must have read permission on the entity and the corresponding hierarchy to access it. Attribute This resource type refers to any attribute created or imported in vCenter Chargeback Manager.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Table 3-2.
vCenter Chargeback Manager User’s Guide Predefined Roles in vCenter Chargeback Manager vCenter Chargeback Manager provides various predefined roles that can be assigned to the application users. The predefined roles are Super User, Administrator, Hierarchy Manager, Report Generator, vCenter Guest User, No Access, Dependent Resource Update, and Dependent Resource Read. These roles have a set of permissions on the various resource types defined in them.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Table 3-4.
vCenter Chargeback Manager User’s Guide Table 3-5. Permissions Defined on the Hierarchy Manager Role (Continued) Resource Type Create Read Update Delete Entity Cost Modify Billing Policy Yes Yes Yes Yes No Automatic Report Scheduler Yes Yes Yes Yes No Report Generator Role Table 3-6 lists the permissions defined in the Report Generator role for each of the resource type. Table 3-6.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Table 3-7.
vCenter Chargeback Manager User’s Guide Table 3-8. Permissions Defined on the Dependent Resource Update Role (Continued) Resource Type Create Read Update Delete Entity Cost Modify Report No Yes Yes No No Schedule No Yes Yes No No Role No No No No No Billing Policy No Yes Yes No No Automatic Report Scheduler No No No No No Dependent Resource Read Role Table 3-9 lists the permissions defined in the Dependent Resource Read role for each of the resource type.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Procedure 1 In the Users & Roles tab, click Roles. A table listing all the roles defined in the application is displayed. 2 Click Create. The Create Role screen is displayed. 3 Enter a name and description for the role. Option Description Role Name A name to uniquely identify the role. Provide a meaningful name to the role so that it is easy to identify the use of the role and the permissions assigned on the role.
vCenter Chargeback Manager User’s Guide 2 Select the role that you want to delete, and click Delete. A dialog box confirming the action is displayed. 3 Click OK. Managing Users When the application is installed, a user with the Super User role is created. The user name and password for this user are provided during the installation. This is the only user that exists in a freshly installed vCenter Chargeback Manager instance. You can create more users in the application.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Creating Users You can create multiple users and groups in vCenter Chargeback Manager as per your requirements. You must have the Super User role or the Administrator role to create users. The application lets you create the following types of users and groups: Local User This is a vCenter Chargeback Manager user whose details are defined in vCenter Chargeback Manager. LDAP User This is a Windows Active Directory user.
vCenter Chargeback Manager User’s Guide 5 Click Add. The newly created user is added to the table displaying the users and groups created in the application. What to do next The role assigned to the user defines the permission that the user has in the application. You must, however, assign roles to the user on the individual resources for him to access those resources. Create an LDAP User You can add Windows Active Directory users to vCenter Chargeback Manager.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions What to do next The role assigned to the user defines the permission that the user has in the application. You must, however, assign roles to the user on the individual resources for him to access those resources. Create an LDAP Group Like LDAP users you can also add LDAP groups to vCenter Chargeback Manager. You must have the Super User role or the Administrator role to perform this task.
vCenter Chargeback Manager User’s Guide What to do next The role assigned to the group defines the permission that the group has in the application. You must, however, assign roles to the group on the individual resources for granting access on those resources. Modify a User After a user is created, you can change the password for the user by using the Modify User feature of the application. You can modify the password of only a Local user.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions Assign a Role to a User on vCenter Chargeback Manager The role assigned to the user on vCenter Chargeback Manager defines the actions that the user can perform in the application. A user must have a role assigned to him on vCenter Chargeback Manager or on the resource defined in the application to enable him to perform some actions in the application. When you create a user, no roles or permissions are assigned to it by default.
vCenter Chargeback Manager User’s Guide Assign a Role to a User for a Resource A user can access a resource created in the application only if he has created it or has privileges to access it. A user can be given privileges to access a resource by assigning a role to him for the required resource. If a user is assigned the Super User role, then he can access any resource created in the application.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions 3 Expand the resource type folder and select the resources for which you want to set the role on the user. You can select more than one resource by pressing the Ctrl key and selecting each of the required resources. However, the roles that you can assign on these resources would depend on the intersection of the permissions you have on each of the selected resources. 4 Select the user from the table listing the users.
vCenter Chargeback Manager User’s Guide The role is revoked from the user. Revoking the role assigned to the user on vCenter Chargeback Manager does not automatically remove the roles explicitly assigned to the user for the various resources. The user can continue to access the resources that he has created and the resources for which he has been assigned a role. vCenter Chargeback Manager User Authentication After a user is created, you can log in to the application using the credentials of this user.
Chapter 3 Authenticating and Managing Users, Roles, and Permissions After registering the application as a plug-in, when you log in to the vCenter Server through the vSphere Client, the application might display a security warning message for installing or ignoring the SSL certificate from the vCenter Chargeback Manager instance. You must install this certificate.
vCenter Chargeback Manager User’s Guide 56 VMware, Inc.
Managing Chargeback Hierarchies 4 vCenter Chargeback Manager interacts with the vCenter Server to determine the utilization of the computing resources by various virtual machines that are created in the vCenter Server hierarchy. vCenter Chargeback Manager enables you to create multiple chargeback hierarchies, which can be different from the vCenter Server hierarchies. A chargeback hierarchy is an organization of vCenter Server entities and vCenter Chargeback Manager entities.
vCenter Chargeback Manager User’s Guide 3 Select Custom Hierarchy (default). 4 Click Create. An empty chargeback hierarchy with the given name is created. What to do next To add entities to this hierarchy and manage the hierarchy, see “Managing a Chargeback Hierarchy,” on page 60. Synchronize a Chargeback Hierarchy with a vCenter Server You can create a chargeback hierarchy and synchronize it with a vCenter Server. This chargeback hierarchy will be same as the vCenter Server hierarchy.
Chapter 4 Managing Chargeback Hierarchies Import a Chargeback Hierarchy from a CSV File You can create a chargeback hierarchy by importing a hierarchy defined in a .csv file. To perform this operation, you must have a create privilege for the hierarchy resource type and a read privilege on all the vCenter Server instances whose entities are specified in the CSV file. Prerequisites Before you begin, you must ensure that the .csv file entries are in the correct format. To know more about the format of the .
vCenter Chargeback Manager User’s Guide Table 4-1. Parameters in the CSV File Entry (Continued) Parameters Description vcEntityMoId The moid (managed object ID) of a virtual machine as defined in the vCenter Server. You can obtain the entity MoID by using vSphere SDK or through the vCenter server MOB (http://{vcserverIP}/mob) vCenterViewId The vCenter Server hierarchy view to be used for creating the chargeback hierarchy. If you want to use the Host & Clusters view, then set vCenterViewId to 1.
Chapter 4 Managing Chargeback Hierarchies What to do next You can also search for entities in the hierarchy by using the Search field below the hierarchy on the left pane of the page. When you search for an entity, vCenter Chargeback Manager highlights the first entity in the hierarchy whose name contains the search string. You can click the next or previous icon next to the Search field to find the other entities in the hierarchy whose names contain the search string.
vCenter Chargeback Manager User’s Guide vCenter Chargeback Manager does not display the status of the virtual machines and ESXi hosts in the vCenter Server hierarchy. Also, after adding the entity to the chargeback hierarchy, vCenter Chargeback manager does not display the status of the virtual machines and ESXi hosts in the chargeback hierarchy. All the virtual machines in the hierarchy have the same icon and do not indicate whether they are powered on, suspended, or powered off.
Chapter 4 Managing Chargeback Hierarchies 8 Select the vCenter Chargeback Manager entity to which you want to add this vCenter Server entity. The selected vCenter Server entities are added to the chargeback hierarchy. After a vCenter Server entity is added to a chargeback hierarchy, you cannot delete any of its child entities from the chargeback hierarchy without deleting this added entity.
vCenter Chargeback Manager User’s Guide 2 Expand the hierarchy by clicking the plus sign (+) to the left of the hierarchy name. The first-level entities in the hierarchy are displayed. You can view all the entities in the hierarchy by clicking the plus sign to the left of the entities that have sub-entities. 3 Right-click the entity that you want to remove and select Delete from the pop-up menu. A dialog confirming the action is displayed. 4 Click OK.
Chapter 4 Managing Chargeback Hierarchies 4 Enter or update the values for the attributes that you want to assign to the entity. You can overwrite the values of only the attributes created in vCenter Chargeback Manager. 5 Click Apply. The attributes with their values are assigned to the entity and can be included in the chargeback report. The attribute value assigned to an entity does not get propagated to the child entities.
vCenter Chargeback Manager User’s Guide You can set the allocation units, when you want to charge an entity for a fixed amount of computing resource units, immaterial of the actual resource usage. For example, you want to charge a virtual machine for a minimum of 2GHz of CPU and 4GB of RAM immaterial of the actual CPU and memory usage by the virtual machine.
Chapter 4 Managing Chargeback Hierarchies Procedure 1 In the Manage Hierarchy tab, select the required chargeback hierarchy from the drop-down menu on the left pane of the page. The collapsed view of the chargeback hierarchy is displayed. 2 Expand the hierarchy by clicking the plus sign (+) to the left of the hierarchy name. The first-level entities in the hierarchy are displayed. You can view all the entities in the hierarchy by clicking the plus sign to the left of the entities that have sub-entities.
vCenter Chargeback Manager User’s Guide View Properties of a vCenter Server Entity A chargeback hierarchy can contain entities from more than one vCenter Server. In a chargeback hierarchy, you can identify the vCenter Server to which an entity belongs by viewing its properties. You must have a read privilege on the hierarchy and the chargeback hierarchical entity to perform this task.
Managing and Configuring vCenter Chargeback Manager Cost Elements 5 vCenter Chargeback Manager provides various cost-related elements. These elements enable you to define the cost to be charged for each computing resource, fixed costs, and the cost calculation formula. You must set the various cost-related elements in vCenter Chargeback Manager to successfully generate the required cost reports.
vCenter Chargeback Manager User’s Guide Chargeable Computing Resource A chargeable computing resource is any computing resource that must be accounted for when calculating the IT operational costs. The usage of the computing resources is measured and the corresponding charge is calculated. vCenter Chargeback Manager accounts for the following computing resources: CPU The CPU usage is measured in GHz. Disk Read and Write The usage is measured in GB/hour. Disk Read The usage is measured in GB/hour.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements External Network Transmit Rate The external network usage for upload measured in MB/hour. External Network Receive Rate The external network usage for download measured in MB/hour. NOTE The cloud data collectors fetch the external network traffic data only for networks that have a vShield Edge instance in vShield Manager.
vCenter Chargeback Manager User’s Guide size This attribute can be used only for memory. The memory size is fetched from the vCenter Server and replicated in the vCenter Chargeback Manager database by the data collector synchronization jobs. burstable utilization This attribute lets you account for the 95th percentile of actual utilization. This attribute is available only for the external network transmit rate and external network receive rate computing resources.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements Table 5-2. Sample Base Rates and Rate Factors (Continued) Chargeable Resource Base Rate ($) Rate Factor Total Charge ($) Network Received and Transmitted 0.0008 1 0.0008 Storage 0.0013 1 0.0013 Disk Read and Write 0.0008 0.75 0.0006 vCPU 0.04 1 0.04 Fixed Cost A fixed cost is a definite cost that can be charged on an entity. Fixed costs can be recurring costs or one-time costs.
vCenter Chargeback Manager User’s Guide pricing model, and virtual machine instance costs defined for the pricing model. The actual usage and any allocated and reserved units of the chargeable computing resources are ignored. The expression for the billing policy is as follows: fixed costs = include; Actual Usage In this policy, the actual utilization of the chargeable computing resources of the virtual machines is determined.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements The maximum of usage and reservation is not calculated by comparing the total used units for the entire reporting duration against the total reserved units for the entire reporting duration. vCenter Chargeback Manager compares the used and reserved units for each sample available for the specified reporting duration to calculate the total units to be charged. The samples are fetched from the vCenter Server database.
vCenter Chargeback Manager User’s Guide Fixed Cost and Reservation When calculating the total cost, this policy takes into account all the fixed costs associated with an entity, the reserved capacity of CPU and memory for the entity, and the actual utilization of other chargeable computing resources by the entity.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements Fixed Cost and Maximum of Memory Usage and Memory Reservation This policy takes into account all the fixed costs associated with an entity, the maximum of used and reserved units of memory for the entity, and the actual utilization of other chargeable computing resources by the entity for calculating the total cost.
vCenter Chargeback Manager User’s Guide If you install the vCloud Director data collector, then additional billing policies are available in you vCenter Chargeback Manager setup. By default, fixed costs are not included in any of the billing policies, except the Pay As You Go Fixed Charging billing policy. However, you can modify the billing policies to account for the fixed costs.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements VMware Cloud Director Billing Policy - Pay As You Go Fixed Charging This policy takes in to account the actual usage for external network transmit and external network receive computing resources. For all other resources, the user-defined allocation units in vCenter Chargeback Manager are considered for cost calculation. The policy also takes in to account the fixed costs set on the entities.
vCenter Chargeback Manager User’s Guide Managing Pricing Models vCenter Chargeback Manager provides a default pricing model called Default Chargeback Pricing Model. The pricing models defined in the application can be viewed and managed from the Pricing Models page of the Manage Cost tab. You can start using the application by creating a chargeback hierarchy and generating basic reports using the default pricing model. You can modify this pricing model as per your requirements.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 2 Click Create. The Pricing Model screen is displayed. 3 4 Provide a name description for the pricing model and set the currency type in the General tab. Option Description Name Name for the pricing model. This is mandatory information. The character limit for the pricing model name is 255 characters. Description An optional description of the pricing model. The character limit for the description is 512 characters.
vCenter Chargeback Manager User’s Guide 9 (Optional) If you have selected the Overage option, specify the rate to be charged for the allocated units of the computing resource and that for the units used beyond the allocation. If you want to charge for the complete allocation, even if the usage is less than the allocated units, select the Even if usage is less than allocation, charge for allocated units option.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements Calculate Base Rate Using Base Rate Calculator vCenter Chargeback Manager provides a base rate calculator that helps you calculate the base rate for CPU, memory, and storage. The computed base rates when charged enable you to recover your hardware cost over a defined period. The base rate calculator also helps you identify and calculate the fixed costs to be charged per virtual machine.
vCenter Chargeback Manager User’s Guide 2 Select the pricing model that you want to modify, and click Edit. The Pricing Model screen is displayed. 3 In the General tab, modify the name and description as required. You cannot modify the currency type for a pricing model. 4 In the Billing Policy tab, modify the billing policy and the effective time period.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 8 Modify the attribute-based fixed cost rules in the Rules tab. If you have defined attribute-based fixed cost rules in the pricing model, then at least one rule persists in the pricing model and cannot be deleted. To override this condition, you could perform one of the followings tasks: 9 n Modify the value for the attribute in the rule such that the criteria is never satisfied.
vCenter Chargeback Manager User’s Guide Create a Fixed Cost You must create the fixed costs that you want to charge on the entities and hierarchies. These costs can include periodically charged costs and one time costs. When defining fixed costs, you can specify whether the cost must be prorated. Prorated fixed costs are considered only for the time for which they are applied on the entity.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 6 Click Create. The newly created fixed cost is added to the table listing the fixed costs. What to do next After a fixed cost is created, you can associate it with an entity, a set of entities, or hierarchies. This can be done while configuring costs at the entity level. Fixed costs can also be added to a template and then set on an entity or a hierarchy. Modify a Fixed Cost You can modify the fixed costs as and when required.
vCenter Chargeback Manager User’s Guide The modified fixed cost is displayed in the table listing the fixed costs. You can view the modified cost details of the fixed cost by clicking the plus sign (+) in the Details column of the table. Delete a Fixed Cost You can delete invalid or unwanted fixed costs from the application. You must have delete privilege on the fixed cost to remove it from the application.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 2 Click Create. The Cost Template screen is displayed. 3 4 Provide the name, description, and currency type for the cost template in the General tab. Option Description Name A name for the cost template. The character limit for the cost template name is 255 characters. Description An optional description of the cost template not exceeding 512 characters in length.
vCenter Chargeback Manager User’s Guide 6 Click Save. Changes made to a cost template are not automatically reflected on the entities on which the template is applied. You must explicitly reapply the template on the entities for the changes to take effect. Delete a Cost Template Invalid or unwanted cost templates can be removed from the application. However, deleting a cost template does not remove the entity-specific cost settings applied on the entities using the cost template.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 3 Provide a name and description for the billing policy. Option Description Name Name for the billing policy. This is mandatory information. The character limit for the name is 255 characters. Description An optional description of the billing policy. The character limit for the description is 512 characters. 4 Select the Expression tab. 5 Select a resource and define an expression for it.
vCenter Chargeback Manager User’s Guide Table 5-3. Sample Billing Policy Expression Resource VM Power On/Off MAX Operator Attribute(s) Distributed Linked Clones CPU Yes Yes reservation, usage N.A. Memory Yes Yes reservation, usage N.A. Storage No Yes allocation, usage Yes vCPU No No usage N.A All other resources No No allocation N.A. In this billing policy, if you want to account for the fixed costs, then you must select the Add/Include Fixed Cost option.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements Procedure 1 In the Manage Cost tab, click Billing Policy. A table listing all the billing policies created in the application is displayed. 2 Select the required billing policy from the table and click Delete. 3 Click OK to confirm the delete operation.
vCenter Chargeback Manager User’s Guide Procedure 1 In the Configure Cost tab, click Edit Entity Cost. 2 Select the required hierarchy from the hierarchies included in the drop-down menu. Only the hierarchies on which you have at least the read privilege are included in the drop-down menu. 3 Expand the hierarchy and select the entity for which you want to configure the costs.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements 11 12 Select the Enable/Disable Billing tab to configure the billing status. Option Description Enable (default) This option enables billing on the entity for the specified time period. You can use this option if billing was earlier disabled on the entity for the specified time period. Disable Select this option if you want to disable billing on the entity for the specified time period. Click Update Billing.
vCenter Chargeback Manager User’s Guide 5 Select the cluster or an individual ESXI host for which you want to define the rate factors. If you select a cluster, the right pane of the page displays the cluster properties and the ESXI hosts under the selected cluster along with the fields to set the rate factors for individual computing resources. 6 Select a pricing model from the drop-down menu. 7 Specify the duration for which the rate factors will be effective.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements A new datastore tier folder is created. Modify the Name of a Datastore Tier You can modify the name of the tier folder at any time after it is created. You must have update privilege on the tier to perform this task. Procedure 1 In the Configure Cost tab, click Edit Infrastructure Cost. 2 Select DataStores from the drop-down menu. 3 Right-click the tier folder whose name you want to modify and select Edit label.
vCenter Chargeback Manager User’s Guide 3 Select the tier for which you want to configure the rate factor. The right pane of the page displays the datastores included in the tier, their details, and the field to configure the rate factor for the tier. If you want to set the rate factor on an ungrouped datastore or storage profile, select the required datastore or storage profile from the ungrouped folder. 4 Select the pricing model from the drop-down menu.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements A price matrix is associated with a pricing model and can contain multiple cost entries for different vCPU count and memory bundles. You can also define a criterion to specify the hierarchies for which the price matrix is applicable. You can define multiple pricing matrices with different hierarchy selection criteria for each pricing model defined in vCenter Chargeback Manager.
vCenter Chargeback Manager User’s Guide 2 Select a pricing model from the drop-down menu. A table listing the hierarchy selection criteria defined for the pricing model is displayed on the page. 3 Click Create. The Selection Criteria and VM Instance Matrix screen is displayed. 4 Select whether you want to apply the VM instance matrix to all hierarchies or only specific hierarchies. 5 Define the hierarchy and entity selection criteria, if you selected Specify hierarchy selection criteria.
Chapter 5 Managing and Configuring vCenter Chargeback Manager Cost Elements Update Hierarchy Selection Criteria and Virtual Machine Instance Cost Matrix You can update the hierarchy selection criterion and the corresponding virtual machine instance cost matrix. You can modify the hierarchy selection criteria defined for a pricing model as and when required.
vCenter Chargeback Manager User’s Guide Modify Priority Order of Selection Criteria The default priority order for the hierarchy selection criteria is the order in which they are created. However, you can modify this order as per your requirements. Procedure 1 In the Configure Cost tab, click Edit VM Instance Cost. 2 Select a pricing model from the drop-down menu. A table listing the hierarchy selection criteria defined for the pricing model is displayed on the page.
6 Generating Reports After creating and configuring chargeback hierarchies and defining pricing models, you can generate various cost reports, usage reports, cost comparison reports, and showback reports. The reports provide you with valuable information such as the usage of resources, the charge to levied on each entity, and the total cost.
vCenter Chargeback Manager User’s Guide Table 6-1. Report Summary 104 Field Description Name Report name provided during report creation Description A short description about the report. This information is provided during report creation. Bill Date The date on which the report is generated. Bill Period The start and end date of the time period for which the report is generated. The resource usage details for this time period is considered when generating the report.
Chapter 6 Generating Reports utilization details at each entity level. In a cost report, this section also includes the following graphs for each entity level starting with the entity on which the report is generated: n Cost per Resource n Cost per Child Entity n Usage per Child Entity If the cost and usage data is not available for a specified period, then the graphs for this period are excluded from the exported report.
vCenter Chargeback Manager User’s Guide n Showback Report No graphs are available in the resource summary. A showback report lets you analyse how the costs are distributed among the entities based on a specified distribution policy. This report type is useful when you know the total cost and want to analyze how this cost is distributed among the entities by selecting different distribution policies.
Chapter 6 Generating Reports Option Description Select a pricing model Select the pricing model to be used for generating the report. If you are generating a report for multiple entities, you can choose to use different pricing models for each entity by selecting the Use different pricing models for entities option and then select the required pricing models for each entity. Ensure that the selected pricing models have the same currency type.
vCenter Chargeback Manager User’s Guide Generate a Usage Report You can generate resource usage reports for a hierarchy and for individual entities in a hierarchy. You must have create privilege on the report resource type and at least the read privilege on the hierarchy, chargeback hierarchical entities, and pricing models to perform this task. Procedure 1 In the Reports tab, click Create Reports. 2 Select the required chargeback hierarchy from the drop-down menu on the left pane of the page.
Chapter 6 Generating Reports 7 8 On the Details page, select the usage-related details and other information to be displayed in the report, and click Next. Option Description Show these details in report Select this option if you want to include information about the selected pricing model or the entity attributes, or some information messages in the Usage Details section of the report.
vCenter Chargeback Manager User’s Guide 5 Option Description Report Duration Select the Generate this report now option (default) and specify the effective time period for generating the report by providing the start date and end date for the reporting duration. This reporting duration is the time period for which the usage stats of computing resources will be retrieved and used for calculating the costs.
Chapter 6 Generating Reports Generate Showback Report You can generate a showback report to analyse how the cost is distributed among the entities based on a specified distribution policy. A showback report is a configurable report that does not include any costs when it is generated. You can specify the total cost, fixed cost, and resource weightage in the generated report to obtain the cost for each entity and for each resource per entity.
vCenter Chargeback Manager User’s Guide 5 Option Description User Name (Optional) Enter the name of the user to whom the report is addressed to. The report is not automatically emailed to this user. Report Duration Select the Generate this report now option (default) and specify the effective time period for generating the report by providing the start date and end date for the reporting duration.
Chapter 6 Generating Reports Scheduling Report Generation When creating a report, you can choose to schedule the report to be generated periodically. vCenter Chargeback Manager provides various scheduling parameters for scheduling a report. n Scheduling Parameters on page 113 You can set various scheduling parameters while scheduling a report. n Schedule Report Generation on page 114 When creating a report, you can choose to schedule the report generation from the Create Report screen.
vCenter Chargeback Manager User’s Guide Range of Recurrence n Quarterly: This option lets you specify a date of the first month of a quarter on which the report for the previous quarter has to be generated. The quarters defined are January–March, April–June, July–September, and October–December. For example, if the date is set to 5, then the report for the period April through June is generated on the 5th of July and the report for the period July through September will be generated on 5th of October.
Chapter 6 Generating Reports 3 Right-click the hierarchy or the entity on which you want to generate the report and select Generate Cost Report from the pop-up menu. To generate a report for multiple entities, press the Ctrl key, select each of the required entities, and rightclick and select Generate Cost Report from the pop-up menu. Do not release the Ctrl key till you rightclick. The Create Report screen is displayed. 4 5 Provide the requested report details and click Next.
vCenter Chargeback Manager User’s Guide 10 11 On the Details page, select the fixed cost details, usage-related details, and other information to be displayed in the report, and click Next. Option Description Show these details in report Select this option if you want to include information about the selected pricing model or the entity attributes, or information messages in the Cost Details section of the report.
Chapter 6 Generating Reports 3 Click the scheduler icon above the table. The Schedule Report screen is displayed. 4 5 Enter relevant values for the scheduling parameters. Option Description Report Creation Time When the report has to be generated. Recurrence Pattern How often the report has to be generated. Range of Recurrence Till when the report has to be generated periodically. Click Schedule. The revised report generation schedule is listed in the table.
vCenter Chargeback Manager User’s Guide 4 5 Provide the email details. Option Description To The email address of the recipients. The email addresses should be separated by commas. Subject A subject for the email. Body The body text for the email. Click Save. The email details are saved.
Chapter 6 Generating Reports Managing Reports After you generate a report, the report is displayed in the application. You can remove rows and columns from the displayed report and also rearrange the columns in the report. You can also archive, schedule, email, and export the report. n Modifying the Report in the Interactive Report View on page 119 After a report is generated and displayed in the application, you can make few modifications to the report.
vCenter Chargeback Manager User’s Guide 2 To remove row from the displayed report, select the row and click the Delete Selection icon (a cross sign) above the report. The selected entity and its child entities are removed from the report. You can add the entities back to the report by clicking the Undo Delete icon. However, the undo delete operation is available only for the last delete operation performed.
Chapter 6 Generating Reports Procedure 1 Log in to the vCenter Chargeback Manager database. Ensure that you have modify privilege on the CB_SERVER_PROPERTY table. 2 Configure the server properties for precision data in the CB_SERVER_PROPERTY table. The table contains three properties that enable you to configure the precision value for numbers displayed in the PDF report. Option Description reporting_pdf_report_cost_pattern Pattern used to display all the cost values. The default value is #,##0.00.
vCenter Chargeback Manager User’s Guide 2 3 Enter relevant values for the scheduling parameters. Option Description Report Creation Time When the report has to be generated. Recurrence Pattern How often the report has to be generated. Range of Recurrence Till when the report has to be generated periodically. Click Schedule. The report is generated periodically as per the scheduling options set. The report schedule can be accessed from the Scheduled Reports page.
Chapter 6 Generating Reports 2 Click the Click to download link. The application exports the report to the specified format. If the report name contains any special characters, then such characters are replaced with an underscore (_) in the exported report file name. If you have chosen to view the report in the .rtf format, an Opening filename.rtf dialog is displayed. NOTE If the temp folder in the Tomcat installation folder is deleted, the export to .rtf might fail.
vCenter Chargeback Manager User’s Guide Managing Archived Reports The Archived Reports page of the Reports tab displays a table listing all the reports archived in the application. This includes manually generated and saved reports as well as reports generated by report schedules. All the reports generated by a single schedule have the same name but different Created on and Billing Period values. The reports are listed in the ascending order of their creation time.
Chapter 6 Generating Reports 5 You can either chose to open the file with a supported application or save the file on the system. NOTE If the reports contains entities with double byte characters in their names and you export the report to .csv format, then you must perform the following tasks: n To open the .csv file in a text editor, ensure that the text editor supports Unicode characters. n To open the .csv file in Microsoft Excel, first import the file in to Microsoft Excel.
vCenter Chargeback Manager User’s Guide Procedure 1 In the Reports tab, click Archived Reports. A table listing all the archived reports is displayed. 2 Select the archived report that you want to delete. 3 Click the delete icon (a red cross) above the table. A dialog box confirming the action is displayed. 4 Click OK. The archived report is permanently deleted from the application.
Chapter 6 Generating Reports Managing Automatic Report Scheduler An automatic report scheduler creates report schedules for hierarchies and entities that match the criteria specified in the automatic report scheduler. The automatic report scheduler scans all the vCenter Chargeback Manager hierarchies and creates report schedules for the hierarchies and entities that match the specified criteria. The scheduler runs every 30 minutes.
vCenter Chargeback Manager User’s Guide 4 5 Option Description Hierarchy Entity Level Specifies the number of levels for which the criteria is applied to select entities. To scan the entire hierarchy, set the value as zero. Computing Resources Select the computing resource to be accounted for during report generation. On the Schedule page, specify the report schedule details and click Next. Option Description Report Creation Time When the report has to be generated.
Chapter 6 Generating Reports 2 Select the scheduler that you want to modify and click Edit. The Edit Automatic Report Scheduler window is displayed. 3 Modify the necessary details and click Next. 4 Modify the scheduling parameters and click Next. 5 Modify the report summary details and click Next. 6 Specify the information to be included in the report and click Submit. The modified automatic report scheduler is displayed on the page.
vCenter Chargeback Manager User’s Guide For a hierarchy that includes a vCenter Server that is integrated with VMware vCenter Operations, the dashboard provides the following details: n The Cost per Resource bar chart in the Cost projection tab shows cost for each resource, which is color coded, for the past 30 days and projected data for next three months in sets of 30 days each.
Chapter 6 Generating Reports View Hierarchy Details in the Report Dashboard If a chargeback hierarchy is configured for display in the report dashboard, then you can view the resource usage and cost statistics for the hierarchy and its entities in the Dashboard page of the application. The report dashboard shows the last generated reports, according to the report dashboard configuration, for the selected hierarchy.
vCenter Chargeback Manager User’s Guide 132 VMware, Inc.
Monitoring System Health 7 The System Health tab acts as a dashboard, providing you with information about and status of the entire system. Only a user with Super User role has access to this tab. The dashboard shows colored status indicators next to the URL for each server and service. The significance of the colors is as described in the table Table 7-1. Table 7-1. Significance of Dashboard Status Indicator Colors Color Significance Green Normal The response time within the acceptable range.
vCenter Chargeback Manager User’s Guide Table 7-2. Section in the System Health Tab (Continued) Section Information Data Collectors Names of all the data collector instances along with name of the machine on which they are installed is listed. When you move the cursor over the data collector name, a tool tip displays the name of the data collector, the name of the host on which it is installed, and the status of the data collector.
Chapter 7 Monitoring System Health vCenter Chargeback Manager also sends an alert if any of the data collector jobs is not assigned to an available data collector. NOTE If the vCenter Chargeback Manager database, a stand-alone vCenter Chargeback Manager, or the SMTP Server goes down, no email alert is sent. However, an email alert is sent when the SMTP Server is restored. Prerequisites You must ensure that the SMTP Server is configured in the vCenter Chargeback Manager for the email alert to be sent.
vCenter Chargeback Manager User’s Guide The information displayed in the table is useful to track which users performed which actions on the application. The information in the Event Details panel is refreshed every 30 seconds. If this panel is open, the user session does not get timed out. If the system time of the vCenter Chargeback Manager instances in a cluster are not in sync, the Event Details tab might not display some of the event messages. 136 VMware, Inc.
Administration Utilities 8 vCenter Chargeback Manager interacts with various servers and databases. It also stores information about users and various components, such as hierarchies and entities. To ensure that the application and the corresponding components are working properly, one must monitor the health of the entire system periodically. vCenter Chargeback Manager provides a few utilities and database management scripts that enable you to manage the application efficiently.
vCenter Chargeback Manager User’s Guide Procedure 1 Run the database password change utility from the command prompt. cd Installation_Directory\vCenter-CB-Tools\database-update\bin UpdateChargebackDatabaseCredentials.bat You can also run this utility by selecting Update Chargeback Database Credentials from the Start > Programs > VMware > VMware vCenter Chargeback > vCenter Chargeback Tools menu. 2 3 Enter the existing and new passwords.
Chapter 8 Administration Utilities Procedure 1 From the command prompt run the UpdateCbmServer.bat file located at Installation_Directory\vCenter-CB-Tools\reset-IP\bin. 2 Provide the requested information and press Enter. 3 Information Description New IP address The new IP address of the machine on which vCenter Chargeback Manager is installed. Existing IP address The old IP address of the machine on which vCenter Chargeback Manager is installed.
vCenter Chargeback Manager User’s Guide 2 On the vCenter Chargeback Manager machine, run the UpdateLoadBalancerIP.bat script. The UpdateLoadBalancerIP.bat is located at Installation_Directory\vCenter-CB-Tools\reset-IP\bin.
Chapter 8 Administration Utilities 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
vCenter Chargeback Manager User’s Guide 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.
Chapter 8 Administration Utilities For example, SELECT * from CB_FN_GOS_LICENSE_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_GOS_LICENSE_INVENTORY database view. However, in this case the data for only a given hierarchy and for a specific duration is returned.
vCenter Chargeback Manager User’s Guide 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.
Chapter 8 Administration Utilities Running the Guest OS Licensing Script in Oracle 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_STORAGEALLOC_INVENTORY database view. n The CB_FN_STORAGE_ALLOC_PAYG function.
vCenter Chargeback Manager User’s Guide 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.
Chapter 8 Administration Utilities Table 8-7.
vCenter Chargeback Manager User’s Guide vCenter Chargeback Manager Database Management Scripts vCenter Chargeback Manager provides SQL scripts that can help database administrators to manage the vCenter Chargeback Manager database. 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\db-manage
Chapter 8 Administration Utilities About the Space Calculation Scripts Table 8-9 lists the space calculation scripts provided with vCenter Chargeback Manager. Table 8-9. Space Calculation Scripts Script Description spaceCostData This script returns the amount of space that can be retrieved by purging the cost data that is older than the specified number of months.
vCenter Chargeback Manager User’s Guide Table 8-10. Data Purging Scripts (Continued) Script Description purgeStatsData This script removes the vCenter Server performance statistics data that is older than the specified number of months from the CB_VC_PERFORMANCE_STAT table. The number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter appropriately before running the script.
Index A application activate 11 authenticate in to 54 configure log level 13 configure storage infrastructure costing mode 15 configure VM Instance job interval 15 configuring generic settings 12 configuring settings 11 managing users, roles, and permissions 37 permissions defined in 38 resource-based authorization 37 archived reports delete 125 email 125 manage 124 search 126 view 124 attributes add 34 assign 64 delete 35 manage 34 modify 34 automatic report scheduler create 127 delete 129 managing 127 mo
vCenter Chargeback Manager User’s Guide managing 88 modify 89 D data collector delete 28 disable 27 enable 27 information about 25 manage 24 modify job interval 27 modify super user password for 31 view 24 data collectors configure VMware vCloud Director Data Collector 28 configure vShield Manager Data Collector 30 database management scripts about 148 data purging scripts 149 generic scripts 148 space calculation scripts 148 datastore tier add datastore 97 create 96 managing 96 modify name 97 move datast
Index deleting stale reports 140 email 122 export 122 generate cost comparison report 109 generate cost report 106 generate showback report 111 generate usage report 108 manage 119 modify in interactive report view 119 report generation schedules 113 schedule 121 stop 123 types 103 view in interactive report view 119 resource, permissions defined for 38 roles assign user role for a resource 52 assign user role on vCenter Chargeback Manager 51 create 44 delete 45 managing 39 modify 45 predefined roles 40 re
vCenter Chargeback Manager User’s Guide 154 VMware, Inc.
