Chat now with support
Chat with Support

KACE Desktop Authority 11.1 - Data Dictionary

Contents Database Schema
User Management Profile Data Computer Management Profile Data Hardware/Software Inventory Data User/Computer Activity Data ComputerIdentification ComputerSession DAConfigurationAuditLog DataImportConfiguration DomainUsers Hardware_Display Hardware_Inventory Hardware_IPAddress Hardware_LogicalDisk Hardware_Modem Hardware_NIC Hardware_Printer Hardware_Processor Hardware_SIMM Hardware_Storage Hardware_USB Hardware_VideoCard HardwareInventory ItemIdentification PatchApplication PatchApplication_Item PatchManagement_Severities Profile_Alerts Profile_ApplicationLauncher Profile_ApplicationLauncherCBM Profile_CommonFolderRedirection Profile_DataCollection Profile_DataCollectionCBM Profile_Display Profile_Drives Profile_Embargo Profile_Environment Profile_FileOperations Profile_FolderRedirection Profile_General Profile_GroupPolicyTemplates Profile_Inactivity Profile_INIFiles Profile_LegalNotice Profile_Logging Profile_MailProfile Profile_MessageBoxes Profile_MSOffice Profile_Outlook Profile_Outlook_BlockedSender Profile_Outlook_SafeRecipient Profile_Outlook_SafeSender Profile_PatchManagement Profile_PatchManagementCBM Profile_Path Profile_Permissions Profile_PostEngineScripts Profile_PowerManagement Profile_PreEngineScripts Profile_Printers Profile_Registry Profile_RegistryCBM Profile_RemoteManagement Profile_SecurityPolicies Profile_ServicePacks Profile_ServicePacksCBM Profile_Shortcuts Profile_SoftwareDeployment Profile_SoftwareDeploymentCBM Profile_TimeSync Profile_WakeOnLanBeaconCBM Profile_WebBrowser Profile_WebBrowser_ExceptionAddOn Profile_WebBrowser_ExceptionCookies Profile_WebBrowser_ExceptionPassword Profile_WebBrowser_ExceptionPopUp Profile_WebBrowser_IntranetSite Profile_WebBrowser_RestrictedSite Profile_WindowsFirewall Profiles SoftwareInventory UserSession UserSessionActivity
About us

PatchManagement_Severities

This table holds the default Patch Management severity levels (ie. Critical, Important, Moderate, Low).

SeverityID

INT

Severity ID

SeverityName

NVARCHAR(20)

Severity Name

Profile_Alerts

The data stored in this table represents the configuration settings from the User Management Alerts profile object.

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Events

NVARCHAR(255)

Event

AlertTitle

NVARCHAR(255)

Alert Title

AlertType

NCHAR(64)

Alert Type

AlertText

NTEXT

Alert Text

ActiveUserWarning

BIT

Display a pop-up message to the user logging on

ActiveUserTimeout

INT

Timeout (sec)

WarningTargetList

NTEXT

List of user(s) and/or computer(s) to display a pop-up message

LogEvent

BIT

Write this alert to the client computer’s event log

RemoteLogEventList

NTEXT

Write this alert to the event log on one or more specific computers

EmailEventList

NTEXT

Email this alert to specific address

Enabled

BIT

Enabled/Disabled Element

Rules

NTEXT

Validation Logic Rules

Class

NVARCHAR(64)

Validation Logic Class

OS

NVARCHAR(255)

Validation Logic OS

ConnectionType

NVARCHAR(64)

Validation Logic Connection Type

Timing

NVARCHAR(255)

Validation Logic Timing

Virtualization

NVARCHAR(500)

Virtualization Validation Logic type

Architecture

NVARCHAR(20)

Validation Logic Platform type

Description

NVARCHAR(255)

Element Description

CreatedBySID

NVARCHAR(100)

Element Created By (SID)

LastModifiedBySID

NVARCHAR(100)

Element Modified By (SID)

LastModifiedDate

DATETIME

Element Modified Date

Notes

NTEXT

Notes about element

ElementEnabled

NVARCHAR(20)

Element Enabled Flag

Profile_ApplicationLauncher

The data stored in this table represents the configuration settings from the User Management Application Launcher profile object.

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Filespec

NTEXT

Filespec of application to launch

Arguments

NTEXT

Arguments

Cycle

NVARCHAR(64)

Cycle

CycleData

NVARCHAR(64)

Cycle data

Frequency

NVARCHAR(64)

Frequency

LaunchTiming

NVARCHAR(64)

Validation Logic Timing

Hide

NVARCHAR(64)

Hide any screen output

Async

NVARCHAR(64)

Launch asynchronously

ShowMessageBox

NVARCHAR(64)

Show Time-Out Message Box

MessageBoxWindowTitle

NVARCHAR(255)

Time-out message box window title

MessageBoxMessage

NVARCHAR(1000)

Time-out message box window message

MessageBoxTimeout

NVARCHAR(64)

Number of seconds to display time-out message box

RunAsAdmin

NVARCHAR(64)

Run as Administrator

UUID

NVARCHAR(64)

Unique identifier

ElementEnabled

NVARCHAR(20)

Element Enabled Flag

Enabled

BIT

Enabled/Disabled Element

Rules

NTEXT

Validation Logic Rules

Class

NVARCHAR(64)

Validation Logic Class

OS

NVARCHAR(255)

Validation Logic OS

ConnectionType

NVARCHAR(64)

Validation Logic Connection Type

Timing

NVARCHAR(255)

Validation Logic Timing

Virtualization

NVARCHAR(500)

Virtualization Validation Logic type

Architecture

NVARCHAR(20)

Validation Logic Platform type

Description

NVARCHAR(255)

Element Description

CreatedBySID

NVARCHAR(100)

Element Created By (SID)

LastModifiedBySID

NVARCHAR(100)

Element Modified By (SID)

LastModifiedDate

DATETIME

Element Modified Date

Notes

NTEXT

User notes about each element

 

Profile_ApplicationLauncherCBM

The data stored in this table represents the configuration settings from the Computer Management Application Launcher profile object.

 

 

 

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Filespec

NTEXT

Filespec of application to launch

Arguments

NTEXT

Arguments

Async

NVARCHAR(64)

Launch application asynchronously

Cycle

NVARCHAR(64)

Cycle

CycleData

NVARCHAR(64)

Cycle data

Frequency

NVARCHAR(64)

Frequency

LaunchTiming

NVARCHAR(64)

Validation Logic Timing

Hide

NVARCHAR(64)

Hide any screen output

Async

NVARCHAR(64)

Launch asynchronously

ShowMessageBox

NVARCHAR(64)

Show Time-Out Message Box

ShowBalloon

NVARCHAR(10)

Show balloon message to users before element executes

ShowBalloonMessage

NTEXT

Balloon message text

AskPermission

NVARCHAR(10)

Ask user’s permission to execute element

PermissionTitle

NTEXT

Reserved for future use

PermissionText

NTEXT

Permission message box text

PermissionMsgBoxTimeout

NVARCHAR(50)

Amt of time for message box to timeout

PermissionDefaultAnswer

NVARCHAR(10)

Default answer if message box times out

RebootAfterElement

NVARCHAR(10)

Reboot after element executes

RebootOption

NVARCHAR(50)

Reboot type

RebootTimeout

NVARCHAR(50)

Reboot in xx seconds

PostponeReboot

NVARCHAR(10)

Allow users to postpone reboot

AuthorizedBy

NVARCHAR(41)

User giving permission

ContinueExecutionNotComplete

NVARCHAR(20)

Continue execution if the application has not closed

ContinueExecutionDelayMinutes

INT

Continue execution timeout value hh/mm

ElementEnabled

NVARCHAR(20)

Element Enabled Flag

Enabled

BIT

Enabled/Disabled Element

Rules

NTEXT

Validation Logic Rules

Class

NVARCHAR(64)

Validation Logic Class

OS

NVARCHAR(255)

Validation Logic OS

ConnectionType

NVARCHAR(64)

Validation Logic Connection Type

Timing

NVARCHAR(255)

Validation Logic Timing

Virtualization

NVARCHAR(500)

Virtualization Validation Logic type

Architecture

NVARCHAR(20)

Validation Logic Platform type

ScheduleCycle

NVARCHAR(128)

Scheduled Timing cycle

Description

NVARCHAR(255)

Element Description

CreatedBySID

NVARCHAR(100)

Element Created By (SID)

LastModifiedBySID

NVARCHAR(100)

Element Modified By (SID)

LastModifiedDate

DATETIME

Element Modified Date

Notes

NTEXT

User notes about each element

Related Documents