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_DataCollectionCBM

Profile_DataCollectionCBM

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

ClientHardware

NVARCHAR(10)

Collect client hardware information

InstalledSoftware

NVARCHAR(10)

Collect installed software information

PatchManagement

NVARCHAR(10)

Collect patch management information

USBPortSecurity

NVARCHAR(10)

Collect USB/Port security information

HeartBeat

NVARCHAR(20)

Option to collect machine heartbeat packets

HeartBeatTime

NVARCHAR(25)

Defined time interval to collect machine heartbeat packets

ComputerActivity

NVARCHAR(20)

Collect computer startup/shutdown information

ElementEnabled

NVARCHAR(25)

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_Display

Profile_Display

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

EnableNumLock

NVARCHAR(64)

Enable Num Lock on Boot

DisablePrintPopup

NVARCHAR(64)

Disable Print Popup

RemoveWelcome

NVARCHAR(64)

Remove Windows Welcome

RemoveIntelliMouseTips

NVARCHAR(64)

Remove Intellimouse Tips

RemoveShortcutTo

NVARCHAR(64)

Remove “Shortcut To” prefix

RemoveFindFast

NVARCHAR(64)

Remove Find Fast Startup

RemoveMSN

NVARCHAR(64)

Remove MSN Desktop Icon

RemoveMyDocuments

NVARCHAR(64)

Remove My Documents Desktop Icon

RemoveOnlineServices

NVARCHAR(64)

Remove Online Services Desktop Folder

EnableCMD

NVARCHAR(64)

Enable “Command Prompt Here”

Wallpaper

NVARCHAR(255)

Wallpaper File

MyComputer

NVARCHAR(255)

Rename “My Computer” to

NetworkNeighborhood

NVARCHAR(255)

Rename “Network Neighborhood” to

Owner

NVARCHAR(255)

Registered Owner

Company

NVARCHAR(255)

Registered Company

EnableContextRemoveControl

NVARCHAR(64)

Enable Remote Control shell extension

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_Drives

Profile_Drives

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

Letter

NVARCHAR(64)

Drive Letter

Path

NVARCHAR(255)

Mapped drive path

Hidden

NVARCHAR(64)

Hide from Windows Explorer

ExplorerLabel

NVARCHAR(255)

Explorer Label

OnError

NVARCHAR(64)

If this drive fails to map

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_Embargo

Profile_Embargo

The data stored in this table represents the configuration settings from the User Management USB/Port Security profile object.

Column

Data Type

Description

ElementID

INT

Unique element ID

ProfileID

INT

ID of the profile that this element belongs to

Priority

INT

List Priority

EmbargoText

NTEXT

Environment Text

ShowDesktopIcon

NVARCHAR(10)

Show Desktop Icon flag

ShowBalloons

NVARCHAR(10)

Show Balloons flag

Action

NVARCHAR(50)

Enabled/Disabled Element

PermittedUSBDevices

NTEXT

USB Devices permitted

LogFileAccessSuccess

NVARCHAR(10)

USB/Port Security Data Collection Option

LogFileAccessFailure

NVARCHAR(10)

USB/Port Security Data Collection Option

LogDeviceAccessSuccess

NVARCHAR(10)

USB/Port Security Data Collection Option

LogDeviceAccessFailure

NVARCHAR(10)

USB/Port Security Data Collection Option

Element Enabled

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