Chat now with support
Chat with Support

KACE Systems Management Appliance 13.0 Common Documents - Administrator 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 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 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 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
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 Maintaining device and appliance security Manage quarantined file attachments
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 appliance
Appendixes Glossary About us Legal notices

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

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

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

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

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

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

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

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

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

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

Stop a process

Stop 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 40. 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

Stop a process

Stop 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 41. Adding steps to scripts for RHEL

Step

Description

V

OS

R

ORS

ORF

Always fail

X

X

Stop a process

Stop 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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating