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_Environment

Profile_Environment

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

Variable

NVARCHAR(255)

Environment Variable

Value

NVARCHAR(1000)

Variable value

Location

NVARCHAR(255)

Variable location

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_FileOperations

Profile_FileOperations

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

Operation

NVARCHAR(64)

File operation

SourceFolder

NVARCHAR(255)

Source folder

SourceFiles

NVARCHAR(64)

Source file(s)

DestinationFolder

NVARCHAR(255)

Destination folder

DestinationFiles

NVARCHAR(64)

Destination file(s)

SubDirectories

NVARCHAR(64)

Include subdirectories

ContinueOnError

NVARCHAR(64)

Continue on error

HiddenAndSystem

NVARCHAR(64)

Include hidden/system files

ReadOnly

NVARCHAR(64)

Read-only files

Existing

NVARCHAR(64)

Existing files

Older

NVARCHAR(64)

Older files

Async

NVARCHAR(64)

Perform asynchronous action

RedirectTo32BitFolder

NVARCHAR(64)

Redirect to 32 bit folder action

FilterAction

NVARCHAR(64)

Only files

Date1

NVARCHAR(64)

Start Date

Date2

NVARCHAR(64)

End Date

Wipe

NVARCHAR(64)

Wipe disk area to DOD-3 spec

ShowProgress

NVARCHAR(64)

Show progress bar

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_FolderRedirection

Profile_FolderRedirection

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

ShellFolder

NVARCHAR(255)

Shell Folder

RedirectToFolder

NVARCHAR(255)

Redirect to Folder

Relocation

NVARCHAR(64)

Copy any files that exist in the original folder

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_General

Profile_General

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

Purge

NVARCHAR(64)

Never/Prompt/Always Purge client files

TempLocation

NVARCHAR(255)

Files to purge

Password

NVARCHAR(255)

Set Local Admin Password

PasswordWarningDays

NVARCHAR(64)

Number of days to warn user before network password expires

FreeSpaceWarningLimit

NVARCHAR(64)

Warn user on low disk space (MB)

ClearLogin

NVARCHAR(64)

Don’t display last user name

LimitConcurrentDrive

NVARCHAR(64)

Limit concurrent logons by monitoring the share mapped using drive

DisconnectAllDrives

NVARCHAR(64)

Disconnect all existing network drives before mapping new ones

DisconnectNetworkPrinters

NVARCHAR(64)

Disconnect all existing network printers before connecting new ones

DisconnectIPPrinters

NVARCHAR(64)

Disconnect all existing IP printers before connecting new ones

ClearAllPoliciesFirst

NVARCHAR(64)

Clear all existing security policies

RemoveIETour

NVARCHAR(64)

Remove IE tour

RemoveInternetConnectionWizard

NVARCHAR(64)

Remove Internet connection wizard

HideAgentIcon

NVARCHAR(64)

Do not show desktop agent icon in system tray

AlwaysRestart

NVARCHAR(64)

Always restart computer, even it shut down is selected (Non Vista)

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating