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_PostEngineScripts

Profile_PostEngineScripts

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

Script

NVARCHAR(255)

Post-engine script with location (.KIX)

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_PowerManagement

Profile_PowerManagement

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

Action

NVARCHAR(64)

Create/Modify or Remove power scheme action

Name

NVARCHAR(64)

Power scheme name

Hibernation

NVARCHAR(64)

Enable hibernation

PromptForPassword

NVARCHAR(64)

Prompt for password when computer resumes from standby

LidAction

NVARCHAR(64)

When I close the lid of my portable computer (Plugged in)

DCLidAction

NVARCHAR(64)

When I close the lid of my portable computer (Running on Batteries)

PowerButtonAction

NVARCHAR(64)

When I press the power button on my computer (Plugged in)

DCPowerButtonAction

NVARCHAR(64)

When I press the power button on my computer (Running on Batteries)

SleepButtonAction

NVARCHAR(64)

When I press the sleep button on my computer (Plugged in)

DCSleepButtonAction

NVARCHAR(64)

When I press the sleep button on my computer (Running on Batteries)

MonitorAC

NVARCHAR(64)

Turn off monitor (Plugged in)

MonitorDC

NVARCHAR(64)

Turn off monitor (Running on batteries)

DiskAC

NVARCHAR(64)

Turn off disks (Plugged in)

DiskDC

NVARCHAR(64)

Turn off disks (Running on batteries)

StandbyAC

NVARCHAR(64)

System standby (Plugged in)

StandbyDC

NVARCHAR(64)

System standby (Running on batteries)

HibernateAC

NVARCHAR(64)

System hibernates (Plugged in)

HibernateDC

NVARCHAR(64)

System hibernates (Running on batteries)

ActionPowerPlan

NVARCHAR(64)

Action to take for power plan

PowerPlanName

NVARCHAR(64)

Power plan name

PowerPlanBasedOn

NVARCHAR(64)

Power plan based on option

DCDisplay

NVARCHAR(64)

Turn off display setting (Running on batteries)

ACDisplay

NVARCHAR(64)

Turn off display setting (Plugged in)

DCSleep

NVARCHAR(64)

Put the computer to sleep ((Running on batteries)

ACSleep

NVARCHAR(64)

Put the computer to sleep ((Plugged in)

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

Vitualization

NVARCHAR(500)

 

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_PreEngineScripts

Profile_PreEngineScripts

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

Script

NVARCHAR(255)

Pre-engine script with location (.KIX)

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_Printers

Profile_Printers

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

Printers

NVARCHAR(255)

Reserved for future use

LPT

NVARCHAR(64)

Capture LPT #

Path

NVARCHAR(255)

Shared printer path

AutoAddRemove

NVARCHAR(64)

Add/Remove printer driver

DefaultPrinter

NVARCHAR(64)

Set as default

NoCapture

NVARCHAR(64)

Do not capture LPT1

PrinterName

NVARCHAR(255)

Printer Name

IPAdddress

NVARCHAR(255)

Printer IP address

PortName

NVARCHAR(255)

Port Name

Protocol

NVARCHAR(255)

Raw/LPR Protocol

Port

NVARCHAR(255)

Port Number

SNMPName

NVARCHAR(255)

SNMP Name

PortList

NTEXT

Port Number

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