KACE Desktop Authority 11.2

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_ServicePacks

The data stored in this table represents the configuration settings from the User Management Service Pack 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
OSVersion	NVARCHAR(255)	Operating System
UpdateVersion	NVARCHAR(255)	OS Version
UpdateExecutable	NVARCHAR(255)	Location of Update.exe
OSLanguage	NVARCHAR(64)	Operating System Language
Enabled	BIT	Enabled/Disabled Element
ElementEnabled	NVARCHAR(20)	Element Enabled Flag
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_ServicePacksCBM

The data stored in this table represents the configuration settings from the Computer Management Service Pack 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
OSVersion	NVARCHAR(255)	Operating System
ProductId	NVARCHAR(3)	Microsoft Product ID
Platform	NVARCHAR(3)	x32/x64 OS Version
UpdateVersion	NVARCHAR(255)	OS Version
UpdateExecutable	NVARCHAR(255)	Location of Update.exe
OSLanguage	NVARCHAR(64)	Operating System Language
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
PatchRebootOption	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
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_Shortcuts

The data stored in this table represents the configuration settings from the User Management Shortcuts 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(255)	Create/Remove Shortcut
Location	NVARCHAR(255)	Shortcut Location
Name	NVARCHAR(255)	Shortcut Name
Target	NTEXT	Shortcut Target
Arguments	NTEXT	Target Arguments
IconFile	NVARCHAR(255)	Icon file
IconIndex	NVARCHAR(255)	Icon index
WorkingDir	NVARCHAR(255)	Start in
RunWindow	NVARCHAR(255)	Normal/Maximized/Minimized Run Window
Overwrite	NVARCHAR(64)	Overwrite existing shortcut
ShortcutKey	NVARCHAR(255)	Shortcut key
ShortcutComment	NTEXT	Shortcut comment
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_SoftwareDeployment

The data stored in this table represents the configuration settings from the User 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
WaitForDownload	NVARCHAR(10)
AllowPackageDefer	NVARCHAR(10)	Option to allow user to defer package installation
PackageDeferTries	NVARCHAR(10)	Number of times a user can defer package installation
PackageDeferTime	NVARCHAR(50)	Number of seconds a user has to respond before the package is installed
PackageDeferProgress	NVARCHAR(50)	Option to show/hide progress indicators
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
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.2 - Data Dictionary

Profile_ServicePacks

Profile_ServicePacks

Profile_ServicePacksCBM

Profile_ServicePacksCBM

Profile_Shortcuts

Profile_Shortcuts

Profile_SoftwareDeployment

Profile_SoftwareDeployment