1.0.1

Table Of Contents
vCenter Chargeback User’s Guide
90 VMware, Inc.
Thedatapurgingscriptsprovidedare:
purgeCostData:Thisscriptremovesthecostrelateddatathatisolderthanthespecifiednumberof
months.ThenumberofmonthsisspecifiedusingtheMONTHS_IN_HISTORYparameterintheOraclescript
andthe@MONTHS_IN_HISTORYparameterintheSQLServerscript.Youcansetthisparameter
appropriatelybeforerunningthescript.
Thescriptremovesthedatafromthefollowingtables:
CB_BASE_RATE
CB_BILLING_POLICY
CB_ENTITY_METERING
CB_RATE_FACTOR
CB_FIXED_COST
ThescriptcorrespondinglymovesthedatatothefollowingCSVfiles:
CBBaseRate.csv
CBBillingPolicy.csv
CBEntityMetering.csv
CBRateFactor.csv
CBFixedCost.csv
purgeHierarchyData:Thisscriptremovesthehierarchyrelateddatathatisolderthanthespecified
numberofmonths.ThenumberofmonthsisspecifiedusingtheMONTHS_IN_HISTORYparameterinthe
Oraclescriptandthe@MONTHS_IN_HISTORYparameterintheSQLServerscript.Youcansetthis
parameterappropriatelybeforerunningthescript.
Thescriptremovesthedatafromthefollowingtables:
CB_VC_ENTITY_RELATION
CB_VC_ENTITY_PROPERTY
CB_VC_ENTITY_MAPPING
CB_HIERARCHY_RELATION
ThescriptcorrespondinglymovesthedatatothefollowingCSVfiles:
CBVCEntityRelation.csv
CBVCEntityProperty.csv
CBVCEntityMapping.csv
CBHierarchyRelation.csv
purgeReportData:Thisscriptremovesthereportrelateddatathatisolderthanthespecifiednumberof
months.ThenumberofmonthsisspecifiedusingtheMONTHS_IN_HISTORYparameterintheOraclescript
andthe@MONTHS_IN_HISTORYparameterintheSQLServerscript.Youcansetthisparameter
appropriatelybeforerunningthescript.
ThescriptremovesthedatafromtheCB_REPORTtableandmoves
ittotheCBReport.csvfile.
purgeTables:ThisscriptisasupersetofthepurgeCostData,purgeHierarchyData,and
purgeReportDatascripts.Thescriptremovesthecost,hierarchy,andreportrelateddatathatisolderthan
thespecifiednumberofmonths.ThenumberofmonthsisspecifiedusingtheMONTHS_IN_HISTORY
parameterintheOraclescriptandthe@MONTHS_IN_HISTORY
parameterintheSQLServerscript.The
scriptsremovesthedatafromthevCenterChargebacktablesandmovesittothecorresspondingCSVfiles.
purgeStatsData:Thisscriptremovestheperformancestatisticsdatathatisolderthanthespecifieddate
hasthespecifiedsampleinterval.ThedateisspecifiedusingthePURGE_BEFOREparameterintheOracle
scriptandthe$PURGE_BEFOREparameterintheSQLServerscript.Theintervalisspecifiedusingthe
REQ_INTERVALparameterin
theOraclescriptandthe@REQ_INTERVALparameterintheSQLServer
script.Youcansettheseparametersappropriatelybeforerunningthescript.Thescriptremovesthedata
fromtheCB_VC_PERFORMANCE_STATtableandmovesittotheCBVCPerformanceStat.csvfile.