ZENworks Diagnostic Center (ZDC) does not report on Audit Database correctly

Document ID:7016999
Creation Date:17-Nov-2015
Modified Date:31-May-2016
- Micro Focus Products:
  ZENworks Configuration Management

Environment

Novell ZENworks Configuration Management 11.3 Documentation

Novell ZENworks Configuration Management 11.3 ZENworks Diagnostic Center (ZDC)

Situation

Ran ZDC per the README

On Windows:
zdc.bat verify -b

On Linux:
bash zdc verify -b

For example,
zdc.bat verify -b C:\zdc\data\baseline_11.3.2.zdc

ZDC Database Verifier shows multiple inconsistencies and errors for the Audit Database

Missing Tables
Missing Views
Missing Procedures

For a searchable list of possible errors, see Additional Information

Resolution

Refer to the documentation rather than the readme.

Verifying Audit Database
To verify the Audit Database schema in ZENworks 11 SP3 by using the ZDC tool:
On Windows: Run the zdc.bat verify -v auditdatabase -b <complete_path_of_the_ZDC_baseline_data_file> command.
On Linux: Run the ./zdc verify -v auditdatabase -b <complete_path_of_the_ZDC_baseline_data_file> command.
Audit and ZENworks databases cannot be verified by running the command in one instance. They need to be verified separately.

Cause

The README does not include the correct instructions for running ZDC against the Audit Database.

Additional Information

Any or all of the following may be listed as errors.

ERROR Missing Table 'AUDIT_EVENT_DEF'

ERROR Missing Table 'CA_ADMIN'

ERROR Missing Table 'CA_ADMINGRP'

ERROR Missing Table 'CA_ADMINROLE'

ERROR Missing Table 'CA_ADMINUSRGRP'

ERROR Missing Table 'CA_AGENT_SETTING'

ERROR Missing Table 'CA_AUDITERROR'

ERROR Missing Table 'CA_BUNASSOC'

ERROR Missing Table 'CA_BUNDLES'

ERROR Missing Table 'CA_BUNFOLDER'

ERROR Missing Table 'CA_BUNGROUP'

ERROR Missing Table 'CA_CREDENTIALVAULT'

ERROR Missing Table 'CA_CREDFOLDER'

ERROR Missing Table 'CA_DASHBOARD'

ERROR Missing Table 'CA_DEPLOYMENT'

ERROR Missing Table 'CA_DEVFOLDER'

ERROR Missing Table 'CA_DEVGROUP'

ERROR Missing Table 'CA_DEVICE'

ERROR Missing Table 'CA_DISCOVERY'

ERROR Missing Table 'CA_FULLDISKENCRYPT'

ERROR Missing Table 'CA_LOCASSOC'

ERROR Missing Table 'CA_LOCATION'

ERROR Missing Table 'CA_NETWORKENV'

ERROR Missing Table 'CA_PATCHBUNDLE'

ERROR Missing Table 'CA_PATCHSIGNATURE'

ERROR Missing Table 'CA_POLASSOC'

ERROR Missing Table 'CA_POLFOLDER'

ERROR Missing Table 'CA_POLGROUP'

ERROR Missing Table 'CA_POLICY'

ERROR Missing Table 'CA_PRODUCTLICENSING'

ERROR Missing Table 'CA_QUERYGROUP'

ERROR Missing Table 'CA_QUICKTASK'

ERROR Missing Table 'CA_REGFOLDER'

ERROR Missing Table 'CA_REGKEY'

ERROR Missing Table 'CA_REGRULE'

ERROR Missing Table 'CA_RIGHTROLE'

ERROR Missing Table 'CA_SERVER_SETTING'

ERROR Missing Table 'CA_SHARINGSERVER'

ERROR Missing Table 'CA_SU'

ERROR Missing Table 'CA_SUBFOLDER'

ERROR Missing Table 'CA_SUBSCRIPTIONS'

ERROR Missing Table 'CA_SUSTAGE'

ERROR Missing Table 'CA_USER'

ERROR Missing Table 'CA_USERSOURCE'

ERROR Missing Table 'CA_ZCCLOGIN'

ERROR Missing Table 'CA_ZENSERVER'

ERROR Missing Table 'CA_ZESM'

ERROR Missing Table 'CA_ZONE'

ERROR Missing Table 'CA_ZSERVER_LDAPSRCCONN_ASSOC'

ERROR Missing Table 'CACHGS_ADMIN'

ERROR Missing Table 'CACHGS_ADMINGRP'

ERROR Missing Table 'CACHGS_ADMINROLE'

ERROR Missing Table 'CACHGS_ADMINUSRGRP'

ERROR Missing Table 'CACHGS_AGENT_SETTING'

ERROR Missing Table 'CACHGS_BUNASSOC'

ERROR Missing Table 'CACHGS_BUNDLES'

ERROR Missing Table 'CACHGS_BUNFOLDER'

ERROR Missing Table 'CACHGS_BUNGROUP'

ERROR Missing Table 'CACHGS_CREDENTIALVAULT'

ERROR Missing Table 'CACHGS_CREDFOLDER'

ERROR Missing Table 'CACHGS_DEPLOYMENT'

ERROR Missing Table 'CACHGS_DEVFOLDER'

ERROR Missing Table 'CACHGS_DEVGROUP'

ERROR Missing Table 'CACHGS_DEVICE'

ERROR Missing Table 'CACHGS_DISCOVERY'

ERROR Missing Table 'CACHGS_FULLDISKENCRYPT'

ERROR Missing Table 'CACHGS_LOCASSOC'

ERROR Missing Table 'CACHGS_LOCATION'

ERROR Missing Table 'CACHGS_NETWORKENV'

ERROR Missing Table 'CACHGS_PATCHBUNDLE'

ERROR Missing Table 'CACHGS_PATCHSIGNATURE'

ERROR Missing Table 'CACHGS_POLASSOC'

ERROR Missing Table 'CACHGS_POLFOLDER'

ERROR Missing Table 'CACHGS_POLGROUP'

ERROR Missing Table 'CACHGS_POLICIES'

ERROR Missing Table 'CACHGS_PRODUCTLICENSING'

ERROR Missing Table 'CACHGS_QUERYGROUP'

ERROR Missing Table 'CACHGS_REGFOLDER'

ERROR Missing Table 'CACHGS_REGKEY'

ERROR Missing Table 'CACHGS_REGRULE'

ERROR Missing Table 'CACHGS_RIGHTROLE'

ERROR Missing Table 'CACHGS_SERVER_SETTING'

ERROR Missing Table 'CACHGS_SHARINGSERVER'

ERROR Missing Table 'CACHGS_SU'

ERROR Missing Table 'CACHGS_SUBFOLDER'

ERROR Missing Table 'CACHGS_SUBSCRIPTIONS'

ERROR Missing Table 'CACHGS_SUSTAGE'

ERROR Missing Table 'CACHGS_USER'

ERROR Missing Table 'CACHGS_USERSOURCE'

ERROR Missing Table 'CACHGS_ZCCLOGIN'

ERROR Missing Table 'CACHGS_ZENSERVER'

ERROR Missing Table 'CACHGS_ZESM'

ERROR Missing Table 'CACHGS_ZONE'

ERROR Missing Table 'CALOB_ADMIN'

ERROR Missing Table 'CALOB_ADMINGRP'

ERROR Missing Table 'CALOB_ADMINROLE'

ERROR Missing Table 'CALOB_ADMINUSRGRP'

ERROR Missing Table 'CALOB_AGENT_SETTING'

ERROR Missing Table 'CALOB_BUNASSOC'

ERROR Missing Table 'CALOB_BUNDLES'

ERROR Missing Table 'CALOB_BUNFOLDER'

ERROR Missing Table 'CALOB_BUNGROUP'

ERROR Missing Table 'CALOB_CREDENTIALVAULT'

ERROR Missing Table 'CALOB_CREDFOLDER'

ERROR Missing Table 'CALOB_DEPLOYMENT'

ERROR Missing Table 'CALOB_DEVFOLDER'

ERROR Missing Table 'CALOB_DEVGROUP'

ERROR Missing Table 'CALOB_DEVICE'

ERROR Missing Table 'CALOB_DISCOVERY'

ERROR Missing Table 'CALOB_FULLDISKENCRYPT'

ERROR Missing Table 'CALOB_LOCASSOC'

ERROR Missing Table 'CALOB_LOCATION'

ERROR Missing Table 'CALOB_NETWORKENV'

ERROR Missing Table 'CALOB_PATCHBUNDLE'

ERROR Missing Table 'CALOB_PATCHSIGNATURE'

ERROR Missing Table 'CALOB_POLASSOC'

ERROR Missing Table 'CALOB_POLFOLDER'

ERROR Missing Table 'CALOB_POLGROUP'

ERROR Missing Table 'CALOB_POLICIES'

ERROR Missing Table 'CALOB_PRODUCTLICENSING'

ERROR Missing Table 'CALOB_QUERYGROUP'

ERROR Missing Table 'CALOB_REGFOLDER'

ERROR Missing Table 'CALOB_REGKEY'

ERROR Missing Table 'CALOB_REGRULE'

ERROR Missing Table 'CALOB_RIGHTROLE'

ERROR Missing Table 'CALOB_SERVER_SETTING'

ERROR Missing Table 'CALOB_SHARINGSERVER'

ERROR Missing Table 'CALOB_SU'

ERROR Missing Table 'CALOB_SUBFOLDER'

ERROR Missing Table 'CALOB_SUBSCRIPTIONS'

ERROR Missing Table 'CALOB_SUSTAGE'

ERROR Missing Table 'CALOB_USER'

ERROR Missing Table 'CALOB_USERSOURCE'

ERROR Missing Table 'CALOB_ZCCLOGIN'

ERROR Missing Table 'CALOB_ZENSERVER'

ERROR Missing Table 'CALOB_ZESM'

ERROR Missing Table 'CALOB_ZONE'

ERROR Missing Table 'CONFIGOBJ_REF'

ERROR Missing Table 'DA_AUDITERROR'

ERROR Missing Table 'DA_DASHBOARD'

ERROR Missing Table 'DA_FILEACTDETAILS'

ERROR Missing Table 'DA_FILEACTSUMMARY'

ERROR Missing Table 'DA_LOCATIONNECHANGES'

ERROR Missing Table 'DA_RM_AUTH_FAILURE'

ERROR Missing Table 'DA_RM_AUTH_SUCCESS'

ERROR Missing Table 'DA_RM_INTRDT_LCK'

ERROR Missing Table 'DA_RM_INTRDT_RST'

ERROR Missing Table 'DA_RMABNORMALTERMINATION'

ERROR Missing Table 'DA_RMREMOTECONTROL'

ERROR Missing Table 'DA_RMREMOTEDIAGNOSTICS'

ERROR Missing Table 'DA_RMREMOTEEXECUTE'

ERROR Missing Table 'DA_RMREMOTEFTP'

ERROR Missing Table 'DA_RMREMOTEVIEW'

ERROR Missing Table 'DA_USERLOGIN'

ERROR Missing Table 'DA_ZESM_EFFECTIVEPOLICY'

ERROR Missing Table 'DAACTN_FILEACTDETAILS'

ERROR Missing Table 'DAACTN_FILEACTSUMMARY'

ERROR Missing Table 'DAACTN_LOCATIONNECHANGES'

ERROR Missing Table 'DAACTN_RM_AUTH_FAILURE'

ERROR Missing Table 'DAACTN_RM_AUTH_SUCCESS'

ERROR Missing Table 'DAACTN_RM_INTRDT_LCK'

ERROR Missing Table 'DAACTN_RM_INTRDT_RST'

ERROR Missing Table 'DAACTN_RMABNORMALTERMINATION'

ERROR Missing Table 'DAACTN_RMREMOTECONTROL'

ERROR Missing Table 'DAACTN_RMREMOTEDIAGNOSTICS'

ERROR Missing Table 'DAACTN_RMREMOTEEXECUTE'

ERROR Missing Table 'DAACTN_RMREMOTEFTP'

ERROR Missing Table 'DAACTN_RMREMOTEVIEW'

ERROR Missing Table 'DAACTN_USERLOGIN'

ERROR Missing Table 'DAACTN_ZESM_EFFECTIVEPOLICY'

ERROR Missing Table 'DAEP_BootLocation'

ERROR Missing Table 'DAEP_FDE'

ERROR Missing Table 'DAEP_FDEDriveToEncrypt'

ERROR Missing Table 'DAEP_FDERebootControl'

ERROR Missing Table 'DAEP_Firewall'

ERROR Missing Table 'DAEP_FirewallSettingList'

ERROR Missing Table 'DAEP_HardwareControl'

ERROR Missing Table 'DAEP_Location'

ERROR Missing Table 'DAEP_MergeList'

ERROR Missing Table 'DAEP_Policy'

ERROR Missing Table 'DAEP_USBControlList'

ERROR Missing Table 'DAEP_VPNRule'

ERROR Missing Table 'LOCALUSER_REF'

ERROR Missing Table 'RM_FILES'

ERROR Missing Table 'RM_RE_APPLICATION'

ERROR Missing Table 'RM_RE_COMMANDS'

ERROR Missing Table 'USERLOGIN_REF'

ERROR Missing Table 'ZADMINISTRATOR_REF'

ERROR Missing Table 'ZADMINISTRATORGROUP_REF'

ERROR Missing Table 'ZADMINISTRATORUSERGROUP_REF'

ERROR Missing Table 'zAuditPruningLog'

ERROR Missing Table 'ZBUNDLE_REF'

ERROR Missing Table 'ZBUNFOLDER_REF'

ERROR Missing Table 'ZBUNGROUP_REF'

ERROR Missing Table 'ZCREDENTIALVAULT_REF'

ERROR Missing Table 'ZDEPLOYMENT_REF'

ERROR Missing Table 'ZDEVFOLDER_REF'

ERROR Missing Table 'ZDEVGROUP_REF'

ERROR Missing Table 'ZDEVICE_REF'

ERROR Missing Table 'ZDISCOVERYTASK_REF'

ERROR Missing Table 'ZESMForeignKeyLists_Ref'

ERROR Missing Table 'ZEXTERNALCREDENTIAL_REF'

ERROR Missing Table 'ZEXTERNALCREDENTIALFOLDER_REF'

ERROR Missing Table 'ZFOLDER_REF'

ERROR Missing Table 'ZLDAPSOURCE_REF'

ERROR Missing Table 'ZLDAPSOURCECONNECTION_REF'

ERROR Missing Table 'ZLICENSEINFO_REF'

ERROR Missing Table 'ZLOCATION_REF'

ERROR Missing Table 'ZNWENV_REF'

ERROR Missing Table 'ZOPAQUEDATA_REF'

ERROR Missing Table 'ZPATCHBUNDLE_REF'

ERROR Missing Table 'ZPATCHSIGNATURE_REF'

ERROR Missing Table 'ZPOLFOLDER_REF'

ERROR Missing Table 'ZPOLGROUP_REF'

ERROR Missing Table 'ZPOLICY_REF'

ERROR Missing Table 'ZPROCESS_REF'

ERROR Missing Table 'ZQUERYGROUP_REF'

ERROR Missing Table 'ZQUICKTASK_REF'

ERROR Missing Table 'ZREGISTRATIONFOLDER_REF'

ERROR Missing Table 'ZREGISTRATIONKEY_REF'

ERROR Missing Table 'ZREGISTRATIONRULE_REF'

ERROR Missing Table 'ZROLE_REF'

ERROR Missing Table 'ZSERVER_REF'

ERROR Missing Table 'ZSUBFOLDER_REF'

ERROR Missing Table 'ZSUBSCRIPTION_REF'

ERROR Missing Table 'ZSUSTAGE_REF'

ERROR Missing Table 'ZSYSTEMSETTING_REF'

ERROR Missing Table 'ZSYSTEMUPDATEEX_REF'

ERROR Missing Table 'ZUSERASSIGNMENT_REF'

ERROR Missing Table 'ZZENUSERGROUP_REF'

ERROR Missing Table 'ZZONE_REF'

ERROR Missing View 'VW_ALL_SUMMARY'

ERROR Missing View 'VW_CA_DETAIL'

ERROR Missing View 'VW_CA_SUMMARY'

ERROR Missing View 'VW_DA_SUMMARY'

ERROR Missing Procedure 'z_Audit_Pruning'

ERROR Missing Procedure 'z_DashboardAuditEventPruning'