Chat now with support
Chat with Support

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

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

Adding steps to task sections of scripts

Adding steps to task sections of scripts

You can add steps to scripts in the Scripting component.

The following tables detail the steps that can be added to the task sections of scripts. Task sections are available on the Script Detail page when you add a task. See Adding and editing scripts.

The column headings V, OS, R, ORS, and ORF indicate whether a particular step is available in the corresponding task sections: Verify, On Success, Remediation, On Remediation Success, and On Remediation Failure.

Steps for Windows devices

Table 35. Adding steps to scripts used on Windows devices

Step

Description

V

OS

R

ORS

ORF

Always fail

X

X

Call a custom DLL function

Call function "%{procName}" from "%{path}\%{file}".

X

X

X

Create a custom DLL object

Create object "%{className}" from "%{path}\%{file}".

X

X

X

Create a message window

Create a message window named "%{name}" with title "%{title}", message "%{message}" and timeout "%{timeout}" seconds.

X

X

X

X

X

Delete a registry key

Delete "%{key}" from the registry. See Specifying Windows registry paths.

X

X

Delete a registry value

Delete "%{key}!%{name}" from the registry. See Specifying Windows registry paths.

X

X

Destroy a message window

Destroy the message window named "%{name}".

X

X

X

X

X

Install an application package

Install "%{name}" with arguments "%{install_cmd}".

X

X

Kill a process

Kill the process "%{name}".

X

X

X

X

X

Launch a program

Launch "%{path}\%{program}" with params "%{parms}".

X

X

X

X

X

Log a registry value

Log "%{key}!%{name}".

X

Log file information

Log "%{attrib}" from ""%{path}\%{file}".

X

X

X

Log message

Log "%{message}" to "%{type}".

X

Restart a service

Restart service "%{name}"

X

Run a batch file

Run the batch file "%{_fake_name}" with params "%{parms}".

X

X

X

Set a registry key

Set "%{key}".

X

X

Set a registry value

Set "%{key}!%{name}" to "%{newValue}".

X

X

Start a service

Restart service "%{name}".

X

Stop a service

Stop service "%{name}"

X

Unzip a file

Unzip "%{path}\%{file}" to "%{target}".

X

X

X

X

Update message window text

Set the text in the message window named "%{name}" to "%{text}".

X

X

X

X

Update policy and job schedule

Update policy and job schedule from the appliance.

X

Upload a file

Upload "%{path}\%{file}" to the server.

X

X

Verify a directory exists

Verify that the directory "%{path}" exists.

X

Verify a file exists

Verify that the file "%{path}\%{file}" exists.

X

Verify a file version is exactly

Verify that the file "%{path}\%{file}" has version "%{expectedValue}".

X

Verify a file version is greater than

Verify that the file "%{path}\%{file}" has version greater than "%{expectedValue}".

X

Verify a file version is greater than or equal to

Verify that the file "%{path}\%{file}" has version greater than or equal to "%{expectedValue}".

X

Verify a file version is less than

Verify that the file "%{path}\%{file}" has version less than "%{expectedValue}".

X

Verify a file version is less than or equal to

Verify that the file "%{path}\%{file}" has version less than or equal to "%{expectedValue}.

X

Verify a file version is not

Verify that the file "%{path}\%{file}" does not have version "%{expectedValue}".

X

Verify a file was modified since

Verify that the file "%{path}\%{file}" was modified since "%{expectedValue}".

X

Verify a process is not running

Verify the process "%{name}" is not running.

X

Verify a process is running

Verify the process "%{name}" is running.

X

Verify a product version is exactly

Verify that the product "%{path}\%{file}" has version "%{expectedValue}".

X

Verify a product version is greater than

Verify that the product "%{path}\%{file}" has version greater than "%{expectedValue}".

X

Verify a product version is greater than or equal to

Verify that the product "%{path}\%{file}" has version greater than or equal to "%{expected-Value}".

X

Verify a product version is less than

Verify that the product "%{path}\%{file}" has version less than "%{expectedValue}".

X

Verify a product version is less than or equal to

Verify that the product "%{path}\%{file}" has version less than or equal to "%{expectedValue}".

X

Verify a product version is not

Verify that the product "%{path}\%{file}" does not have version "%{expectedValue}".

X

Verify a registry key does not exist

Verify that "%{key}" does not exist.

X

Verify a registry key exists

Verify that "%{key}" exists.

X

Verify a registry key’s subkey count is exactly

Verify that "%{key}" has exactly "%{expectedValue}" subkeys.

X

Verify a registry key’s subkey count is greater than

Verify that "%{key}" has greater than "%{expectedValue}" subkeys.

X

Verify a registry key’s subkey count is greater than or equal to

Verify that "%{key}" has greater than or equal to "%{expectedValue}" subkeys.

X

Verify a registry key’s subkey count is less than

Verify that "%{key}" has less than "%{expectedValue}" subkeys.

X

Verify a registry key’s subkey count is less than or equal to

Verify that "%{key}" has less than or equal to "%{expectedValue}" subkeys.

X

Verify a registry key’s subkey count is not

Verify that "%{key}" does not have exactly "%{expectedValue}" subkeys.

X

Verify a registry key’s value count is exactly

Verify that "%{key}" has exactly "%{expectedValue}" values.

X

Verify a registry key’s value count is greater than

Verify that "%{key}" has greater than "%{expectedValue}" values.

X

Verify a registry key’s value count is greater than or equal to

Verify that "%{key}" has greater than or equal to "%{expectedValue}" values.

X

Verify a registry key’s value count is less than

Verify that "%{key}" has less than "%{expectedValue}" values.

X

Verify a registry key’s value count is less than or equal to

Verify that "%{key}" has less than or equal to "%{expectedValue}" values.

X

Verify a registry key’s value count is not

Verify that "%{key}" does not have exactly "%{expectedValue}" values.

X

Verify a registry pattern doesn’t match

Verify that "%{key}!%{name}=%{expectedValue}" doesn't match.

X

Verify a registry pattern match

Verify that "%{key}!%{name}=%{expectedValue}" matches.

X

Verify a registry value does not exist

Verify that "%{key}!%{name}" does not exist.

X

Verify a registry value exists

Verify that "%{key}!%{name}" exists.

X

Verify a registry value is exactly

Verify that "%{key}!%{name}" is equal to "%{expectedValue}".

X

Verify a registry value is greater than

Verify that "%{key}!%{name}" is greater than "%{expectedValue}".

X

Verify a registry value is greater than or equal to

Verify that "%{key}!%{name}" is greater than or equal to "%{expectedValue}" .

X

Verify a registry value is less than

Verify that "%{key}!%{name}" is less than "%{expectedValue}".

X

Verify a registry value is less than or equal to

Verify that "%{key}!%{name}" is less than or equal to "%{expectedValue}".

X

Verify a registry value is not

Verify that "%{key}!%{name}" is not equal to "%{expectedValue}".

X

Verify a service exists

Verify the service "%{name}" exists.

X

Verify a service is running

Verify the service "%{name}" is running.

X

Specifying Windows registry paths

When specifying Windows registry paths, use the base key and specify whether the registry is on a device with 32-bit or 64-bit operating system and hardware.

For example, specify the path for HKEY_LOCAL_MACHINE for 32- and 64-bit Windows devices as follows:

Steps for Mac OS X devices

Table 36. Adding steps to scripts used on Mac OS X devices

Step

Description

V

OS

R

ORS

ORF

Always fail

X

X

Create a message window

Create a message window named "%{name}" with title "%{title}", message "%{message}" and timeout "%{timeout}" seconds.

X

X

X

X

X

Destroy a message window

Destroy the message window named "%{name}".

X

X

X

X

X

Kill a process

Kill the process "%{name}".

X

X

X

X

X

Launch a program

Launch "%{path}\%{program}" with params "%{parms}".

X

X

X

X

X

Log a plist value

Log "%{key}!%{name};"

X

Log message

Log "%{message}" to "%{type}".

X

Search file system

Search for "%{name}" in "%{startingDirectory}" on "%{drives}" and "%{action}".

X

Unzip a file

Unzip "%{path}\%{file}" to "%{target}".

X

X

X

X

Update message window text

Set the text in the message window named "%{name}" to "%{text}".

X

X

X

X

Update policy and job schedule

Update policy and job schedule from the appliance.

X

Upload a file

Upload "%{path}\%{file}" to the server.

X

X

Verify a directory exists

Verify that the directory "%{path}" exists.

X

Verify a file exists

Verify that the file "%{path}\%{file}" exists.

X

Verify a file was modified since

Verify that the file "%{path}\%{file}" was modified since "%{expectedValue}".

X

Verify a process is not running

Verify the process "%{name}" is not running.

X

Verify a process is running

Verify the process "%{name}" is running.

X

Verify a plist value equals

X

Verify a plist value exists

Verify that "%{key}" exists.

X

Verify a plist value greater than

X

Verify a plist value less than

X

Verify an environment variable equals

X

Verify an environment variable exists

X

Verify an environment variable greater than

X

Verify an environment variable less than

X

Verify at least one file matching regex exists

X

Verify count of filenames matching regex is greater than

X

Verify count of filenames matching regex is less than

X

Verify count of filenames matching regex

X

Verify file info equals

X

Verify file info greater than

X

Verify file info less than

X

Steps for Red Hat Enterprise Linux devices

Table 37. Adding steps to scripts for RHEL

Step

Description

V

OS

R

ORS

ORF

Always fail

X

X

Kill a process

Kill the process "%{name}".

X

X

X

X

X

Launch a program

Launch "%{path}\%{program}" with params "%{parms}".

X

X

X

X

X

Log message

Log "%{message}" to "%{type}".

X

Search file system

Search for "%{name}" in "%{startingDirectory}" on "%{drives}" and "%{action}".

X

Unzip a file

Unzip "%{path}\%{file}" to "%{target}".

X

X

X

X

Update policy and job schedule

Update policy and job schedule from the appliance.

X

Upload a file

Upload "%{path}\%{file}" to the server.

X

X

Verify a directory exists

Verify that the directory "%{path}" exists.

X

Verify a file exists

Verify that the file "%{path}\%{file}" exists.

X

Verify a file was modified since

Verify that the file "%{path}\%{file}" was modified since "%{expectedValue}".

X

Verify a process is not running

Verify the process "%{name}" is not running.

X

Verify a process is running

Verify the process "%{name}" is running.

X

Verify an environment variable less than

X

Verify at least one file matching regex exists

X

Verify count of filenames matching regex is greater than

X

Verify count of filenames matching regex is less than

X

Verify count of filenames matching regex

X

Verify file info equals

X

Verify file info greater than

X

Verify file info less than

X

LDAP variables

LDAP variables

The KACE SMA supports variables for use in LDAP Labels and database queries.

Device or machine variables

Device or machine variables can be used in LDAP Labels and queries to automatically group devices by name, description, and other LDAP criteria. During LDAP Label processing, the KACE SMA replaces all KBOX_ defined variables with their respective runtime values. The following table shows supported device or machine variables and their mapping to columns in the MACHINE database table and LDAP attributes.

Table 38. Device or machine variables and mappings

 

KACE SMA variable

 

KACE SMA MACHINE database table column

 

LDAP attribute mapping

KBOX_COMPUTER_NAME

NAME

cn | name

KBOX_COMPUTER_DESCRIPTION

SYSTEM_DESCRIPTION

description

KBOX_COMPUTER_MAC

MAC

macAddress

KBOX_COMPUTER_IP

IP

ipHostNumber

KBOX_USERNAME

USER_NAME

KBOX_USER_DOMAIN

USER_DOMAIN

KBOX_DOMAINUSER

USER

KBOX_CUSTOM_INVENTORY_*

CUSTOM_INVENTORY

The KBOX_CUSTOM_INVENTORY_* variable can be used to check a custom inventory value. The * is replaced with the Display Name of the custom inventory rule. Allowed characters are [a-z0-9.-]. Any other characters are replaced with an underscore (_).

User variables

User variables can be used in LDAP Labels and queries to automatically group users by domain, location, budget code, or other LDAP criteria. During LDAP Label processing, the KACE SMA replaces all KBOX_ defined variables with their respective runtime values. The following table shows supported user variables and their mapping to columns in the USER database table and LDAP attributes.

Table 39. User variables and mappings

 

KACE SMA variable

 

KACE SMA USER database table column

 

LDAP attribute mapping

KBOX_USER_NAME

USER_NAME

samAccountName

KBOX_FULL_NAME

FULL_NAME

cn | name

KBOX_EMAIL

EMAIL

mail

KBOX_DOMAIN

DOMAIN

KBOX_BUDGET_CODE

BUDGET_CODE

KBOX_LOCATION

LOCATION

1

KBOX_WORK_PHONE

WORK_PHONE

telephoneNumber

KBOX_HOME_PHONE

HOME_PHONE

homePhone

KBOX_MOBILE_PHONE

MOBILE_PHONE

mobile

KBOX_PAGER_PHONE

PAGER_PHONE

pager

KBOX_CUSTOM_1

CUSTOM_1

KBOX_CUSTOM_2

CUSTOM_2

KBOX_CUSTOM_3

CUSTOM_3

KBOX_CUSTOM_4

CUSTOM_4

KBOX_ROLE_ID

ROLE_ID

KBOX_API_ENABLED

API_ENABLED

KBOX_AMS_ID

AMS_ID

No value. This variable is not used in the KACE SMA 6.4 release.

KBOX_LOCALE_BROWSER_ID

LOCALE_BROWSER_ID

KBOX_HD_DEFAULT_QUEUE_ID

HD_DEFAULT_QUEUE_ID

KBOX_LDAP_UID

LDAP_UID

objectGUID

Glossary

Glossary

The Administrator Console is the web-based interface used to control the KACE SMA. To access the Administrator Console, go to http://<KACE_SMA_hostname>/admin where <KACE_SMA_hostname> is the hostname of your appliance. If the Organization component is enabled, you can access the System-level settings of the Administrator Console at http://<KACE_SMA_hostname>/system. To view the full path of URLs in the Administrator Console, which can be useful when searching the database or sharing links, add ui to the URL you use to log in. For example: http://<KACE_SMA_hostname>/admin.

Monitoring alerts are messages that are generated on supported server devices and sent to the KACE SMA to alert staff about errors and issues being reported in the event and system logs of the devices. See Monitoring servers.

AMP (Agent Messaging Protocol) is the communications protocol used for communication between the KACE SMA Agent, which is installed on Agent-managed devices, and the KACE SMA. AMP provides optimized real-time communications for system-management operations. See Provisioning the KACE SMA Agent.

Appliance linking enables you to log in to one appliance and access all linked appliances from the drop-down list in the top-right corner of the Administrator Console, without having to log in to each appliance separately. You can link all of the Quest K-Series appliances you manage. See Linking Quest KACE appliances.
Related Documents