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

Profile_RemoteManagement

The data stored in this table represents the configuration settings from the User Management Remote Management 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

Action

NVARCHAR(64)

Install/Remove Remote Management client

Port

NVARCHAR(64)

Port used to communicate with client

TrayIcon

NVARCHAR(64)

Display Tray Icon

AlternateLocation

NVARCHAR(255)

Use alternate DesktopAuthority.exe location

Permissions

NTEXT

Grant full control to administrators

AskPermission

NVARCHAR(64)

Ask permission from the interactive user

OpenPort

NVARCHAR(64)

Open port in Windows Firewall to allow remote management

EnableRemoteRegistry

NVARCHAR(64)

Enable Remote Management Registry Service (Vista)

UseMirrorDriver

NVARCHAR(64)

Use mirror display driver

DisableWallpaper

NVARCHAR(64)

Automatically disable wallpaper

ClipboardSize

INT

Clipboard transfer size (KB)

IdleTime

INT

Idle time allowed (min)

AutoPanning

NVARCHAR(64)

Allow auto panning

Screenshots

INT

Screen shot updates per second

UseScreenshot

NVARCHAR(64)

Use screen shot based remote control by default

RemotePrinting

NVARCHAR(64)

Enable remote printing

WarningText

NTEXT

Interactive user’s warning text

WarningDuration

INT

Duration of warning in seconds

BypassWarning

NVARCHAR(64)

If warning times out, allow remote control anyway

DisplayNotification

NVARCHAR(64)

Display notification during remote control

FullControlBypass

NVARCHAR(64)

Do not ask permission if admin has full control

DisableHostInput

NVARCHAR(64)

Disable host keyboard and mouse

LockConsoleOnDrop

NVARCHAR(64)

Lock console when connection is broken

LockConsoleOnTimeout

NVARCHAR(64)

Lock console when connection times out

AlwaysLock

NVARCHAR(64)

Always lock console when remote control disconnects

BlankScreen

NVARCHAR(64)

Blank Host Sreen (non Vista only)

SessionBeep

NVARCHAR(64)

Beep whenever a session begins or ends

ConstantBeep

NVARCHAR(64)

Beep continuously during remote control

BeepInterval

INT

Beep interval in seconds

LogDays

INT

Number of days to keep logs

LogLocation

NVARCHAR(255)

Log file location

IPFilter

NTEXT

IP Filtering

AdminFullControl

NVARCHAR(64)

Do not ask permission if admin has full control

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_SecurityPolicies

The data stored in this table represents the configuration settings from the User Management Security Policies 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

Policy

NTEXT

Security Policy

Setting

INT

Enable/Disable Policy

EnableUserAccountControlOnVista

NVARCHAR(64)

User Account Control on Vista

AdminApproval

NVARCHAR(64)

Admin Approval for the Built-in Administrator account

ElevationPromptAdminApprovalMode

NVARCHAR(64)

Bahavior of the elevation prompt for administrators in Admin Approval Mode

ElevationPromptUser

NVARCHAR(64)

Behavior of the elevation prompt for standard users

PromptInstallationForElevation

NVARCHAR(64)

Detect application installations and prompt for elevation

ElevateSignedExes

NVARCHAR(64)

Only elevate executables that are signed and validated

ElevateUIAccess

NVARCHAR(64)

Only elevate UIAccess applications that are installed in secure locations

SwitchToSecureDesktopForElevation

NVARCHAR(64)

Switch to the secure desktop when prompting for elevation

VirtualizeToPerUserLocations

NVARCHAR(64)

Virtualize file and registry write failures to per-user locations

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

AllowUIAAppsToPromptOnNonSecureDesktop

NVARCHAR(64)

Allow UIAccess applications to prompt for elevation without using the secure desktop

Profile_ServicePacks

The data stored in this table represents the configuration settings from the User Management Service Pack Deployment 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

OSVersion

NVARCHAR(255)

Operating System

UpdateVersion

NVARCHAR(255)

OS Version

UpdateExecutable

NVARCHAR(255)

Location of Update.exe

OSLanguage

NVARCHAR(64)

Operating System Language

Enabled

BIT

Enabled/Disabled Element

ElementEnabled

NVARCHAR(20)

Element Enabled Flag

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_ServicePacksCBM

The data stored in this table represents the configuration settings from the Computer Management Service Pack Deployment 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

OSVersion

NVARCHAR(255)

Operating System

ProductId

NVARCHAR(3)

Microsoft Product ID

Platform

NVARCHAR(3)

x32/x64 OS Version

UpdateVersion

NVARCHAR(255)

OS Version

UpdateExecutable

NVARCHAR(255)

Location of Update.exe

OSLanguage

NVARCHAR(64)

Operating System Language

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

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

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

Related Documents