KACE Systems Management Appliance 9.1 Common Documents

On the General tab, make sure that the Enable Logging check box is selected. If it is not selected, select it, then send a test email to the appliance.

Go to the appliance Control Panel:

◦

If the Organization component is not enabled on the appliance, log in to the KACE SMA Administrator Console, http://KACE_SMA_hostname/admin, then click Settings.

◦

If the Organization component is enabled on the appliance, log in to the KACE SMA System Administration Console, http://KACE_SMA_hostname/system, or select System in the drop-down list in the top-right corner of the page, then click Settings.

On the left navigation bar, click Logs to display the Logs page.

Select a log from the Log drop-down list.

Examine the exim_mainlog_* and exim_paniclog_* files for problems.

Problem could include:

◦

Errors and unsuccessful steps

◦

Hostnames and other variables not fully resolved

Examine the Debug_* log for any other Exim problems such as runaway Exim processes.

These other logs might also provide clues to the problem:

◦

khelpdeskmailhandler_output

◦

khelpdeskmailnotifier_error

◦

khelpdeskmailnotifier_output

Examine the Microsoft Exchange SMTP service logs in C:\windows\system32\ologFiles\*SMTP for problems.

Troubleshooting email errors

Solutions exist for some typical email errors.

Email error

Solution

550 Unknown user

•

Make sure the address is correct.

•

Verify that the address matches the address used by Service Desk.

•

Try disabling the external SMTP server and removing the address from the network settings. Reboot and restore the address. Reboot once more.

451 error - unable to verify sender

Check DNS settings.

About Diagnostic Console Two-Factor Authentication

Diagnostic Console Two-Factor Authentication (2FA) allows you to control access to the appliance back-end. When you enable SSH access to the appliance and create a tether, the Quest Support team can log in to the back-end of the KACE SMA using the appliance root password together with an access token. Tokens are provided in the Initial Setup Wizard. They can be viewed and regenerated using the Diagnostic Console Two-Factor Authentication page in the appliance System Console. Each token can only be used once and must be given to the Quest Support contact before they can log in to the appliance through the tether or the console.

To navigate to this page, log in to the KACE SMA System Console. On the left navigation bar, under Settings, click Support, and on the Support page, under Troubleshooting Tools, click Diagnostic Console Two-Factor Authentication.

The security key and offline tokens that are provided with the appliance during the initial setup should be recorded and stored in secure location, not on the KACE SMA machine. You may be required to provide this information to Support, when needed.

After upgrading from an earlier version, if a message appears indicating that Diagnostic Console Two-Factor Authentication is disabled, and you want to enable it for enhanced security, follow the instructions in the message to enable it.

•

To replace the secret key and regenerate the offline tokens, click Replace Secret Key.

•

To regenerate offline tokens, click Regenerate Offline Tokens.

Appendixes

Database table names

Adding steps to task sections of scripts

LDAP variables

Database table names

Database table names can be used in reports and other database queries.

The following tables list the current database table names and the table names that have changed between the 6.3 and 6.4 versions of the KACE SMA:

•

Organization-level (ORG1) database tables

•

System-level (KBSYS) database tables

•

Changes to the ORG1 database

•

Changes to the KBSYS database

Organization-level (ORG1) database tables

The following table lists organization-level (ORG1) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.

Table 31. ORG1 database tables and components
Table	Component
ADVISORY	Service Desk: Knowledge Base
ADVISORY_LABEL_JT	Service Desk: Knowledge Base
ADVISORY_RATINGS	Service Desk: Knowledge Base
AGENTLESS_TASK_LOG	Appliance Administration: Discovery
ASSET	Asset Management
ASSET_ASSOCIATION	Asset Management
ASSET_CATALOG_ASSOCIATION	Asset Management
ASSET_CLASS	Asset Management: Asset Subtypes
ASSET_DATA_1	Asset Management: Import Assets
ASSET_DATA_2	Asset Management: Import Assets
ASSET_DATA_3	Asset Management: Import Assets
ASSET_DATA_4	Asset Management: Import Assets
ASSET_DATA_5	Asset Management: Import Assets
ASSET_DATA_6	Asset Management: Import Assets
ASSET_DATA_7	Asset Management: Import Assets
ASSET_FIELD_DEFINITION	Settings: Asset History
ASSET_FILTER	Asset Management: Labeling
ASSET_HIERARCHY	Asset Management
ASSET_HISTORY	Settings: Asset History
ASSET_TYPE	Asset Management: Asset Types
AUTHENTICATION	Appliance Administration
CLIENTDIST_LABEL_JT	Appliance Administration: KACE SMA Agent
CLIENT_DISTRIBUTION	Appliance Administration: KACE SMA Agent
CREDENTIAL	Settings: Credentials
CUSTOM_FIELD_DEFINITION	Appliance Administration
CUSTOM_VIEW	Appliance Administration: Service Desk Configuration
DASHBOARD	Dashboard
DASHBOARD_CACHE	Dashboard
DELL_ASSET	Security: Dell Updates
DELL_INVENTORY	Security: Dell Updates
DELL_INVENTORY_APPLICATION_DEVICE_JT	Security: Dell Updates
DELL_INVENTORY_DEVICE_JT	Security: Dell Updates
DELL_INVENTORY_LOG	Security: Dell Updates
DELL_MACHINE_PKG_UPDATE_STATUS	Security: Dell Updates
DELL_MACHINE_STATUS	Security: Dell Updates
DELL_PKG_LABEL_JT	Security: Dell Updates
DELL_PKG_STATUS	Security: Dell Updates
DELL_PKG_UPDATE_HISTORY	Security: Dell Updates
DELL_SCHEDULE	Security: Dell Updates
DELL_SCHEDULE_LABEL_JT	Security: Dell Updates
DELL_SCHEDULE_MACHINE_STATUS	Security: Dell Updates
DELL_SCHEDULE_OS_JT	Security: Dell Updates
DELL_SCHEDULE_UPDATE_LABEL_JT	Security: Dell Updates
DELL_WARRANTY	Security: Dell Updates
DEVICE_DETAIL_FIELD	Inventory: Devices
DEVICE_DETAIL_GROUP	Inventory: Devices
DEVICE_DETAIL_GROUP_ASSET_CLASS_JT	Inventory: Devices
DEVICE_DETAIL_SECTION	Inventory: Devices
DEVICE_DETAIL_SECTION_ASSET_CLASS_JT	Inventory: Devices
DEVP_PROFILE_APPLIED	Scripting: Mac Profiles
DEVP_PROFILE_APPLIED_MACHINE	Scripting: Mac Profiles
DEVP_PROFILE_APPLIED_PAYLOAD	Scripting: Mac Profiles
DEVP_PROFILE_APPLIED_PAYLOAD_ATTRIBUTE	Scripting: Mac Profiles
FILTER	Labels
FS	File Synchronization
FS_LABEL_JT	File Synchronization
FS_MACHINE_JT	File Synchronization
GLOBAL_OPTIONS	Appliance Administration
GRID_COLUMNS_OVERRIDES	Appliance Administration
HD_ANNOUNCEMENT	Service Desk: Announcements
HD_ANNOUNCEMENT_LABEL_JT	Service Desk: Announcements
HD_ARCHIVE_ATTACHMENT	Service Desk: Ticket Archive
HD_ARCHIVE_TICKET	Service Desk: Ticket Archive
HD_ARCHIVE_TICKET_CHANGE	Service Desk: Ticket Archive
HD_ARCHIVE_TICKET_CHANGE_FIELD	Service Desk: Ticket Archive
HD_ARCHIVE_WORK	Service Desk: Ticket Archive
HD_ATTACHMENT	Service Desk: Tickets
HD_CATEGORY	Service Desk: Tickets
HD_CUSTOM_FIELDS	Service Desk: Tickets
HD_EMAIL_EVENT	Service Desk: Tickets
HD_FIELD	Service Desk: Tickets
HD_HOME_PAGE_WIDGET	Service Desk: User Console Home Page
HD_IMPACT	Service Desk: Tickets
HD_LINK	Service Desk: User Console Home Page
HD_MAILTEMPLATE	Service Desk: Tickets
HD_PRIORITY	Service Desk: Tickets
HD_QUEUE	Service Desk: Queues
HD_QUEUE_APPROVER_LABEL_JT	Service Desk: Queues
HD_QUEUE_OWNER_LABEL_JT	Service Desk: Queues
HD_QUEUE_SUBMITTER_LABEL_JT	Service Desk: Queue
HD_SERVICE	Service Desk: Tickets
HD_SERVICE_TICKET	Service Desk: Tickets
HD_SERVICE_USER_LABEL_JT	Service Desk: Tickets
HD_SLA_BUSINESS_HOURS	Service Desk: Service Level Agreement
HD_SLA_HOLIDAYS	Service Desk: Service Level Agreement
HD_STATUS	Service Desk: Tickets
HD_TICKET	Service Desk: Tickets
HD_TICKET_CHANGE	Service Desk: Tickets
HD_TICKET_CHANGE_FIELD	Service Desk: Tickets
HD_TICKET_FILTER	Service Desk: Tickets
HD_TICKET_RELATED	Service Desk: Tickets
HD_TICKET_RULE	Service Desk: Tickets
HD_WORK	Service Desk: Tickets
IM_CRON	Appliance Administration
KBOT	Scripting
KBOT_CRON_SCHEDULE	Scripting
KBOT_DEPENDENCY	Scripting
KBOT_EVENT_SCHEDULE	Scripting
KBOT_FORM	Scripting
KBOT_FORM_DATA	Scripting
KBOT_LABEL_JT	Scripting
KBOT_LOG	Scripting
KBOT_LOG_DETAIL	Scripting
KBOT_LOG_LATEST	Scripting
KBOT_OS_FAMILY_JT	Scripting
KBOT_OS_JT	Scripting
KBOT_RUN	Scripting
KBOT_RUN_MACHINE	Scripting
KBOT_RUN_TOKEN	Scripting
KBOT_SHELL_SCRIPT	Scripting
KBOT_UPLOAD	Scripting
KBOT_VERIFY	Scripting
KBOT_VERIFY_STEPS	Scripting
KMON_ALERT	Monitoring
KMON_CONDITION	Monitoring
KMON_CONFIG	Monitoring
KMON_CONFIG_DEFAULT	Monitoring
KMON_CONFIG_DETAIL	Monitoring
KMON_CONFIG_DEVICE_JT	Monitoring
KMON_INSTALL_LEP_DEVICE_JT	Monitoring: Log Enablement Packages
KMON_LEP	Monitoring: Log Enablement Package
KMON_LEP_INSTALL	Monitoring: Log Enablement Package
KMON_LOG_CONFIG	Monitoring
KMON_MAINT_CONFIG	Monitoring
KMON_MONITORED_DEVICE	Monitoring
LABEL	Labels
LABEL_LABEL_JT	Labels
LDAP_FILTER	Labels: LDAP
LDAP_IMPORT_USER	Labels: LDAP
MACHINE	Inventory: Devices
MACHINE_ACTIONS	Inventory: Devices
MACHINE_BITLOCKER_VOLUME	Inventory: Devices
MACHINE_CHROMEOS_DETAILS	Inventory: Devices
MACHINE_CUSTOM_INVENTORY	Inventory: Devices
MACHINE_DAILY_UPTIME	Inventory: Devices
MACHINE_DCM_AMT_SETTINGS	Inventory: Devices
MACHINE_DCM_BATTERY	Inventory: Devices
MACHINE_DCM_DESKTOP_MONITOR	Inventory: Devices
MACHINE_DCM_FLAT_PANEL	Inventory: Devices
MACHINE_DCM_LOG_ENTRY	Inventory: Devices
MACHINE_DCM_PHYSICAL_MEMORY	Inventory: Devices
MACHINE_DCM_PROCESSOR	Inventory: Devices
MACHINE_DCM_VPRO_SETTINGS	Inventory: Devices
MACHINE_DDPE	Inventory: Devices
MACHINE_DDPE_VOLUME	Inventory: Devices
MACHINE_DISKS	Inventory: Devices
MACHINE_DRIVE_ENCRYPTION_SUMMARY	Inventory: Devices
MACHINE_FIELD_DEFINITION	Inventory: Devices
MACHINE_FILEVAULT_VOLUME	Inventory: Devices
MACHINE_INTEL_AMT	Inventory: Devices
MACHINE_LABEL_JT	Inventory: Devices
MACHINE_LOCATION	Inventory: Devices
MACHINE_MOBILE	Inventory: Devices
MACHINE_NICS	Inventory: Devices
MACHINE_NTSERVICE_JT	Inventory: Devices
MACHINE_PROCESS_JT	Inventory: Devices
MACHINE_REPLITEM	Inventory: Devices
MACHINE_SNMP_DATA	Inventory: Devices
MACHINE_SOFTWARE_JT	Inventory: Devices
MACHINE_STARTUPPROGRAM_JT	Inventory: Devices
MACHINE_TPM	Inventory: Devices
MESSAGE	Distribution: Alerts
MESSAGE_LABEL_JT	Distribution: Alerts
MI	Distribution: Managed Installations
MI_ATTEMPT	Distribution: Managed Installations
MI_LABEL_JT	Distribution: Managed Installations
NODE	Inventory: Discovery
NODE_LABEL_JT	Inventory: Discovery
NODE_PORTS	Inventory: Discovery
NODE_SNMP_IF	Inventory: Discovery
NODE_SNMP_SYSTEM	Inventory: Discovery
NOTIFICATION	Reporting: Notifications
NOTIFICATION_USER_JT	Reporting: Notifications
NTSERVICE	Inventory: Services
NTSERVICE_LABEL_JT	Inventory: Services
OBJECT_FIELD_DEFINITION	Settings: History
OBJECT_HISTORY	Settings: History
OBJECT_HISTORY_CONFIGURATION	Settings: History
OPERATING_SYSTEMS	Inventory: Devices
OVAL_STATUS	Security: OVAL
PATCHLINK_BULLETIN_COUNT	Security: Patch Management
PATCHLINK_BULLETIN_MACHINE_STATUS	Security: Patch Management
PATCHLINK_MACHINE_APPLICABLE_PACKAGE	Security: Patch Management
PATCHLINK_MACHINE_STATUS	Security: Patch Management
PATCHLINK_PATCH_COUNT	Security: Patch Management
PATCHLINK_PATCH_LABEL_JT	Security: Patch Management
PATCHLINK_PATCH_STATUS	Security: Patch Management
PATCHLINK_SCHEDULE	Security: Patch Scheduling
PATCHLINK_SCHEDULE_DEPLOY_LABEL_JT	Security: Patch Scheduling
PATCHLINK_SCHEDULE_DETECT_LABEL_JT	Security: Patch Scheduling
PATCHLINK_SCHEDULE_LABEL_JT	Security: Patch Scheduling
PATCHLINK_SCHEDULE_MACHINE_STATUS	Security: Patch Scheduling
PATCHLINK_SCHEDULE_OS_JT	Security: Patch Scheduling
PATCHLINK_SCHEDULE_ROLLBACK_LABEL_JT	Security: Patch Scheduling
PATCHLINK_SCHEDULE_RUN	Security: Patch Scheduling
PATCHLINK_SCHEDULE_RUN_COUNTS	Security: Patch Scheduling
PATCHLINK_SCHEDULE_RUN_LOG	Security: Patch Scheduling
PATCHLINK_SCHEDULE_RUN_MACHINE	Security: Patch Scheduling
PATCH_FILTER	Security: Patch Management
PATCH_SETTINGS	Security: Patch Scheduling
PORTAL	Service Desk: User Console
PORTAL_LABEL_JT	Service Desk: User Console
PROCESS	Inventory: Processes
PROCESS_LABEL_JT	Inventory: Process
PROVISION_CONFIG	Settings: Agent Provisioning
PROVISION_NODE	Settings: Agent Provisioning
REMOTE_CHROMEOS_HOST	Settings: Agentless Provisioning
REMOTE_DMM_HOST	Settings: Agentless: Dell Mobility Manager
REMOTE_HOST	Settings: Agentless Provisioning
REMOTE_HOST_KUID	Settings: Agentless Provisioning
REMOTE_SHELL_HOST	Settings: Agentless Provisioning
REMOTE_SNMP_HOST	Settings: Agentless Provisioning
REMOTE_WSMAN_HOST	Settings: Agentless Provisioning
REPLICATION_LANGUAGE	Distribution: Replication
REPLICATION_PLATFORM	Distribution: Replication
REPLICATION_SCHEDULE	Distribution: Replication
REPLICATION_SHARE	Distribution: Replication
REPORT_FIELD	Reporting
REPORT_FIELD_GROUP	Reporting
REPORT_JOIN	Reporting
REPORT_OBJECT	Reporting
REPORT_OBJECT_JOIN	Reporting
REPORT_SCHEDULE	Reporting
SAM_CATALOG_FILTER	Inventory: Software Catalog
SAM_CATALOG_LABEL_JT	Inventory: Software Catalog
SAM_COMPLIANCE_DETAIL	Asset Management: License Compliance
SAM_COMPLIANCE_SUMMARY	Asset Management: License Compliance
SAM_COUNT	Inventory: Software Catalog
SAM_MACHINE_JT	Inventory: Software Catalog
SAM_MACHINE_TERMINATED_APPS	Inventory: Software Catalog
SAM_METER	Inventory: Software Catalog
SAM_METER_DATA	Inventory: Software Catalog
SAM_METER_TITLED_APPLICATION	Inventory: Software Catalog
SAM_NOT_ALLOWED	Inventory: Software Catalog
SAVED_SEARCH	Appliance Administration
SCAN_FILTER	Inventory: Discovery
SCAN_SETTINGS	Inventory: Discovery
SCAP_BENCHMARK	Security: SCAP
SCAP_GROUP	Security: SCAP
SCAP_PROFILE	Security: SCAP
SCAP_RESULT	Security: SCAP
SCAP_RESULT_RULE	Security: SCAP
SCAP_RESULT_SCORE	Security: SCAP
SCAP_RULE	Security: SCAP
SCAP_RULE_IDENT	Security: SCAP
SETTINGS	Settings
SETTINGS_HISTORY	Settings: History
SETTINGS_HISTORY_CONFIGURATION	Settings: History
SETTINGS_HISTORY_FIELD_DEFINITION	Settings: History
SMARTY_REPORT	Reporting
SNMP_INVENTORY_OIDS	Inventory: SNMP
SNMP_INVENTORY_SETTINGS	Inventory: SNMP
SNMP_INVENTORY_SETTINGS_JT	Inventory: SNMP
SNOOZE_ALERT	Patch Schedules
SOFTWARE	Inventory: Software
SOFTWARE_LABEL_JT	Inventory: Software
SOFTWARE_OS_JT	Inventory: Software
STARTUPPROGRAM	Inventory: Startup Programs
STARTUPPROGRAM_LABEL_JT	Inventory: Startup Programs
THROTTLE	Appliance Administration
USER	Settings: Users
USERIMPORT_SCHEDULE	Settings: User Authentication
USER_AUTO_REFRESH	Settings: Users
USER_HISTORY	Settings: Users
USER_KEYS	Settings: Users
USER_LABEL_JT	Settings: Users
USER_ROLE	Settings: Users
USER_ROLE_PERMISSION_VALUE	Settings: Users

System-level (KBSYS) database tables

The following table shows the System-level (KBSYS) database table names. Reference these table names when creating custom reports using SQL queries. See Create reports using SQL queries.

Table 32. KBSYS database tables and components
Table	Component
ACCESS_STATS	Appliance Administration (used to track page views)
AGENTLESS_TASK	Inventory
APPLE_MODEL	Inventory: Devices
AUTHENTICATION	Settings: Users
CLIENT_CRASH	Appliance Administration
COUNTRYCODE_MAPPING	Inventory: Devices(used for Dell devices)
CREDENTIAL_CONSUMER	Settings: Credentials
DASHBOARD	Dashboard
DASHBOARD_BASE_WIDGETS	Dashboard
DASHBOARD_CACHE	Dashboard
DASHBOARD_CUSTOM_WIDGETS	Dashboard
DASHBOARD_DATASOURCES	Dashboard
DASHBOARD_WIDGET_TYPES	Dashboard
DELL_CATALOG	Security: Dell Updates
DELL_CRITICALITY	Security: Dell Updates
DELL_ERROR_CODE	Security: Dell Updates
DELL_PKG	Security: Dell Updates
DELL_PKG_DEVICE	Security: Dell Updates
DELL_PKG_DEVICE_DEPENDENCY	Security: Dell Updates
DELL_PKG_DEVICE_PCI	Security: Dell Updates
DELL_PKG_DEVICE_PNP	Security: Dell Updates
DELL_PKG_DEVICE_VERSION	Security: Dell Updates
DELL_PKG_OS	Security: Dell Updates
DELL_PKG_OS_LANG	Security: Dell Updates
DELL_PKG_SYSTEM	Security: Dell Updates
DELL_RESOURCE	Security: Dell Updates
DELL_SUPPORTED_MODELS	Security: Dell Updates
DELL_UPDATE_STATUS	Security: Dell Updates
GLOBAL_OPTIONS	Appliance Administration
GRID_COLUMNS_BASE	Appliance Administration
GRID_COLUMNS_OVERRIDES	Appliance Administration
HD_EMAIL_EXCLUSION	Service Desk: Email Exclusion List
HISTORY_FIELD_VALUE_LABEL_MAP	Settings: History
IM_CRON	Appliance Administration (used for scheduled processes)
INVENTORY	Inventory
INVENTORY_FAILURES	Inventory
KBOT_GRAMMAR	Scripting
KBOT_GRAMMAR_ATTRIBUTE	Scripting
KBOT_UPLOAD_TOKENS	Scripting
KBOX	Scripting
KBOX_VERSION	Scripting
KONDUCTOR_TASK	Appliance Administration
KUID_MACHINE	Appliance Administration
KUID_ORGANIZATION	Appliance Administration
LICENSE_MODE	Appliance Administration
LINKED_APPLIANCE	Settings: Appliance Linking
LINKED_USER_TOKEN	Settings: Appliance Linking
LOCALE_BROWSER	Appliance Administration
LOCALE_COLLATION_RULES	Appliance Administration
LOCALE_SERVER	Appliance Administration
LOCALE_TIME_FORMAT	Appliance Administration
MSI_ERROR_CODES	Distribution
NETWORK_SETTINGS	Appliance Administration
ORGANIZATION	Organizations
ORGANIZATION_FILTER	Organizations: Filters
ORGANIZATION_FILTER_CRITERIA	Organizations: Filters
ORGANIZATION_FILTER_CRITERIA_LDAP	Organizations: Filters
ORG_ROLE	Organizations: Roles
ORG_ROLE_PERMISSION_VALUE	Organizations: Roles
OS_FAMILY	Inventory: Devices
OVAL_DEFINITION	Security: OVAL
OVAL_UPDATE_STATUS	Security: OVAL
PATCHLINK_ARCHITECTURE	Security: Patch Management
PATCHLINK_BULLETIN	Security: Patch Management
PATCHLINK_BULLETIN_CATALOG	Security: Patch Management
PATCHLINK_BULLETIN_OS_JT	Security: Patch Management
PATCHLINK_BULLETIN_UPDATE_STATUS	Security: Patch Management
PATCHLINK_ERROR_CODE	Security: Patch Management
PATCHLINK_IMPACT	Security: Patch Management
PATCHLINK_LANGUAGE	Security: Patch Management
PATCHLINK_LST	Security: Patch Management
PATCHLINK_LST_OSPX_MAP	Security: Patch Management
PATCHLINK_LST_PATCH_JT	Security: Patch Management
PATCHLINK_OS_TYPE	Security: Patch Management
PATCHLINK_PACKAGE	Security: Patch Management
PATCHLINK_PACKAGE_FILE	Security: Patch Management
PATCHLINK_PACKAGE_FLAGS	Security: Patch Management
PATCHLINK_PACKAGE_LANGUAGE_JT	Security: Patch Management
PATCHLINK_PACKAGE_OS_TYPE_JT	Security: Patch Management
PATCHLINK_PATCH	Security: Patch Management
PATCHLINK_PATCH_LANGUAGE_JT	Security: Patch Management
PATCHLINK_PATCH_OS_JT	Security: Patch Management
PATCHLINK_PATCH_PREREQ	Security: Patch Management
PATCHLINK_PATCH_PRODUCT	Security: Patch Management
PATCHLINK_PATCH_SUPERCEDES	Security: Patch Management
PATCHLINK_PLATFORM	Security: Patch Management
PATCHLINK_PUBLISHERS	Security: Patch Management
PATCHLINK_RESOURCE	Security: Patch Management
PATCHLINK_SCR_CONTENT	Security: Patch Management
PATCHLINK_UPDATE_STATUS	Security: Patch Management
PATCHLINK_VENDORATTRIBUTE	Security: Patch Management
PATCHLINK_VENDOR_SEVERITY	Security: Patch Management
PERMISSION_DEFINITION	Settings: Roles
PORT_SERVICES	Inventory: Discovery
PROVISIONING_ERRORS	Settings: Provisioning
REPORT_FIELD	Reporting
REPORT_FIELD_GROUP	Reporting
REPORT_JOIN	Reporting
REPORT_OBJECT	Reporting
REPORT_OBJECT_JOIN	Reporting
REPORT_SCHEDULE	Reporting
RESOURCE_EXPORTED	Settings: Resources
RESOURCE_QUEUE	Settings: Resources
SAM_APPLICATION	Software Catalog
SAM_HARDWARE	Software Catalog
SAM_LINUX_APPLICATION	Software Catalog
SAM_MUI_CACHE_DATA	Software Catalog
SAM_PUBLISHER	Software Catalog
SAM_SOFTWARE_TAG	Software Catalog
SAM_TITLE_REQUEST	Software Catalog
SAM_VIEW_ALL_SOFTWARE	Software Catalog
SAM_VIEW_DISCOVERED_APPLICATIONS	Software Catalog
SAM_VIEW_DISCOVERED_SOFTWARE	Software Catalog
SAM_VIEW_DISCOVERED_SUITES	Software Catalog
SAM_VIEW_INVENTORY_ADD_REMOVE_ PROGRAMS	Software Catalog
SAM_VIEW_INVENTORY_MOBILE_APPS	Software Catalog
SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE	Software Catalog
SAM_VIEW_TITLED_SOFTWARE	Software Catalog
SERVER_CRASH	Appliance Administration (used to track internal errors)
SERVICE_LEVEL_MAPPING	Inventory: Devices (used for Dell devices)
SETTINGS	Settings
SETTINGS_HISTORY	Settings: History
SETTINGS_HISTORY_CONFIGURATION	Settings: History
SETTINGS_HISTORY_FIELD_DEFINITION	Settings: History
SHAPING_METADATA	Inventory: API
SMARTY_REPORT	Reporting
SMMP_CONNECTION	Discovery
SMMP_CONNECTION_PLUGIN_JT	Discovery
SMMP_MSG_Q	Discovery
SMMP_NIC	Discovery
SMMP_PLUGIN	Discovery
SOFTWARE_INVENTORY	Inventory
SOFTWARE_INVENTORY_FAILURES	Inventory
SSL_CERT	Settings: Security Settings
SSL_CSR	Settings: Security Settings
SSL_PRIVATEKEY	Settings: Security Settings
SYSTEM_DEFINED_ROLES	Organizations: Roles
TIME_SETTINGS	Settings: Date and Time Settings
USER	Settings: Authentication
USER_AUTH	Settings: Authentication
USER_AUTO_REFRESH	Settings: Authentication

Changes to the ORG1 database

The following table shows the table names that have changed in the organization-level (ORG1) database between the 6.3 and 6.4 versions of the KACE SMA.

Table 33. ORG1 database table changes between versions 6.3 and 6.4
Table	Change description
ASSET_CLASS	Added
AUTH_CREDENTIALS	Removed
AUTH_GOOGLE_API	Removed
AUTH_NT_USER	Removed
AUTH_SNMP_V3	Removed
AUTH_USER_PWD	Removed
CREDENTIAL	Added
DEVICE_DETAIL_FIELD	Added
DEVICE_DETAIL_GROUP	Added
DEVICE_DETAIL_GROUP_ASSET_CLASS_JT	Added
DEVICE_DETAIL_SECTION	Added
DEVICE_DETAIL_SECTION_ASSET_CLASS_JT	Added
DEVP_PROFILE_APPLIED	Added
DEVP_PROFILE_APPLIED_MACHINE	Added
DEVP_PROFILE_APPLIED_PAYLOAD	Added
DEVP_PROFILE_APPLIED_PAYLOAD_ATTRIBUTE	Added
HD_ANNOUNCEMENT	Added
HD_ANNOUNCEMENT_LABEL_JT	Added
HD_HOME_PAGE_WIDGET	Added
HD_LINK	Added
KMON_INSTALL_LEP_DEVICE_JT	Added
KMON_LEP	Added
KMON_LEP_INSTALL	Added
MACHINE_BITLOCKER_VOLUME	Added
MACHINE_DCM_AMT_SETTINGS	Added
MACHINE_DCM_BATTERY	Added
MACHINE_DCM_DESKTOP_MONITOR	Added
MACHINE_DCM_FLAT_PANEL	Added
MACHINE_DCM_LOG_ENTRY	Added
MACHINE_DCM_PHYSICAL_MEMORY	Added
MACHINE_DCM_PROCESSOR	Added
MACHINE_DCM_VPRO_SETTINGS	Added
MACHINE_DDPE	Added
MACHINE_DDPE_VOLUME	Added
MACHINE_DRIVE_ENCRYPTION_SUMMARY	Added
MACHINE_FILEVAULT_VOLUME	Added
MACHINE_LOCATION	Added
MACHINE_MOBILE	Added
MACHINE_TPM	Added
MSP_MI_TEMPLATE	Removed
REMOTE_DMM_HOST	Added
REPORT	Removed
SAM_COMPLIANCE_DETAIL	Added
SAM_COMPLIANCE_SUMMARY	Added
SAM_COMPLIANCE_DETAIL	Added
SAM_COMPLIANCE_SUMMARY	Added
SAM_VIEW_ALL_SOFTWARE	Removed
SAM_VIEW_DISCOVERED_APPLICATIONS	Removed
SAM_VIEW_DISCOVERED_SOFTWARE	Removed
SAM_VIEW_DISCOVERED_SUITES	Removed
SAM_VIEW_INVENTORY_ADD_REMOVE_ PROGRAMS	Removed
SAM_VIEW_INVENTORY_MOBILE_APPS	Removed
SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE	Removed
SAM_VIEW_TITLED_SOFTWARE	Removed

Changes to the KBSYS database

The following table shows the table names that have changed in the System-level (KBSYS) database between the 6.3 and 6.4 versions of the KACE SMA.

Table 34. KBSYS database table changes between versions 6.3 and 6.4
Table	Change description
AGENTLESS_TASK_LOG	Removed
CREDENTIAL_CONSUMER	Added
DAC_AGENTLESS	Removed
HD_EMAIL_EXCLUSION	Added
JOIN_METADATA	Added
REPORT	Removed
PATCH_SETTINGS	Removed
SAM_ADD_REMOVE_PROGRAM
SAM_APPLICATION_FILE	Removed
SAM_HARDWARE	Added
SAM_MOBILE_APPLICATION_FILE
SAM_SOFTWARE_TAG	Added
SHAPING_METADATA	Added

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

KACE Systems Management Appliance 9.1 Common Documents - Administrator Guide

Access appliance logs to view Microsoft Exchange Server errors

Troubleshooting email errors

About Diagnostic Console Two-Factor Authentication

Appendixes