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_MessageBoxes

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

Text

NTEXT

Message box text

Title

NTEXT

Message box title

Style

NVARCHAR(64)

Message box style

Timeout

INT

Timeout (sec)

Cycle

NVARCHAR(64)

Cycle

CycleData

NVARCHAR(64)

Cycle Data

Frequency

NVARCHAR(64)

Frequency

UUID

NVARCHAR(64)

Unique identifier

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_MSOffice

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

Option

NTEXT

Office option

Path

NVARCHAR(255)

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_Outlook

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

OutlookBar

NVARCHAR(64)

General - View Outlook bar

FolderList

NVARCHAR(64)

General - View Folder list

Sound

NVARCHAR(64)

Reserved for future use

DeleteWarning

NVARCHAR(64)

General - Warn before permanently deleting items

StartupFolder

NVARCHAR(255)

General - Startup in this folder

EmptyWasteBasket

NVARCHAR(255)

General - Empty the Deleted items folder on exit

NewMailNotification

NVARCHAR(64)

General - New mail arrival – Display a notification

NewMailSound

NVARCHAR(64)

General - New mail arrival – Play a sound

EnableAutoArchive

NVARCHAR(64)

General - Enable Auto Archive

AutoArchiveDays

NVARCHAR(64)

General - Number of days to AutoArchive

AutoArchivePrompt

NVARCHAR(64)

General - Prompt to AutoArchive

AutoArchiveDir

NVARCHAR(255)

General - AutoArchive Folder

AutoArchiveFile

NVARCHAR(255)

General - AutoArchive File name

AutoArchiveDeleteExpiredMail

NVARCHAR(64)

General - Delete expired items (email folder only)

AllowCommasAsAddressSeperator

NVARCHAR(64)

General - Allow comma as address separator

AutomaticNameChecking

NVARCHAR(64)

General - Automatic name checking

MessageFormat

NVARCHAR(255)

General - Message format

UseWordAsEditor

NVARCHAR(64)

General - Use MS Word as editor

SendPicturesFromInternet

NVARCHAR(64)

General - Send pictures from the Internet

 

 

 

 

 

 

SaveCopiesInSentItems

NVARCHAR(64)

General - Save copies of mail in Sent Items folder

AutoSaveMinutes

NVARCHAR(64)

General - Number of minutes to Auto-save unsent messages

SpellCheckAlways

NVARCHAR(64)

General - Always check spelling

SpellCheckSuggestReplacements

NVARCHAR(64)

General - Always suggest replacements

SpellCheckUppercase

NVARCHAR(64)

General - Ignore words in UPPERCASE

SpellCheckNumbers

NVARCHAR(64)

General - Ignore words with numbers

SpellCheckIgnoreReply

NVARCHAR(64)

General - Ignore original message in replies

PABConfig

NVARCHAR(255)

Data Files - PAB Configuration

PABFile

NVARCHAR(255)

Data Files - PAB File name

PABFolder

NVARCHAR(255)

Data Files - PAB Folder

PSTConfig

NVARCHAR(255)

Data Files - PST Configuration

PSTFile

NVARCHAR(255)

Data Files - PST File name

PSTFolder

NVARCHAR(255)

Data Files - PST Folder

NewStylePST

NVARCHAR(64)

Data Files - New Style PST file

OABConfig

NVARCHAR(255)

Data Files - OAB Configuration

OABFolder

NVARCHAR(255)

Data Files - OAB File name

OSTConfig

NVARCHAR(255)

Data Files - OAB Folder

OSTFile

NVARCHAR(255)

Data Files - OST Configuration

OSTFolder

NVARCHAR(255)

Data Files - OAB Folder

ConnectHTTP

NVARCHAR(64)

Cached Mode - Connect to Exchange mailbox using HTTP

CacheMode

NVARCHAR(64)

Cached Mode - Use Cached Exchange Mode

ProxyServer

NVARCHAR(255)

Cached Mode - URL for proxy server

ConnectSSL

NVARCHAR(64)

Cached Mode - Connect Using SSL only

MutualAuthenticate

NVARCHAR(64)

Cached Mode - Mutually authenticate when connecting with SSL

PrincipalProxyServer

NVARCHAR(255)

Cached Mode - Principal name for proxy server

 

 

 

 

 

 

FastHTTP

NVARCHAR(64)

Cached Mode - Fast networks, connect using HTTP, then TCP/IP

SlowHTTP

NVARCHAR(64)

Cached Mode - Slow networks, connect using HTTP, then TCP/IP

AuthenticateMode

NVARCHAR(64)

Cached Mode - Authentication when connecting to proxy server for Exchange

SignatureText

NTEXT

Signature - Signature Preview

SignatureName

NVARCHAR(255)

Signature - Signature Name

NewEmail

NVARCHAR(64)

Signature - Select signature for new messages (Outlook 2000)

NewEmail2k

NVARCHAR(64)

Signature - Select signature for new messages (Outlook 2002 and above)

ReplyForward

NVARCHAR(64)

Signature - Select Signature for replies and forwards (Outlook 2000)

ReplyForward2k

NVARCHAR(64)

Signature - Select Signature for replies and forwards (Outlook 2002 and above)

SpellIgnoreInternetFileAddress

NVARCHAR(64)

Spelling – Ignore internet and file URLs

SpellFlagRepeatedWords

NVARCHAR(64)

Spelling – Flag repeated words

SpellEnforceAccentedUCFrench

NVARCHAR(64)

Spelling – Enforce accented uppercase in French

SpellSuggestFromMainDictionary

NVARCHAR(64)

Spelling – Suggest from main dictionary only

PaneReadMarkItemsReadWhenViewed

NVARCHAR(64)

Other – Mark items as read when viewed in reading pane

PaneReadMarkItemsReadWhenViewedDelay

NVARCHAR(64)

Other – Wait x seconds before marking item as read

PaneReadMarkItemsReadOnSelectionChange

NVARCHAR(64)

Other – Mark email read when the selected email changes

PaneReadSingleKeyReadingUsingSpaceBar

NVARCHAR(64)

Other – Use single key reading using space bar

 

 

 

 

 

 

JunkMailLeaveAlone

NVARCHAR(64)

Junk mail - Leave junk mail settings unconfigured

JunkMailProtectionLevel

NVARCHAR(64)

Junk mail – level of selected junk e-mail protection

JunkMailPermanentlyDeleteSuspectMail

NVARCHAR(64)

Junk mail – Permanently delete suspected junk mail instead of moving it to the junk email folder

JunkMailDisableLinksInPhishingMail

NVARCHAR(64)

Junk mail – Disable links and other functionality in phishing messages

JunkMailWarnOnSuspiciousDomainNames

NVARCHAR(64)

Junk mail – Warn user about suspicious domain names in email addresses

JunkEmailPostmarkMailOnSend

NVARCHAR(64)

Junk mail – When sending email, postmark the message to help email clients distinguish good email from junk email.

JunkMailSafeSenderTrustEmailFromMyContacts

NVARCHAR(64)

Junk mail - Automatically trust e-mail from contacts in my Contacts list

JunkMailSafeSenderAutoAddPeopleEmailedToList

NVARCHAR(64)

Junk mail - Automatically add e-mail recipients to the safe senders list

JunkMailSafeSenderRemoveItemsNotDefined

NVARCHAR(64)

Junk mail - Remove any safe senders from the client that are not defined in the safe senders list

JunkMailSafeRecipientRemoveItemsNotDefined

NVARCHAR(64)

Junk mail - Remove any safe recipients from the client that are not defined in the safe recipient list

JunkMailBlockedSenderRemoveItemsNotDefined

NVARCHAR(64)

Junk mail - Remove any blocked senders from the client that are not defined in the blocked senders list

JunkMailBlockedTopLevelDomainChecked

NVARCHAR(2000)

Junk mail - Countries/Regions to add to the blocked top-level domain list

 

 

 

 

 

 

JunkMailBlockedTopLevelDomainUnChecked

NVARCHAR(2000)

Junk mail - Countries/Regions to remove from the blocked top-level domain list

JunkMailBlockedEncodingChecked

NVARCHAR(2000)

Junk mail - Encodings to add to the blocked encoding list

JunkMailBlockedEncodingUnChecked

NVARCHAR(2000)

Junk mail - Encodings to remove from the blocked encoding list

PersonNamesDislayOnLineStatus

NVARCHAR(64)

Other – Display online status next to the contact name

PersonNamesDislayOnLineStatusToCcFields

NVARCHAR(64)

Other – Display online status in the To: and Cc: field nly when mouse pointer rests the person’s name

RSSFeedRemoveItemsNotDefined

NVARCHAR(64)

Reserved for future use

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_Outlook_BlockedSender

List of Blocked Senders defined in the User Management Microsoft Outlook Settings profile object Junk E-mail tab.

BlockedSenderID

INT

Unique Blocked Sender ID

ElementID

INT

Profile object element ID

SiteAddress

NVARCHAR(2000)

Email address or domain

Action

NVARCHAR(50)

Add to/Remove from sender list

Related Documents