Types of data commonly included in cleanups


This topic discusses the various types of TrueSight Server Automation data that have the potential of filling up your database and are commonly included in cleanup jobs.


Related topic

Historical data from TrueSight Server Automation jobs and other objects

The TrueSight Server Automation data that consumes the most database space and grows most rapidly is historical data from TrueSight Server Automation jobs and other objects. Historical data is removed by the Delete cleanupHistoricalData command, which is called by the out-of-the-box cleanup job that BMC recommends that you run at least once a week. The exact object type to delete is specified as a variable of this command every time it runs.

The following table provides a summary of the various categories of historical data that you can delete in cleanup jobs:

Category

Description

ObjectType value (for  cleanupHistoricalData)

Job schedules

Scheduling data of job runs. This data is stored in the SCHEDULE table and related tables.

Click here for the full list of tables that are cleaned up...
  • SCHEDULE
  • SCHEDULE_DEVICE
  • SCHEDULE_NOTIFICATION
  • SCHEDULE_PARAMS
JobSchedule

Job results

Results from job runs, including the following job types:

  • Compliance Job
  • Snapshot Job ((Snapshot cleanup requires some additional considerations. For details, see Cleanup-considerations-for-snapshot.)
  • Audit Job
  • Patch Job

    Important

    When cleaning up Patch Job results, if all job runs of any Catalog Update Job (CUJ) fail, all catalog update job runs will be retained irrespective of the specified retention period.

    Deploy Job

Click here for the full list of tables that are cleaned up...

Job type

Database tables

Compliance

  • JOB_RUN
  • JOB_RESULT
  • ASSET_ATTRIBUTE_COND_RESULT
  • ASSET_SELECTOR_RESULT
  • ASSET_SELECTOR_RESULT
  • COMP_ENTRY_RESULT
  • COMP_ENTRY_RESULT_DETAIL
  • COMP_RULE_GROUP_RESULT_XREF
  • COMP_RULE_GROUP_RULE_RESULT
  • COMPLIANCE_REMEDIATION_RUN
  • COMPLIANCE_RULE_RESULT
  • COMPLIANCE_RULE_RESULT
  • COND_RESULT_SUB_COND_RESULT
  • CONDITION_RESULT
  • CONDITION_RESULT
  • CR_GROUP_RESULT
  • CR_GROUP_RESULT
  • CR_RULE_RESULT_SELECTOR
  • HRB_COMP_RULE_GROUP_RESULT
  • HRB_CONDITION_RESULT
  • JOB_RESULT_CR_GROUP_RESULT
  • PROPERTY_CONDITION_RESULT
  • SCAP_RESULT_NETWORK_DATA
  • SCAP_RESULT_RULE_AND_OVAL_DATA
  • SCAP_RESULT_RULE_DATA
  • SCAP_RESULT_TARGET_DATA
  • SELECTOR_CONDITION_RESULT
  • SELECTOR_RESULT_PATH

Snapshot

  • BLFILE
  • JOB_RESULT
  • JOB_RESULT_COMPONENT
  • OBJECT_OVERFLOW
  • OBJECT_OVERFLOW_DETAIL
  • SNAPSHOT_ASSET_CNT
  • SNAPSHOT_AUTH_DEPLOY_JOB_RUNS
  • SNAPSHOT_BLFILE
  • SNAPSHOT_BLFILE_CNT
  • SNAPSHOT_CFG_FILE_OBJECT_CNT
  • SNAPSHOT_COM_OBJECT
  • SNAPSHOT_COM_OBJECT_CNT
  • SNAPSHOT_COMPONENT_STATS
  • SNAPSHOT_CONFIG_FILE_OBJECT
  • SNAPSHOT_DOT_NET_ASSEMBLY
  • SNAPSHOT_EVENT_LOG
  • SNAPSHOT_GENERIC_ASSET
  • SNAPSHOT_GPO_SETTING
  • SNAPSHOT_GPO_SETTING_CNT
  • SNAPSHOT_METABASE_OBJECT
  • SNAPSHOT_METABASE_OBJECT_CNT
  • SNAPSHOT_OS_GROUP
  • SNAPSHOT_OS_USER
  • SNAPSHOT_PART
  • SNAPSHOT_REGISTRY_OBJECT
  • SNAPSHOT_REGISTRY_OBJECT_CNT
  • SNAPSHOT_SERVICE
  • SNAPSHOT_SOFTWARE
  • SNAPSHOT_SYS_INFO_OBJECT_CNT
  • SNAPSHOT_SYSTEM_INFO_OBJECT
  • SNAPSHOT_VMWARE_OBJ_CNT
  • SNAPSHOT_VMWARE_OBJECT

Audit

  • JOB_RUN
  • JOB_RESULT
  • AUDIT_BLFILE
  • AUDIT_BLFILE_CNT
  • AUDIT_CFG_FILE_OBJECT_CNT
  • AUDIT_COM_OBJECT
  • AUDIT_COM_OBJECT_CNT
  • AUDIT_CONFIG_FILE_OBJECT
  • AUDIT_DOT_NET_ASSEMBLY
  • AUDIT_EVENT_LOG
  • AUDIT_GENERIC_ASSET
  • AUDIT_GPO_SETTING
  • AUDIT_GPO_SETTING_CNT
  • AUDIT_METABASE_OBJECT
  • AUDIT_METABASE_OBJECT_CNT
  • AUDIT_OBJECT
  • AUDIT_OBJECT_PART
  • AUDIT_OBJECT_PART_COUNT
  • AUDIT_OS_GROUP
  • AUDIT_OS_USER
  • AUDIT_REGISTRY_OBJECT
  • AUDIT_REGISTRY_OBJECT_CNT
  • AUDIT_RESULT_PART_RULE_SET
  • AUDIT_SERVICE
  • AUDIT_SOFTWARE
  • AUDIT_SYS_INFO_OBJECT_CNT
  • AUDIT_SYSTEM_INFO_OBJECT
  • AUDIT_TARGET_PART_STATUS
  • AUDIT_VMWARE_OBJ_CNT
  • AUDIT_VMWARE_OBJECT

Patch

  • JOB_RESULT
  • BL_PATCH_ANALYSIS_RES_DATA
  • BL_PATCH_DOWNLOAD_RES_DATA
  • BL_PATCH_JOB_RES_PATCH_COUNT
  • BL_PATCH_JOB_RESULT_COUNT
  • BL_PATCH_RES_DEVICE_CNT
  • PAJOB_RUN_CATALOG_ASSOC
  • PATCH_CUJ_RESULT
  • PATCH_DEPENDENCY_MAP
  • PATCH_DOWNLOAD_RESULT
  • PATCH_RMD_DNL_JOB_RUN_ASSOC
  • PATCH_RMD_JOB_ASSOC
  • PATCH_RMD_RESULT
  • PATCHING_JOB_RESULTS_ASSOC
  • PATCHING_JOB_RUN_PART

Deploy


  • JOB_RUN
  • JOB_RESULT
  • JOB_RESULT_GEN_DEPOT_OBJECT
  • BATCH_JOB_RUN
  • DEPLOY_JOB_RUN
  • DEPLOY_JOB_RUN_ATTRIBUTE_REF
  • DEPLOY_JOB_RUN_CLASS_REF
  • DEPLOY_JOB_DEVICE_RUN


The following job type objects:

  • ComplianceResult
  • SnapshotResult
  • AuditResult
  • PatchResult
  • Deploy

Job run events

Log messages from job runs. This data is stored in the JOB_RUN_EVENT table.


Click here for the full list of tables that are cleaned up...
  • JOB_RUN_EVENT
  • DEPLOY_JOB_RUN_EVENT
  • OBJECT_OVERFLOW
  • OBJECT_OVERFLOW_DETAIL
JobRunEvent

Shared data

Generic assets and configuration objects created during the execution of Snapshot Jobs and Audit Jobs. Generic assets typically include configuration files, hardware information, processes, and daemons.

Click here for the full list of tables that are cleaned up...
  • OBJECT_OVERFLOW
  • OBJECT_OVERFLOW_DETAIL
  • CONFIG_FILE_OBJECT
  • CONFIG_FILE_OBJECT_VALUE
  • ASSET_ATTRIBUTE_VALUE
  • GENERIC_ASSET
SharedData

Audit trail

Click here for the full list of tables that are cleaned up...
  • APP_SERVER_AUDIT_TRAIL
  • AUDIT_TRAIL
  • AUTO_PRINCIPAL_AUDIT_TRAIL
  • BL_ACL_POLICY_AUDIT_TRAIL
  • BL_ACL_TEMPLATE_AUDIT_TRAIL
  • BL_ASSET_CLASS_AUDIT_TRAIL
  • BL_AUTH_PROFILE_AUDIT_TRAIL
  • BLGROUP_AUDIT_TRAIL
  • BLROLE_AUDIT_TRAIL
  • BLUSER_AUDIT_TRAIL
  • COMPONENT_AUDIT_TRAIL
  • CUSTOM_COMMAND_AUDIT_TRAIL
  • DEPOT_OBJECT_AUDIT_TRAIL
  • DEVICE_AUDIT_TRAIL
  • EXECUTION_TASK_AUDIT_TRAIL
  • EXTENDED_OBJECT_AUDIT_TRAIL
  • JOB_AUDIT_TRAIL
  • LDAP_CONNECTION_AUDIT_TRAIL
  • LDAP_QUERY_AUDIT_TRAIL
  • PM_DEVICE_AUDIT_TRAIL
  • PROP_SET_CLASS_AUDIT_TRAIL
  • PROP_SET_INSTANCE_AUDIT_TRAIL
  • ROUTING_POLICY_AUDIT_TRAIL
  • SERVER_CONFIG_DEF_AUDIT_TRAIL
  • SYSTEM_PACKAGE_AUDIT_TRAIL
  • TEMPLATE_AUDIT_TRAIL
AuditTrail

Database

Deletes older version of components that have no association with Snapshot, Audit, or Compliance modules. 

Click here for the full list of tables that are cleaned up...
  • AUDIT_JOB_PART_RULE_SET
  • BATCH_JOB_JOB
  • BLPKGBUILDER_SOFTWARE_MATCH
  • COMP_REMEDIATION_TEMPLATE
  • COMPLIANCE_REMEDIATION_OPTIONS
  • COMPLIANCE_REMEDIATION_RUN
  • DEPLOY_JOB_COMPONENT_PROP_MAP
  • FILE_DEPLOY_JOB_SOURCE
  • IMG_CAPTURE_JOB_OPTIONS
  • JOB
  • JOB_ASSET_CLASS
  • JOB_COMPONENT_GROUP
  • JOB_DEPOT_OBJECT
  • JOB_DEPOT_OBJECT_GROUP
  • JOB_DEPOT_SOFTWARE_PART
  • JOB_DEVICE
  • JOB_DEVICE_GROUP
  • JOB_MASTER_COMPONENT
  • JOB_MASTER_DEVICE
  • JOB_MASTER_SNAPSHOT
  • JOB_NOTIFICATION
  • JOB_NSH_PARAM_RUNTIME
  • JOB_NSH_PARAMETER_VALUE
  • JOB_OPTION_VALUE
  • JOB_PM_DEVICE
  • JOB_RESULT_INVALID_JOB
  • JOB_RESULT_INVALID_JOB_TP
  • JOB_RESULT_JOB
  • JOB_RESULT_UPGRADED_JOB
  • JOB_TARGET_JOB
  • JOB_TARGET_JOB
  • JOB_TARGET_JOB_GROUP
  • JOB_TEMPLATE
  • JOB_TEMPLATE_GROUP
  • PAJOB_CATALOG_ASSOCIATION
  • PATCH_JOB_MASTER_FILTER_ASSOC
  • PATCH_RMD_JOB_ASSOC
  • PATCH_RMD_JOB_INFO
  • PATCHING_JOB_ASSOC
  • PATCHING_JOB_CONF_FILE_ASSOC
  • PROV_JOB_PROPS
  • SCAP_JOB_PROFILE_BENCHMARK_MAP
  • VIRTUAL_GUEST_JOB_ASSOC
  • VIRTUAL_GUEST_PACKAGE
  • VIRTUAL_GUEST_PACKAGE_BASE
  • VIRTUAL_GUEST_SERVER_PROPS
  • VMCAPTURE_JOB_INPUTS
  • VMDESTINATION_DETAILS
  • VMIMPORT_JOB_INPUTS
  • VSMJOB_ORPHAN_REMED_MAPPINGS
  • WORKFLOW
OldVersionComponent

Database

Deletes older version of jobs that have no runs associated with that version.

Click here for the full list of tables that are cleaned up...
  • BATCH_JOB_JOB
  • JOB
  • JOB_DEPOT_OBJECT
  • JOB_DEVICE_GROUP
  • JOB_NSH_PARAM_RUNTIME
  • JOB_NSH_PARAMETER_VALUE
  • JOB_OPTION_VALUE
  • JOB_TEMPLATE
  • FILE_DEPLOY_JOB_SOURCE
  • JOB_DEVICE
OldVersionJob


Note

During online database cleanup, various cleanup-related log messages are saved in the DBM_RUN_LOG table. As of Service Pack 1 (product version 8.9.01), this table is cleaned up as well during subsequent cleanups of historical data (any cleanup mode that runs the Delete cleanupHistoricalData command) or cleanups of the database (any cleanup mode that runs the Delete cleanupDatabase command). Log messages from only the last 4 cleanup runs of each object type are retained.


Job data in the GUI

To help you understand the difference between the various types of job data, let's take a look at where each type of job data is displayed in the TrueSight Server Automation Console. The following figure shows the display of results for a job with multiple job runs.

job_run_info.PNG

Note the following elements:

  • Job run data in the tree structure that appears in the left-hand part of the results includes job scheduling data.
  • Job result data appears in the lower-level nodes of the tree structure and (mostly) in the tabular display on the right.
  • Job run event data appears when you select the Show Log option for a job run.
  • The audit trail for the job appears in the bottom left corner of the console.

Each type of data can be cleaned up separately. For example, you can delete old job run event data (job log messages) while still keeping job run schedules and results. In fact, this happens when job run event data is deleted based on a default retention period of 14 days, while job result data is deleted based on a job property that you set to the recommended retention period of 30 days. The following figure shows such a case, where job result data is present but job log messages have been cleaned up and are no longer present.  The job run is the gatekeeper object - if it is soft-deleted, none of the other data will be visible in the GUI.
job_run_blank.png

Shared objects

Another type of TrueSight Server Automation data that can consume a large amount of database space is shared objects. This is the data that is shared across multiple modules like ACL policies, configuration objects, and file contents for Snapshot Jobs and Audit Jobs. These shared objects accumulate rapidly especially if you run inventory snapshots (or any other environment-wide Snapshot Jobs or Audit Jobs) on a frequent basis.

Shared objects are removed from the database by the Delete hardDeleteAllSharedObjects command, which is called by the out-of-the-box cleanup job that BMC recommends that you run at least once a week.

Shared objects are cleaned up from the following database tables:

Database tables

Class

Type of data

BLFILE

SBLFile

References to depot objects, audit objects, and snapshot objects

BL_ACL
BL_ACL_BL_ACE
BL_ACL_AGG_AUTH

SBlAcl

References to access control lists (ACLs)

BL_VALUE

SBlValue

References to generic model objects. These are internal values generated by TrueSight Server Automation, such as values created for specific instances of a property class or a Depot object.

BLFILE_CHECKSUM

SBLFileChecksum

Checksum file references


Note

These shared objects are java-based and they differ from the historical, procedure-based shared data that is deleted by the Delete cleanupHistoricalData command when run for the SharedData object type. Cleanup of these two types of shared data complement each other and do not overlap.


Data on TrueSight Server Automation components

Data cleanup further involves the deletion of old data from several components of the TrueSight Server Automation environment. The following table provides a summary of the TrueSight Server Automation components for which cleanup commands are available, along with details about the data that is deleted and recommendations for how often to run these commands.

Component

BLCLI command

Details

Database

Delete cleanupDatabase

Deletes objects that have been previously marked for deletion (that is, objects that have been soft deleted), whether by deletion through the TrueSight Server Automation Console or by executing a retention policy for old data.

The cleanupDatabase command is called by the out-of-the-box cleanup job, when run in TYPICAL mode or in CLEAN_DB mode. BMC recommends cleaning the database at least once a week.

Note: Certain objects in the database are not deleted due to potential object dependencies. The cleanup process deletes all top-level model objects of the classes listed in the hk_allowed_classes database table, as well as all their child classes (which are not listed in this table). BMC recommends that you do NOT modify the contents of the hk_allowed_classes table.

Click here for the full list of tables that are cleaned up......

The following table lists the database tables that are cleaned up by the cleanupDatabase command, along with the top-level classes that each table is associated with. In many cases, database tables are associated with multiple classes. During cleanup, actions are recorded in the blcli.log file according to these classes.

Table


asset_selector_exclude

  • SActionEnableCondition
  • SBlAssetClass
  • SBLGroup
  • SComponent
  • SIconCondition
  • SImplApplicability
  • SRoutingPolicy
  • STemplate

audit_blfile_cnt

SJobRunOfAuditJob

audit_config_file_object

SJobRunOfAuditJob

audit_registry_object

SJobRunOfAuditJob

audit_result_part_rule_set

SJobRunOfAuditJob

audit_service

SJobRunOfAuditJob

auto_principal_audit_trail

SAutomationPrincipal

bl_asset_class_children

SBlAssetClass

bl_asset_class_delta

  • SJobRunOfPolicyUpgradeJob
  • STemplateUpgradeResultInvalidCondition
  • STemplateUpgradeResultInvalidJobPart
  • STemplateUpgradeResultInvalidPart
  • STemplateUpgradeResultInvalidRule

bl_patch_analysis_res_data

  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfWindowsPatchAnalysisJob

bl_patch_job_res_patch_count

  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfWindowsPatchAnalysisJob

bl_value

  • SAclPushJob
  • SActionEnableCondition
  • SAgentInstallerJob
  • SAgentState
  • SAixCatalogUpdateJob
  • SAixPatchAnalysisJob
  • SAixPatchingJob
  • SAixUpdateType
  • SApplicationDiscoveryJob
  • SApplicationServerModel
  • SApprovalChangeTiming
  • SApprovalChangeType
  • SApprovalImpact
  • SApprovalRiskLevel
  • SApprovalStatus
  • SApprovalUrgency
  • SAtriumOrchestratorConfig
  • SAtriumToBlSyncJob
  • SAuditJob
  • SAutomationPrincipal
  • SBatchJob
  • SBlAclPolicy
  • SBlAclTemplate
  • SBlAssetClass
  • SBLGroup
  • SBLPackageBuilderJob
  • SBlPatchImpact
  • SBlPatchRebootMode
  • SBlPatchSingleUserMode
  • SBLRole
  • SBLUser
  • SComplianceJob
  • SComponent
  • SDebianCatalogUpdateJob
  • SDebianPatchAnalysisJob
  • SDebianPatchingJob
  • SDeployJob
  • SDeployJobAttempt
  • SDeployJobTemplate
  • SDepotObject
  • SDevice
  • SDeviceState
  • SDiscoveryJob
  • SExecutionTask
  • SFileDeployJob
  • SHotfixType
  • SIconCondition
  • SImplApplicability
  • SInbox
  • SJobPriority
  • SJobRunOfAclPushJob
  • SJobRunOfAgentInstallerJob
  • SJobRunOfAixCatalogUpdateJob
  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfAixPatchingJob
  • SJobRunOfApplicationDiscoveryJob
  • SJobRunOfAtriumToBlSyncJob
  • SJobRunOfAuditJob
  • SJobRunOfBatchJob
  • SJobRunOfBLPackageBuilderJob
  • SJobRunOfComplianceJob
  • SJobRunOfDebianCatalogUpdateJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfDebianPatchingJob
  • SJobRunOfDeployJob
  • SJobRunOfDiscoveryJob
  • SJobRunOfFileDeployJob
  • SJobRunOfLinuxImageCaptureJob
  • SJobRunOfNSHScriptJob
  • SJobRunOfOtherLinuxCatalogUpdateJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchingJob
  • SJobRunOfPatchDownloadJob
  • SJobRunOfPatchRMDJob
  • SJobRunOfPatchWorkflowJob
  • SJobRunOfPctPushJob
  • SJobRunOfPluginDeregistrationJob
  • SJobRunOfPluginDistributionJob
  • SJobRunOfPolicyUpgradeJob
  • SJobRunOfProvisionJob
  • SJobRunOfRedhatCatalogUpdateJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRedhatPatchingJob
  • SJobRunOfRpmLinuxCatalogUpdateJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchingJob
  • SJobRunOfSCAPComplianceJob
  • SJobRunOfSnapshotJob
  • SJobRunOfSolarisCatalogUpdateJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfSolarisPatchingJob
  • SJobRunOfUcsProvisionJob
  • SJobRunOfUpdateServerPropertyJob
  • SJobRunOfVirtualGuestJob
  • SJobRunOfVMCaptureJob
  • SJobRunOfVMImportJob
  • SJobRunOfVSMDiscoveryJob
  • SJobRunOfWindowsCatalogUpdateJob
  • SJobRunOfWindowsImageCaptureJob
  • SJobRunOfWindowsPatchAnalysisJob
  • SJobRunOfWindowsPatchingJob
  • SJobRunOfWorkflowJob
  • SJobRunVGTemplateEnrollment
  • SLdapConnection
  • SLdapQuery
  • SLinuxImageCaptureJob
  • SNSHScriptJob
  • SOperationType
  • SOs
  • SOtherLinuxCatalogUpdateJob
  • SOtherLinuxPatchAnalysisJob
  • SOtherLinuxPatchingJob
  • SPatchDownloadJob
  • SPatchRemediationJob
  • SPatchType
  • SPatchWorkFlowJob
  • SPctPushJob
  • SPluginDeregistrationJob
  • SPluginDistributionJob
  • SPmDevice
  • SPmState
  • SPolicyUpgradeJob
  • SProvisionJob
  • SRedhatCatalogUpdateJob
  • SRedhatPatchAnalysisJob
  • SRedhatPatchingJob
  • SRemoteHostAuthentication
  • SRepeaterServer
  • SRoutingPolicy
  • SRoutingRuleNetProxy
  • SRpmLinuxCatalogUpdateJob
  • SRpmLinuxPatchAnalysisJob
  • SRpmLinuxPatchingJob
  • SSCAPComplianceJob
  • SSchedule
  • SServerPatchingEnv
  • SSnapshotJob
  • SSolarisCatalogUpdateJob
  • SSolarisPatchAnalysisJob
  • SSolarisPatchingJob
  • STemplate
  • STokenRuleSet
  • SUcsProvisionJob
  • SUpdateServerPropertyJob
  • SVGTemplateEnrollmentJob
  • SVirtualGuestJob
  • SVMCaptureJob
  • SVMImportJob
  • SVSMDiscoveryJob
  • SWindowsCatalogUpdateJob
  • SWindowsImageCaptureJob
  • SWindowsPatchingJob
  • SWorkflowJob

blgroup_audit_trail

SBLGroup

blpkgbuilder_software_match

SBLPackageBuilderJob

compliance_rule_grp

STemplate

component_exception_rule_list

SComponent

deploy_device_exclude_list

  • SDeployJob
  • SVirtualGuestJob

deploy_job_component_prop_map

  • SDeployJob
  • SVirtualGuestJob

depot_object

SDepotObject

depot_object_location

SDepotObject

depot_object_ref

SDepotObject

depot_software_aix_container

SDepotObject

depot_software_hotfix

SDepotObject

depot_software_sol_ips_package

SDepotObject

depot_software_soltcluster

SDepotObject

exec_task_nsh_param_override

SExecutionTask

execution_task_job

SExecutionTask

extended_object_prop_ref

STemplate

hrb_property_set_class

  • SDepotObject
  • STemplate
  • STokenRuleSet

img_capture_job_options

  • SLinuxImageCaptureJob
  • SWindowsImageCaptureJob

job

  • SDeployJob
  • SDeployJobTemplate
  • SPatchWorkFlowJob
  • SVirtualGuestJob

job_audit_trail

  • SAclPushJob
  • SAgentInstallerJob
  • SAixCatalogUpdateJob
  • SAixPatchAnalysisJob
  • SAixPatchingJob
  • SApplicationDiscoveryJob
  • SAtriumToBlSyncJob
  • SAuditJob
  • SBatchJob
  • SBLPackageBuilderJob
  • SComplianceJob
  • SDebianCatalogUpdateJob
  • SDebianPatchAnalysisJob
  • SDebianPatchingJob
  • SDeployJob
  • SDeployJobAttempt
  • SDeployJobTemplate
  • SDiscoveryJob
  • SFileDeployJob
  • SLinuxImageCaptureJob
  • SNSHScriptJob
  • SOtherLinuxCatalogUpdateJob
  • SOtherLinuxPatchAnalysisJob
  • SOtherLinuxPatchingJob
  • SPatchDownloadJob
  • SPatchRemediationJob
  • SPatchWorkFlowJob
  • SPctPushJob
  • SPluginDeregistrationJob
  • SPluginDistributionJob
  • SPolicyUpgradeJob
  • SProvisionJob
  • SRedhatCatalogUpdateJob
  • SRedhatPatchAnalysisJob
  • SRedhatPatchingJob
  • SRpmLinuxCatalogUpdateJob
  • SRpmLinuxPatchAnalysisJob
  • SRpmLinuxPatchingJob
  • SSCAPComplianceJob
  • SSnapshotJob
  • SSolarisCatalogUpdateJob
  • SSolarisPatchAnalysisJob
  • SSolarisPatchingJob
  • SUcsProvisionJob
  • SUpdateServerPropertyJob
  • SVGTemplateEnrollmentJob
  • SVirtualGuestJob
  • SVMCaptureJob
  • SVMImportJob
  • SVSMDiscoveryJob
  • SWindowsCatalogUpdateJob
  • SWindowsImageCaptureJob
  • SWindowsPatchingJob
  • SWorkflowJob

job_device

  • SAclPushJob
  • SAgentInstallerJob
  • SAixCatalogUpdateJob
  • SAixPatchAnalysisJob
  • SAixPatchingJob
  • SApplicationDiscoveryJob
  • SAtriumToBlSyncJob
  • SAuditJob
  • SBatchJob
  • SBLPackageBuilderJob
  • SComplianceJob
  • SDebianCatalogUpdateJob
  • SDebianPatchAnalysisJob
  • SDebianPatchingJob
  • SDeployJob
  • SDeployJobAttempt
  • SDeployJobTemplate
  • SDiscoveryJob
  • SFileDeployJob
  • SLinuxImageCaptureJob
  • SNSHScriptJob
  • SOtherLinuxCatalogUpdateJob
  • SOtherLinuxPatchAnalysisJob
  • SOtherLinuxPatchingJob
  • SPatchDownloadJob
  • SPatchRemediationJob
  • SPatchWorkFlowJob
  • SPctPushJob
  • SPluginDeregistrationJob
  • SPluginDistributionJob
  • SPolicyUpgradeJob
  • SProvisionJob
  • SRedhatCatalogUpdateJob
  • SRedhatPatchAnalysisJob
  • SRedhatPatchingJob
  • SRpmLinuxCatalogUpdateJob
  • SRpmLinuxPatchAnalysisJob
  • SRpmLinuxPatchingJob
  • SSCAPComplianceJob
  • SSnapshotJob
  • SSolarisCatalogUpdateJob
  • SSolarisPatchAnalysisJob
  • SSolarisPatchingJob
  • SUcsProvisionJob
  • SUpdateServerPropertyJob
  • SVGTemplateEnrollmentJob
  • SVirtualGuestJob
  • SVMCaptureJob
  • SVMImportJob
  • SVSMDiscoveryJob
  • SWindowsCatalogUpdateJob
  • SWindowsImageCaptureJob
  • SWindowsPatchingJob
  • SWorkflowJob

job_master_component

SAuditJob

job_notification

  • SAclPushJob
  • SAgentInstallerJob
  • SAixCatalogUpdateJob
  • SAixPatchAnalysisJob
  • SAixPatchingJob
  • SApplicationDiscoveryJob
  • SAtriumToBlSyncJob
  • SAuditJob
  • SBatchJob
  • SBLPackageBuilderJob
  • SComplianceJob
  • SDebianCatalogUpdateJob
  • SDebianPatchAnalysisJob
  • SDebianPatchingJob
  • SDeployJob
  • SDeployJobAttempt
  • SDeployJobTemplate
  • SDiscoveryJob
  • SFileDeployJob
  • SLinuxImageCaptureJob
  • SNSHScriptJob
  • SOtherLinuxCatalogUpdateJob
  • SOtherLinuxPatchAnalysisJob
  • SOtherLinuxPatchingJob
  • SPatchDownloadJob
  • SPatchRemediationJob
  • SPatchWorkFlowJob
  • SPctPushJob
  • SPluginDeregistrationJob
  • SPluginDistributionJob
  • SPolicyUpgradeJob
  • SProvisionJob
  • SRedhatCatalogUpdateJob
  • SRedhatPatchAnalysisJob
  • SRedhatPatchingJob
  • SRpmLinuxCatalogUpdateJob
  • SRpmLinuxPatchAnalysisJob
  • SRpmLinuxPatchingJob
  • SSCAPComplianceJob
  • SSnapshotJob
  • SSolarisCatalogUpdateJob
  • SSolarisPatchAnalysisJob
  • SSolarisPatchingJob
  • SUcsProvisionJob
  • SUpdateServerPropertyJob
  • SVGTemplateEnrollmentJob
  • SVirtualGuestJob
  • SVMCaptureJob
  • SVMImportJob
  • SVSMDiscoveryJob
  • SWindowsCatalogUpdateJob
  • SWindowsImageCaptureJob
  • SWindowsPatchingJob
  • SWorkflowJob

job_result_blgroup

  • SJobRunOfAclPushJob
  • SJobRunOfAgentInstallerJob
  • SJobRunOfAixCatalogUpdateJob
  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfApplicationDiscoveryJob
  • SJobRunOfAtriumToBlSyncJob
  • SJobRunOfAuditJob
  • SJobRunOfBatchJob
  • SJobRunOfBLPackageBuilderJob
  • SJobRunOfComplianceJob
  • SJobRunOfDebianCatalogUpdateJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfDeployJob
  • SJobRunOfDiscoveryJob
  • SJobRunOfFileDeployJob
  • SJobRunOfLinuxImageCaptureJob
  • SJobRunOfNSHScriptJob
  • SJobRunOfOtherLinuxCatalogUpdateJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfPatchDownloadJob
  • SJobRunOfPatchRMDJob
  • SJobRunOfPatchWorkflowJob
  • SJobRunOfPctPushJob
  • SJobRunOfPluginDeregistrationJob
  • SJobRunOfPluginDistributionJob
  • SJobRunOfPolicyUpgradeJob
  • SJobRunOfProvisionJob
  • SJobRunOfRedhatCatalogUpdateJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRpmLinuxCatalogUpdateJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfSCAPComplianceJob
  • SJobRunOfSnapshotJob
  • SJobRunOfSolarisCatalogUpdateJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfUcsProvisionJob
  • SJobRunOfUpdateServerPropertyJob
  • SJobRunOfVirtualGuestJob
  • SJobRunOfVMCaptureJob
  • SJobRunOfVMImportJob
  • SJobRunOfVSMDiscoveryJob
  • SJobRunOfWindowsCatalogUpdateJob
  • SJobRunOfWindowsImageCaptureJob
  • SJobRunOfWindowsPatchAnalysisJob
  • SJobRunOfWorkflowJob
  • SJobRunVGTemplateEnrollment

job_result_device

  • SJobRunOfAclPushJob
  • SJobRunOfAgentInstallerJob
  • SJobRunOfAixCatalogUpdateJob
  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfApplicationDiscoveryJob
  • SJobRunOfAtriumToBlSyncJob
  • SJobRunOfAuditJob
  • SJobRunOfBatchJob
  • SJobRunOfBLPackageBuilderJob
  • SJobRunOfComplianceJob
  • SJobRunOfDebianCatalogUpdateJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfDeployJob
  • SJobRunOfDiscoveryJob
  • SJobRunOfFileDeployJob
  • SJobRunOfLinuxImageCaptureJob
  • SJobRunOfNSHScriptJob
  • SJobRunOfOtherLinuxCatalogUpdateJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfPatchDownloadJob
  • SJobRunOfPatchRMDJob
  • SJobRunOfPatchWorkflowJob
  • SJobRunOfPctPushJob
  • SJobRunOfPluginDeregistrationJob
  • SJobRunOfPluginDistributionJob
  • SJobRunOfPolicyUpgradeJob
  • SJobRunOfProvisionJob
  • SJobRunOfRedhatCatalogUpdateJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRpmLinuxCatalogUpdateJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfSCAPComplianceJob
  • SJobRunOfSnapshotJob
  • SJobRunOfSolarisCatalogUpdateJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfUcsProvisionJob
  • SJobRunOfUpdateServerPropertyJob
  • SJobRunOfVirtualGuestJob
  • SJobRunOfVMCaptureJob
  • SJobRunOfVMImportJob
  • SJobRunOfVSMDiscoveryJob
  • SJobRunOfWindowsCatalogUpdateJob
  • SJobRunOfWindowsImageCaptureJob
  • SJobRunOfWindowsPatchAnalysisJob
  • SJobRunOfWorkflowJob
  • SJobRunVGTemplateEnrollment

job_result_invalid_template

SJobRunOfPolicyUpgradeJob

job_result_job

SJobRunOfPolicyUpgradeJob

job_result_upgraded_pkg

SJobRunOfPolicyUpgradeJob

job_run_event

  • SComponent
  • SDevice
  • SJobRunOfAclPushJob
  • SJobRunOfAgentInstallerJob
  • SJobRunOfAixCatalogUpdateJob
  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfAixPatchingJob
  • SJobRunOfApplicationDiscoveryJob
  • SJobRunOfAtriumToBlSyncJob
  • SJobRunOfAuditJob
  • SJobRunOfBatchJob
  • SJobRunOfBLPackageBuilderJob
  • SJobRunOfComplianceJob
  • SJobRunOfDebianCatalogUpdateJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfDebianPatchingJob
  • SJobRunOfDeployJob
  • SJobRunOfDiscoveryJob
  • SJobRunOfFileDeployJob
  • SJobRunOfLinuxImageCaptureJob
  • SJobRunOfNSHScriptJob
  • SJobRunOfOtherLinuxCatalogUpdateJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchingJob
  • SJobRunOfPatchDownloadJob
  • SJobRunOfPatchRMDJob
  • SJobRunOfPatchWorkflowJob
  • SJobRunOfPctPushJob
  • SJobRunOfPluginDeregistrationJob
  • SJobRunOfPluginDistributionJob
  • SJobRunOfPolicyUpgradeJob
  • SJobRunOfProvisionJob
  • SJobRunOfRedhatCatalogUpdateJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRedhatPatchingJob
  • SJobRunOfRpmLinuxCatalogUpdateJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchingJob
  • SJobRunOfSCAPComplianceJob
  • SJobRunOfSnapshotJob
  • SJobRunOfSolarisCatalogUpdateJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfSolarisPatchingJob
  • SJobRunOfUcsProvisionJob
  • SJobRunOfUpdateServerPropertyJob
  • SJobRunOfVirtualGuestJob
  • SJobRunOfVMCaptureJob
  • SJobRunOfVMImportJob
  • SJobRunOfVSMDiscoveryJob
  • SJobRunOfWindowsCatalogUpdateJob
  • SJobRunOfWindowsImageCaptureJob
  • SJobRunOfWindowsPatchAnalysisJob
  • SJobRunOfWindowsPatchingJob
  • SJobRunOfWorkflowJob
  • SJobRunVGTemplateEnrollment

job_template

  • SApplicationDiscoveryJob
  • SAuditJob
  • SBatchJob
  • SBLPackageBuilderJob
  • SComplianceJob
  • SDeployJob
  • SDiscoveryJob
  • SFileDeployJob
  • SNSHScriptJob
  • SPolicyUpgradeJob
  • SSnapshotJob
  • SVirtualGuestJob

key_store_data_element

SKeyStore

ldap_query_audit_trail

SLdapQuery

ntilan_nic

  • SJobRunOfAclPushJob
  • SJobRunOfAgentInstallerJob
  • SJobRunOfAixCatalogUpdateJob
  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfAixPatchingJob
  • SJobRunOfApplicationDiscoveryJob
  • SJobRunOfAtriumToBlSyncJob
  • SJobRunOfAuditJob
  • SJobRunOfBatchJob
  • SJobRunOfBLPackageBuilderJob
  • SJobRunOfComplianceJob
  • SJobRunOfDebianCatalogUpdateJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfDebianPatchingJob
  • SJobRunOfDeployJob
  • SJobRunOfDiscoveryJob
  • SJobRunOfFileDeployJob
  • SJobRunOfLinuxImageCaptureJob
  • SJobRunOfNSHScriptJob
  • SJobRunOfOtherLinuxCatalogUpdateJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchingJob
  • SJobRunOfPatchDownloadJob
  • SJobRunOfPatchRMDJob
  • SJobRunOfPatchWorkflowJob
  • SJobRunOfPctPushJob
  • SJobRunOfPluginDeregistrationJob
  • SJobRunOfPluginDistributionJob
  • SJobRunOfPolicyUpgradeJob
  • SJobRunOfProvisionJob
  • SJobRunOfRedhatCatalogUpdateJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRedhatPatchingJob
  • SJobRunOfRpmLinuxCatalogUpdateJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchingJob
  • SJobRunOfSCAPComplianceJob
  • SJobRunOfSnapshotJob
  • SJobRunOfSolarisCatalogUpdateJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfSolarisPatchingJob
  • SJobRunOfUcsProvisionJob
  • SJobRunOfUpdateServerPropertyJob
  • SJobRunOfVirtualGuestJob
  • SJobRunOfVMCaptureJob
  • SJobRunOfVMImportJob
  • SJobRunOfVSMDiscoveryJob
  • SJobRunOfWindowsCatalogUpdateJob
  • SJobRunOfWindowsImageCaptureJob
  • SJobRunOfWindowsPatchAnalysisJob
  • SJobRunOfWindowsPatchingJob
  • SJobRunOfWorkflowJob
  • SJobRunVGTemplateEnrollment
  • SUcsProvisionJob

oval_definitions

SDepotObject

pajob_catalog_association

  • SAixPatchingJob
  • SBLGroup
  • SDebianPatchingJob
  • SOtherLinuxPatchingJob
  • SPatchDownloadJob
  • SPatchRemediationJob
  • SPatchWorkFlowJob
  • SRedhatPatchingJob
  • SRpmLinuxPatchingJob
  • SSolarisPatchingJob
  • SWindowsPatchingJob

patch_cuj_filter_options

  • SAixCatalogUpdateJob
  • SAixPatchAnalysisJob
  • SDebianCatalogUpdateJob
  • SDebianPatchAnalysisJob
  • SOtherLinuxCatalogUpdateJob
  • SOtherLinuxPatchAnalysisJob
  • SPatchWorkFlowJob
  • SRedhatCatalogUpdateJob
  • SRedhatPatchAnalysisJob
  • SSolarisCatalogUpdateJob
  • SSolarisPatchAnalysisJob
  • SWindowsCatalogUpdateJob

patch_dependency_map

  • SJobRunOfAixPatchAnalysisJob
  • SJobRunOfDebianPatchAnalysisJob
  • SJobRunOfOtherLinuxPatchAnalysisJob
  • SJobRunOfRedhatPatchAnalysisJob
  • SJobRunOfRpmLinuxPatchAnalysisJob
  • SJobRunOfSolarisPatchAnalysisJob
  • SJobRunOfWindowsPatchAnalysisJob

patch_rmd_job_info

SPatchRemediationJob

prop_set_class_audit_trail

  • SDepotObject
  • STemplate
  • STokenRuleSet

prov_job_res_system_package

SJobRunOfProvisionJob

repair_action_property_value

STemplate

scap_job_profile_benchmark_map

SSCAPComplianceJob

scap_result_rule_and_oval_data

SJobRunOfSCAPComplianceJob

scap_result_rule_data

SJobRunOfSCAPComplianceJob

scap_tailored_file

SDepotObject

schedule_till_completion

SSchedule

signature

STemplate

simple_condition

  • SActionEnableCondition
  • SBlAssetClass
  • SBLGroup
  • SIconCondition
  • SImplApplicability
  • SRoutingPolicy
  • STemplate

snapshot_component_stats

SJobRunOfSnapshotJob

snapshot_dot_net_assembly

  • SDevice
  • SJobRunOfSnapshotJob

snapshot_gpo_setting

  • SDevice
  • SJobRunOfSnapshotJob

snapshot_os_group

  • SDevice
  • SJobRunOfSnapshotJob

snapshot_sys_info_object_cnt

SJobRunOfSnapshotJob

system_package

SDepotObject

system_package_audit_trail

SDepotObject

system_package_jumpstart

SDepotObject

system_package_network_adapter

SDepotObject

system_package_nim_bosinstattr

SDepotObject

system_package_nim_disk_stanza

SDepotObject

ucs_storage_entry

SDepotObject

vgpcitrix_xen_network

SDepotObject

vgpgeneric_network

SDepotObject

vgplpar_virtual_serial_adp

SDepotObject

vgprhelkvmnetwork_address

SDepotObject

vgpstorage_extended_property

SDepotObject

vgptemplate_mapping

SDepotObject

vgpzone_file_system

SDepotObject

vgpzone_inherited_pkg_dir

SDepotObject

virtual_guest_job_assoc

SVirtualGuestJob

virtual_guest_package

SDepotObject

virtual_guest_package_base

SDepotObject

vmdestination_details

  • SVMCaptureJob
  • SVMImportJob

vsmjob_deletion_result

SJobRunOfVSMDiscoveryJob

vsmjob_orphan_remed_mappings

SVSMDiscoveryJob

workflow_param_multi_value

SWorkflowJob

workflow_parameter

SWorkflowJob

xccdf_benchmark

SDepotObject

xccdf_rules

SDepotObject

File Server

Delete cleanupFileServer 


Deletes data that is no longer needed in the file server, including unused files from the file server and from temporary file storage on the Application Server. This data is stored in the FILE_LOCATION table. The cleanupFileServer command does not cleanup Depot Objects that use the AGENT_MOUNT or NSH_COPY_AT_STAGING location type as these are not considered to be under File Server management, even if the files actually reside on the File Server. Patches stored in a Patch Catalog are a common example of these types of Depot Objects.

Before running the file server cleanup, ensure that the database cleanup (the cleanupDatabase command) has completed. In this way, you first remove objects from the database, and then you remove the actual underlying file system objects from the file server. 

The cleanupFileServer command is called by the out-of-the-box cleanup job, when run in TYPICAL mode or in CLEAN_FS mode. BMC recommends cleaning the file server at least once a week.

Application Servers

Delete cleanupAllAppServerCaches
and Delete cleanupAppServerCache 

Deletes old temporary files stored in the cache on all Application Servers (the cleanupAllAppServerCaches command) or on a specific Application Server (the cleanupAppServerCache command), provided that the Application Servers are up and running (and accessible).

Cleanup of Application Servers is not included in TYPICAL mode of the out-of-the-box cleanup job. Instead, these commands are called when you run the cleanup job in CLEAN_ALL_AS or CLEAN_AS mode, respectively.

The recommended frequency for Application Server cleanup can vary, depending on your environment. For example, in the example of a standard weekly cleanup plan Application Server cleanup is planned to run on a monthly basis, and in the example cleanup plan for large operational environments Application Server cleanup is planned to run on a daily basis.

RSCD Agent

 Delete cleanupAgent

Deletes old temporary files on a target server (agent). This includes old files that were created by Deploy Jobs in the Transactions directory (especially rollback files) and in the Staging directory.

Click here for more information about these directories...

The Transactions directory is either rscdInstallDirectory/Transactions or as specified by the server's TRANSACTIONS_DIR property (see Configuring-the-location-of-the-transactions-directory). Within the Transactions directory, the contents of the following directories are not touched during cleanup: mnt, locks, database, events, and logs.

The Staging directory is specified by the server's STAGING_DIR property.  

Cleanup of RSCD agents is not included in TYPICAL mode of the out-of-the-box cleanup job. Instead, this command is called when you run the cleanup job in CLEAN_AGENT mode. BMC recommends cleaning the RSCD Agents at least once a month. For best results, keep agent cleanup separate from database cleanup (for example, do not include these two types of cleanup jobs in one batch job).

Repeater Server

 Delete cleanupRepeater

Deletes old files from the staging directory of a repeater server.

Cleanup of the repeater server is not included in TYPICAL mode of the out-of-the-box cleanup job. Instead, this command is called when you run the cleanup job in CLEAN_REPEATER mode. BMC recommends cleaning the repeater server at least once a month. For best results, keep the cleanup of the repeater server separate from database cleanup (for example, do not include these two types of cleanup jobs in one batch job).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*