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_SoftwareDeploymentCBM

Profile_SoftwareDeploymentCBM

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

PublishedPackages

NTEXT

List of published packages

Action

NVARCHAR(10)

Action selected from drop down list, Install/Uninstall

InstallAsynch

NVARCHAR(10)

Select Asynchronous installation of packages

InstallSilent

NVARCHAR(10)

Install package in silent mode

TransformFiles

NTEXT

List of published transform files

CmdLineOptions

NTEXT

Additional command line options needed for install of package

Server

NVARCHAR(255)

Distribution server

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

RebootOption

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

ContinueExecutionNotComplete

NVARCHAR(20)

Settings – Continue execution if the application has not closed

ContinueExecutionDelayMinutes

INT

Settings – Continue execution timeout value

ElementEnabled

NVARCHAR(20)

Enabled/Disabled Element

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_TimeSync

Profile_TimeSync

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

Server

NVARCHAR(255)

Time Server

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_WakeOnLanBeaconCBM

Profile_WakeOnLanBeaconCBM

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

MachineNamesToWake

NVARCHAR(4000)

List of machine names to wake

MacAddressesToWake

NVARCHAR(4000)

List of Mac Addreses to wake

TCPIPAddressesToWake

NVARCHAR(4000)

List of TCP/IP Addresses to wake

MacAddressesToExclude

NVARCHAR(4000)

List of Mac Addresses to exclude

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_WebBrowser

Profile_WebBrowser

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

DisableSecurityPage

INT

Common - Security – Prent user from changing anything on the Security page

DisableGeneralPage

INT

Common - Security – Prent user from changing anything on the General page

DisableTabsPage

INT

 

DisableConnectionPage

INT

Common - Security – Prent user from changing anything on the Connection page

DisableContentPage

INT

Common - Security – Prent user from changing anything on the Content page

DisableProgramsPage

INT

Common - Security – Prent user from changing anything on the Programs/Applications page

DisableAdvancedPage

INT

Common - Security – Prent user from changing anything on the Advanced page

DisableUserConnectionSettingsChange

INT

 

 

 

 

 

 

 

DisableFirstLaunchSetup

INT

General - Remove "First Launch" setup screen (Internet Explorer only)

GeneralApplySettingsToIE

INT

General – Apply changes to IE

GeneralApplySettingsToFF

INT

General – Apply changes to FF

GeneralDefaultBrowser

INT

General –Default Browser setting

GeneralHomePage

NTEXT

General – Home page setting

GeneralDownloadSaveLocation

NVARCHAR(1024)

General – Default save/download location

GeneralForceUserDownloadToDefaultLocation

INT

Reserved for future use

GeneralHomePageLeaveAlone

INT

Reserved for future use

SearchProviderLeaveAlone

INT

Reserved for future use

SearchProviderName

NVARCHAR(100)

Reserved for future use

SearchProviderURL

NVARCHAR(2000)

Reserved for future use

SearchProviderDownloadProvider

INT

Reserved for future use

TabSettingShowPreviewInTaskbar

INT

General – Show previews for individual tabs in the taskbar

TabSettingWarnOnClosingMultipleTabs

INT

General – Warn user when closing multiple tabs

TabSettingSwitchToNewTabWhenCreated

INT

General – Always switch to new tabs when they are created

TabSettingEnableQuickTabs

INT

General – Enable quick tabs setting

TabSettingOpenExternalLinksNewTab

INT

General – Always open links from other programs in a new tab in the current window

TabSettingForceUserToSaveDefLocation

INT

Reserved for future use

PrivacyBlockPopupWindows

INT

Privacy – Popup blocker setting

 

 

 

 

 

 

PrivacyShowInformationBar

INT

Privacy - Show Information Bar when pop-up is blocked

PrivacyClearCookies

INT

Privacy -

PrivacyRemoveAnyCookieExceptionsFromClient

INT

Privacy -

PrivacyRemementBrowsingHistory

INT

Privacy – Remember browsing history

PrivacyRememberHistoryForLeast

INT

Privacy – Number of days to remember browsing history for

PrivacyRememberDownloadHistory

INT

Privacy – Remember download history (Firefox only)

PrivacyClearHistoryWhenCloses

INT

Privacy – Clear history on browser exit

PrivacyClearBrowsing

INT

Privacy – Clear Browsing history on exit

PrivacyClearForms

INT

Privacy – Clear Form history on exit

PrivacyClearCache

INT

Privacy – Clear Cache history on exit

PrivacyClearSavedPassword

INT

Privacy – Clear Saved Passwords history on exit

PrivacyClearDownloadHistory

INT

Privacy – Clear Download history on exit (Firefox only)

PrivacyClearOfflineWebSiteData

INT

Privacy – Clear Offline website data history on exit (Firefox only)

PrivacyClearActiveLogins

INT

Privacy – Clear Active logins history on exit (Firefox only)

PrivacyClearSitePreferences

INT

Privacy – Clear Site preferences history on exit (Firefox only)

PrivacyClearInPrivateFilteringData

INT

Privacy – Clear InPrivate filtering data history on exit (Internet Explorer only)

PrivacyCompleteFormHistory

INT

Privacy – Auto complete Form history

PrivacyCompleteBrowsingHistory

INT

Privacy – Auto complete Browsing history

PrivacyCompleteFavorites

INT

Privacy – Auto complete Favorites/bookmarks

PrivacyCompleteFeeds

INT

Privacy – Auto complete Feeds (Internet Explorer only)

PrivacyCompleteUseWinSearch

INT

Privacy – Auto complete - Use Windows Search for better results (Internet Explorer only)

PrivacyCookiesSetting

INT

Privacy – Setting to determine whether cookies are accepted or not

PrivacyRemovePopupExceptionsFromClient

INT

Privacy - Delete any pop-up exceptions from client that are not defined in the pop-up blocker exception list

SecurityAllowBrowserToRememberPassword

INT

Security – Allow browser to remember passwords

SecurityPhishingFilterEnable

INT

Security – Enable phishing filter/SmartScreen

SecurityBlockReportedAttackSites

INT

Security – Block reported attack sites (FF only)

SecurityBlockReportedWebForgeries

INT

Security – Block reported web forgeries (FF only)

SecurityWarnSitesInstallAddons

INT

Security – Warn when sites try to install add-ons (FF only)

SecurityRemoveAnyAddonsExceptionsFromClient

INT

Security - Delete any exceptions from client that are not defined in the exception list

SecurityExceptionCookiesOnlyUseSitesInExceptionList

INT

Privacy – Delete any cookie exceptions from the client that are not defined in the cookie exception list

ProxySetting

INT

Windows Internet Settings -

ProxyAutoDetect

INT

Windows Internet Settings – Automatically detect settings

ProxyAutoScript

INT

Windows Internet Settings – Use an automatic configuration script

ProxyConfigURL

INT

Windows Internet Settings – Automatic proxy configuration URL

ProxyManual

INT

Windows Internet Settings – Use a proxy server for your LAN connection (does not apply to dial-up or VPN connection)

ProxyHTTPAddress

NVARCHAR(2000)

Windows Internet Settings – HTTP Proxy address

ProxyHTTPPort

INT

Windows Internet Settings - HTTP Proxy address port

ProxyUseHTTPProxyForAllProtocols

INT

Windows Internet Settings – Use the HTTP proxy server settings for all protocols

ProxySSLAddress

NVARCHAR(2000)

Windows Internet Settings – SSL Proxy address

ProxySSLPort

INT

Windows Internet Settings – SSL Proxy address port

ProxyFTPAddress

NVARCHAR(2000)

Windows Internet Settings – FTP Proxy address

ProxyFTPPort

INT

Windows Internet Settings – FTP Proxy address port

ProxyGopherAddress

NVARCHAR(2000)

Windows Internet Settings – Gopher Proxy address

ProxyGopherPort

INT

Windows Internet Settings – Gopher Proxy address port

ProxySOCKSAddress

NVARCHAR(2000)

Windows Internet Settings – SOCKS Proxy address

ProxySOCKSPort

INT

Windows Internet Settings – SOCKS Proxy address port

ProxyException

NTEXT

Windows Internet Settings – Proxy exception address

ProxyBypassForLocalAddresses

INT

Windows Internet Settings – Bypass proxy server for local addresses

InternetRestrictdRemoveFromClientNotDefined

INT

Windows Internet Settings – Remove restricted websites from the client that are not defined in the restricted site list

InternetTrustedRemoveFromClientNotDefined

INT

Windows Internet Settings - Remove trusted websites from the client that are not defined in the trusted site list

InternetTrustedRequreServerVerificationHttps

INT

Windows Internet Settings – Require server verification (https) for all sites in this zone

InternetLocalIntranetAutomaticallyDetectIntranetNetwork

INT

Windows Internet Settings – Automatically detect the intranet network

InternetLocalIntranetIncludeAllLocalNotInOtherZones

INT

Windows Internet Settings – Include all local (intranet) sties not listed in other zones

InternetLocalIntranetIncludeAllSitesThatBypassProxyServer

INT

Windows Internet Settings – Include all sites that bypass the proxy server

InternetLocalIntranetIncludeAllUNCNetworkPaths

INT

Windows Internet Settings – Include all network paths (UNCs)

InternetLocalIntranetRemoveFromClientNotDefined

INT

Windows Internet Settings - Remove websites from the client that are not defined in the local intranet site list

InternetLocalIntranetRequreServerVerificationHttps

INT

Windows Internet Settings – Require server verification (https) for all sites in the local intranet zone

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