1.0.1
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
- Unable to Access the vCenter Chargeback Application
- Unable to Remove the vCenter Chargeback Plug-In from the VI Client
- Unable to Fetch the Primary Group of a LDAP User
- Changes to the vCenter Server Hierarchy Are Not Reflected in vCenter Chargeback
- Index
VMware, Inc. 89
Chapter 8 System Health, Utilities, and Troubleshooting
spaceTablesData:Thisscriptreturnstheamountofspacethatcanberetrievedbypurgingthecost,
hierarchy,andreportdatathatisolderthanthespecifiednumberofmonths.
spaceStatsData:Thisscriptreturnstheamountofspacethatcanberetrievedbypurgingthe
performancestatisticsdata(fromtheCB_VC_PERFORMANCE_STATtable)thatisolderthanthespecified
dateandhasthespecifiedsampleinterval.Thedateandintervalvauescanbesetthroughthe
v_purge_beforeandv_req_intervalparametersin
theOraclescriptsandthe$PURGE_BEFOREand
@REQ_INTERVALparametersintheSQLServerscripts.
Data Purging and Restoring Scripts
Thepurgingscriptsenableyoutoremovedataolderthanthespecifiednumberofmonthsfromthedatabase
tablesandsavetheminCSVfiles.TorunthesescriptsyoumusthavetheSELECT,INSERT,andDELETE
permissionsonthedatabasetables.ForrunningthescriptsinanOracledatabase,
youmustalsohavethe
SELECTpermissionontheexternaltables(EXT_CB_%),whicharecreatedbythe
makeExternalTables_oracle.sqlscript.ForrunningthescriptsinanSQLServerdatabase,youmustalso
havetheCREATE TABLEandDROP TABLEpermissionsinthedatabase.
BeforeyourunthepurgingscriptsinSQLServer,you
mustperformthefollowingtasks:
1 CreateafolderwheretheCSVfilescanbesaved.
2CopytheSchema.iniandmakeCSVfiles.batfilesintothecreatedfolder.
Thesefilesareavailableatthefollowinglocation:
<Installation_Directory>/vCenter-CB-Scripts/v0.0.0-v1.0.0/mssql/db-management
3RunthemakeCSVfiles.batfilefromthecommandprompt.
EnsurethatyouhavepermissiontoexecuteBATfiles.ThisscriptcreatesemptyCSVfiles,oneforeachof
thevCenterChargebackdatabasetablesfromwhichdatacanbepurged.
4Setthevalueforthe@datasrcparameterinthemakeArchServer_mssql.sqlscript.
Thevaluefor
thisparametermustbethecompletepathofthefolderthatiscreatedfortheCSVfiles.
5LogintotheSQLServerManagementStudioconsole,andrunthemakeArchServer_mssql.sqlscript.
Thescriptcreatesalinkedserver.
BeforeyourunthepurgingscriptsinOracle,youmustperformthefollowingtasks:
1Loginto
theSQLDeveloperconsoleandrunthecsvproc_oracle.sqlscript.
Thisfileisavailableatthefollowinglocation:
<Installation_Directory>/vCenter-CB-Scripts/v0.0.0-v1.0.0/oracle/db-management
TheprocedureforpurgingdatafromthevCenterChargebackdatabasetablesintotheCSVfilesiscreated.
2SettheEXT_TABLE_DIR_STRparameterinthefollowingfilestothecompetepathofthefolderinwhich
theCSVfilesshouldbesav ed:
makeExternalTables_oracle.sql
purgeCostData_oracle.sql
purgeHierarchyData_oracle.sql
purgeReportData_oracle.sql
purgeTables_oracle.sql
3RunthemakeExternalTables_oracle.sqlscript.
TheexternaltablesarecreatedandlinkedtothecorrespondingCSVfiles.TheCSVarecreatedwhenthe
purgescriptsarerunforthefirsttime.
N
OTEThedatapurgingscriptsaresupportedonlyon32bitdatabaseinstances.