Chat now with support
Chat with Support

KACE Desktop Authority 11.2 - Data Dictionary

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

Profile_PatchManagement

Profile_PatchManagement

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

Column

Data Type

Description

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Patches

NTEXT

List of patches to deploy

Action

NTEXT

Patch Action

Server

NTEXT

Specific server to use

WaitForPatch

NVARCHAR(255)

If patches are not available, pause logon/logoff

AutoDownload

BIT

Automatically pre-download patch files to distribution servers

PatchDeploymentType

NVARCHAR(64)

Type of Deployment

AllowDefer

NVARCHAR(255)

Allow User to Defer Patches

PatchDeferTries

NVARCHAR(255)

Number of times patch installation can be deferred by user, before it is forced

PatchDeferTimeout

NVARCHAR(255)

Number of seconds for user to respond to patch installation dialog

PatchRebootOption

NVARCHAR(50)

Selected Patch Reboot option

RebootTimeout

NVARCHAR(50)

Show reboot timeout dialog for specified seconds

UserCancelReboot

NVARCHAR(50)

Allow User to cancel reboot

HideProgress

NVARCHAR(50)

Hide all progressindicators flag

DisableWindowsUpdate

NVARCHAR(20)

Disable Windows Update application from running

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_PatchManagementCBM

Profile_PatchManagementCBM

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

Column

Data Type

Description

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Patches

NTEXT

List of patches to deploy

Action

NTEXT

Patch Action

Server

NTEXT

Specific server to use

AutoDownload

BIT

Automatically pre-download patch files to distribution servers

PatchDeploymentType

NVARCHAR(64)

Type of Deployment

ShowBalloon

NVARCHAR(10)

Execution Options – Show balloon message to users before element executes

ShowBalloonMessage

NTEXT

Execution Options – Message text to display in balloon to users before element executes

AskPermission

NVARCHAR(10)

Execution Options – Ask user’s permission to execute the element

PermissionTitle

NTEXT

Execution Options – Reserved for future use

PermissionText

NTEXT

Execution Options – Permission message box text

PermissionMsgBoxTimeout

NVARCHAR(50)

Execution Options – Permission message box timeout value

PermissionDefaultAnswer

NVARCHAR(10)

Execution Options – Permission message box default answer if message box times out

RebootAfterElement

NVARCHAR(10)

Execution Options – Reboot after element executes

PatchRebootOption

NVARCHAR(50)

Execution Options – Reboot option type

RebootTimeout

NVARCHAR(50)

Execution Options – Reboot option timeout value

PostponeReboot

NVARCHAR(10)

Execution Options – Allow users to postpone reboot

AuthorizedBy

NVARCHAR(41)

Execution Options – Permission message box authorized by

DisableWindowsUpdate

NVARCHAR(20)

Disable Windows Update application from running

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

Profile_Path

Profile_Path

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

Column

Data Type

Description

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Path

NTEXT

Path

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_Permissions

Profile_Permissions

The data stored in this table represents the configuration settings from the User Management File/Registry Permissions profile object.

Column

Data Type

Description

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

Number of element in object list

Type

NVARCHAR(64)

File/Folder or Registry

Action

NVARCHAR(64)

Append/Overwrite/Revoke action

Target

NVARCHAR(400)

File/Folder Path or Hive/Key location

Permissions

NTEXT

Permissions list

Inheritance

NVARCHAR(255)

Inheritance

Depth

NVARCHAR(255)

Propagation

Children

NVARCHAR(64)

Child object to include

Force32BitKeyOn64BitOS

NVARCHAR(64)

Force use of 32-bit registry locations on 64-bit operating systems

ElementEnabled

NVARCHAR(20)

Element Enabled Flag

4Enabled

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

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating