Chat now with support
Chat with Support

KACE Systems Management Appliance 14.1 Common Documents - Administration Guide

About the KACE Systems Management Appliance 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 Managing user notifications Enable Two-Factor Authentication for all users Verifying port settings, NTP service, and website access Configuring network and security 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 Configuring Content Security Policy
Setting up and using labels to manage groups of items Configuring user accounts, LDAP authentication, and SSO Deploying the KACE Agent to managed devices 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 Registering KACE Agent with the appliance Provisioning the KACE Agent Manually deploying the KACE Agent Using Agentless management Adding devices manually in the Administrator Console or by using the API Forcing inventory updates About Remote Control 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 Using Task Chains
Patching devices and maintaining security
Using the Security Dashboard About patch management Subscribing to and downloading patches Creating and managing patch schedules Managing patch inventory Managing Windows Feature Updates Managing Dell devices and updates Managing Linux package upgrades Manage quarantined file attachments
Using reports and scheduling notifications Monitoring devices
Getting started with 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 appliance
Appendixes Glossary About us Legal notices

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 appliance 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 appliance 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 appliance 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 appliance:

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 36. 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 Agent

CLIENT_DISTRIBUTION

Appliance Administration: KACE 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

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

PATCH_FILTER

Security: Patch Management

PATCH_LABEL_JT

Security: Patch Management

PATCH_MACHINE_REMEDIATION_STATUS

Security: Patch Management

PATCH_MACHINE_STATUS

Security: Patch Management

PATCH_PATCH_COUNT

Security: Patch Management

PATCH_SCHEDULE

Security: Patch Scheduling

PATCH_SCHEDULE_DEPLOY_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_DETECT_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_MACHINE_STATUS

Security: Patch Scheduling

PATCH_SCHEDULE_OS_JT

Security: Patch Scheduling

PATCH_SCHEDULE_ROLLBACK_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_RUN

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_COUNTS

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_LOG

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_MACHINE

Security: Patch Scheduling

PATCH_SETTINGS

Security: Subscriptions

PATCH_STATUS

Security: Patch Management

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

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 37. 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

PATCH_ATTRIBUTE

Security: Patch Management

PATCH_CATALOG_RUN_STATUS

Security: Patch Management

PATCH_CATALOG_UPDATE_STATUS

Security: Patch Management

PATCH_ERROR_CODE

Security: Patch Management

PATCH_LANGUAGE

Security: Patch Management

PATCH_OS

Security: Patch Management

PATCH_PACKAGE

Security: Patch Management

PATCH_PAYLOAD_DOWNLOAD_STATUS

Security: Patch Management

PATCH_PRODUCT

Security: Patch Management

PATCH_PRODUCT_JT

Security: Patch Management

PATCH_PRODUCT_OS_JT

Security: Patch Management

PATCH_PRODUCT_TITLED_APPLICATION_JT

Security: Patch Management

PATCH_PRODUCT_TITLED_SUITE_JT

Security: Patch Management

PATCH_RESOURCE

Security: Patch Management

PATCH_SUPERCEDES_JT

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

Database table names

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 appliance:

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 36. 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 Agent

CLIENT_DISTRIBUTION

Appliance Administration: KACE 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

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

PATCH_FILTER

Security: Patch Management

PATCH_LABEL_JT

Security: Patch Management

PATCH_MACHINE_REMEDIATION_STATUS

Security: Patch Management

PATCH_MACHINE_STATUS

Security: Patch Management

PATCH_PATCH_COUNT

Security: Patch Management

PATCH_SCHEDULE

Security: Patch Scheduling

PATCH_SCHEDULE_DEPLOY_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_DETECT_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_MACHINE_STATUS

Security: Patch Scheduling

PATCH_SCHEDULE_OS_JT

Security: Patch Scheduling

PATCH_SCHEDULE_ROLLBACK_LABEL_JT

Security: Patch Scheduling

PATCH_SCHEDULE_RUN

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_COUNTS

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_LOG

Security: Patch Scheduling

PATCH_SCHEDULE_RUN_MACHINE

Security: Patch Scheduling

PATCH_SETTINGS

Security: Subscriptions

PATCH_STATUS

Security: Patch Management

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

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 37. 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

PATCH_ATTRIBUTE

Security: Patch Management

PATCH_CATALOG_RUN_STATUS

Security: Patch Management

PATCH_CATALOG_UPDATE_STATUS

Security: Patch Management

PATCH_ERROR_CODE

Security: Patch Management

PATCH_LANGUAGE

Security: Patch Management

PATCH_OS

Security: Patch Management

PATCH_PACKAGE

Security: Patch Management

PATCH_PAYLOAD_DOWNLOAD_STATUS

Security: Patch Management

PATCH_PRODUCT

Security: Patch Management

PATCH_PRODUCT_JT

Security: Patch Management

PATCH_PRODUCT_OS_JT

Security: Patch Management

PATCH_PRODUCT_TITLED_APPLICATION_JT

Security: Patch Management

PATCH_PRODUCT_TITLED_SUITE_JT

Security: Patch Management

PATCH_RESOURCE

Security: Patch Management

PATCH_SUPERCEDES_JT

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating