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 replace the secret key and regenerate the offline tokens, click Replace Secret Key.

•

To regenerate offline tokens, click Regenerate Offline Tokens.

Appendixes

Database table names

Adding steps to task sections of scripts

LDAP variables

Database table names

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

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

•

Organization-level (ORG1) database tables

•

System-level (KBSYS) database tables

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

Adding steps to task sections of scripts

LDAP variables

Database table names

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

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

•

Organization-level (ORG1) database tables

•

System-level (KBSYS) database tables

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

Please select your product:

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

Recommended Solutions for Your Problem

KACE Systems Management Appliance 14.0 Common Documents - Administration Guide

Troubleshooting email errors

About Diagnostic Console Two-Factor Authentication

Appendixes

Database table names