KACE Systems Management Appliance 9.1 Common Documents - Administrator Guide

About the KACE Systems Management Appliance (SMA) Getting started
Configuring the appliance
Requirements and specifications Power-on the appliance and log in to the Administrator Console Access the Command Line Console Tracking configuration changes Configuring System-level and Admin-level General Settings Configure appliance date and time settings Enable Two-Factor Authentication for all users Verifying port settings, NTP service, and website access Configuring network and security settings Configuring Agent settings Configuring session timeout and auto-refresh settings Configuring locale settings Configuring the default theme Configure data sharing preferences About DIACAP compliance requirements Configuring Mobile Device Access Enable fast switching for organizations and linked appliances Linking Quest KACE appliances Configuring history settings
Setting up and using labels to manage groups of items Configuring user accounts, LDAP authentication, and SSO Using Replication Shares Managing credentials Configuring assets
About the Asset Management component Using the Asset Management Dashboard About managing assets Adding and customizing Asset Types and maintaining asset information Managing Software assets Managing physical and logical assets Maintaining and using manual asset information Managing locations Managing contracts Managing licenses Managing purchase records
Setting up License Compliance Managing License Compliance Setting up Service Desk Configure the Cache Lifetime for Service Desk widgets Creating and managing organizations Importing and exporting appliance resources
Managing inventory
Using the Inventory Dashboard Using Device Discovery Managing device inventory
About managing devices Features available for each device management method About inventory information Tracking changes to inventory settings Managing inventory information Finding and managing devices Provisioning the KACE SMA Agent Manually deploying the KACE SMA Agent Using Agentless management Adding devices manually in the Administrator Console or by using the API Forcing inventory updates Managing MIA devices Obtaining Dell warranty information
Managing applications on the Software page Managing Software Catalog inventory
About the Software Catalog Viewing Software Catalog information Adding applications to the Software Catalog Managing License assets for Software Catalog applications Associate Managed Installations with Cataloged Software Using software metering Using Application Control Update or reinstall the Software Catalog
Managing process, startup program, and service inventory Writing custom inventory rules
Deploying packages to managed devices
Distributing software and using Wake-on-LAN Broadcasting alerts to managed devices Running scripts on managed devices Managing Mac profiles Using Task Chains
Patching devices and maintaining security
About patch management Subscribing to and downloading patches Creating and managing patch schedules Managing patch inventory Managing Dell devices and updates Maintaining device and appliance security
Using reports and scheduling notifications Monitoring servers
Getting started with server monitoring Working with monitoring profiles Managing monitoring for devices Working with alerts
Using the Service Desk
Configuring Service Desk Using the Service Desk Dashboard Managing Service Desk tickets, processes, and reports
Overview of Service Desk ticket lifecycle Creating tickets from the Administrator Console and User Console Creating and managing tickets by email Viewing tickets and managing comments, work, and attachments Merging tickets Using the ticket escalation process Using Service Desk processes Using Ticket Rules Run Service Desk reports Archiving, restoring, and deleting tickets Managing ticket deletion
Managing Service Desk ticket queues About User Downloads and Knowledge Base articles Customizing Service Desk ticket settings Configuring SMTP email servers
Maintenance and troubleshooting
Maintaining the appliance Troubleshooting the KACE SMA
Appendixes Glossary About us Legal notices

Access appliance logs to view Microsoft Exchange Server errors

Access appliance logs to view Microsoft Exchange Server errors

Information about Microsoft Exchange Server errors is available in KACE SMA log files when logging is enabled on the Exchange Server.

1.
In Microsoft Exchange Server, open the SMTP Virtual Server Properties window.
2.
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.
3.
Go to the appliance Control Panel:
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.
4.
On the left navigation bar, click Logs to display the Logs page.
5.
Select a log from the Log drop-down list.
6.
Examine the exim_mainlog_* and exim_paniclog_* files for problems.
7.
Examine the Debug_* log for any other Exim problems such as runaway Exim processes.

These other logs might also provide clues to the problem:

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

Troubleshooting email errors

Troubleshooting email errors

Solutions exist for some typical email errors.

Email error

Solution

550 Unknown user

451 error - unable to verify sender

Check DNS settings.

About Diagnostic Console Two-Factor Authentication

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 regenerate offline tokens, click Regenerate Offline Tokens.

Appendixes

Appendixes

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

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

Documents connexes