1.0
Table Of Contents
- vCenter Chargeback User’s Guide
- Contents
- About This Book
- Introduction to vCenter Chargeback
- Installing vCenter Chargeback
- Configuring Administration Settings
- Authenticating and Managing Users, Roles, and Permissions
- Managing Chargeback Hierarchies
- Create a Chargeback Hierarchy
- Manage a Chargeback Hierarchy
- View a Chargeback Hierarchy
- Add a vCenter Server Entity
- Add a vCenter Chargeback 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
- Share Virtual Machine Cost
- View Properties of a vCenter Server Entity
- Creating and Configuring a Cost Model
- Generating Reports
- System Health, Utilities, and Troubleshooting
- System Health
- Events
- Utilities
- Troubleshooting
- Unable to Send Report Through Email
- Storage Syncing Job Fails
- Unable to use Custom SSL Certificates
- Unable to View the vCenter Chargeback Plug-In in the VI Client
- Report Does not Display the Memory Usage Value and the Corresponding Cost
- Report Does not Display the Network Transmitted and Network Received Stats
- Report Does not Display the Disk Read and Disk Write Stats
- Unable to Add vCenter Server in vCenter Chargeback
- Changed Timezone Setting is not Reflected
- Installer Throws the SQL Driver not Found Error
- Status of Failed Data Collector is not Reflected Immediately on the System Health tab
- Non-English Characters are not Correctly Stored in the vCenter Chargeback Database
- Service Temporarily Unavailable Error Thrown when Accessing vCenter Chargeback
- Text and Messages on the vCenter Chargeback User Interface are not Correctly Displayed
- Error Occurs While Importing a Hierarchy from a CSV File
- Changes to Chargeback Hierarchy are not Reflected in the Concurrent User-Sessions
- Changes to the vCenter Server Hierarchy are not Reflected in vCenter Chargeback
- Unable to Fetch the Primary Group of a LDAP User
- Unable to Access the vCenter Chargeback Application
- Index
vCenter Chargeback User’s Guide
82 VMware, Inc.
2Enterthefollowinginformation:
Existingpassword
Newpassword
Confirmationofthenewpassword
3RestartthevCenterChargebackserviceandthedatacollectorservices.
Database Management Scripts
vCenterChargebackprovidesSQLscriptsthatcanhelpdatabaseadministratorstomanagethevCenter
Chargebackdatabase.TheseSQLscriptscanberunbyadatabaseuserwiththerequiredpermissionsfromthe
SQLprompt.Thesescriptsareavailableatthefollowinglocation:
ForSQLServer
<Installation_Directory>/vCenter-CB-Scripts/v0.0.0-v1.0.0/mssql/db-management
Thescriptnamesareoftheform<script_name>_mssql.sql.
ForOracle
<Installation_Directory>/vCenter-CB-Scripts/v0.0.0-v1.0.0/oracle/db-management
Thescriptnamesareoftheform<script_name>_oracle.sql.
Thesescriptscanbeclassifiedasfollows:
“GenericScripts”onpage 82
“SpaceCalculationScripts”onpage 82
“DataPurgingandRestoringScripts”onpage 83
Generic Scripts
vCenterChargebackprovidesthreegenericscripts.YoumusthavetheSELECTpermissiononthetablesinthe
vCenterChargebackdatabasetorunthesescripts.BeforerunningthegenericscriptsonanSQLServer
database,youmustreplace$dbNamewiththenameofthevCenterChargebackdatabaseintheSQLscripts.
The
genericscriptsprovidedareasfollows:
countActiveConns:Thisscriptreturnsthenumberofactiveconnectionstothedatabase.
countRows:Thisscriptreturnsthenumberofrowsineachofthetablesinthedatabase.
dbSize:Thisscriptreturnthespaceoccupiedbythetablesinthedatabase.
Space Calculation Scripts
Thesescriptsenableyoutocalculatethespacethatcanberetrievedbypurgingtheolddatafromthedatabase
tablesintoCSVfiles.YoumusthavetheSELECTpermissiononthetablesinthevCenterChargebackdatabase
torunthesescripts.Thev_months_in_historyparameterforOraclescriptsandthe
@MONTHS_IN_HISTORY
parameterforSQLServerscriptsissetto6monthsbydefault.Youcanchangethisinthescriptstothedesired
numberofmonths.Thespacecalculationscriptsprovidedare:
spaceCostData:Thisscriptreturnstheamountofspacethatcanberetrievedbypurgingthecostdata
thatisolderthanthespecifiednumberofmonths.
spaceHierarchyData:Thisscriptreturnstheamountofspacethatcanberetrievedbypurgingthe
hierarchydatathatisolderthanthespecifiednumberofmonths.
spaceReportData:Thisscriptreturnstheamountofspacethatcanberetrievedbypurgingthereport
datathatisolderthanthespecifiednumberofmonths.