KACE Desktop Authority 11.3

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

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

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

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

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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

KACE Desktop Authority 11.3 - Data Dictionary

Profile_Drives

Profile_Embargo

Profile_Environment

Profile_FileOperations