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

Column	Data Type	Description
SeverityID	INT	Severity ID
SeverityName	NVARCHAR(20)	Severity Name

Profile_Alerts

The data stored in this table represents the configuration settings from the User Management Alerts 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
Events	NVARCHAR(255)	Event
AlertTitle	NVARCHAR(255)	Alert Title
AlertType	NCHAR(64)	Alert Type
AlertText	NTEXT	Alert Text
ActiveUserWarning	BIT	Display a pop-up message to the user logging on
ActiveUserTimeout	INT	Timeout (sec)
WarningTargetList	NTEXT	List of user(s) and/or computer(s) to display a pop-up message
LogEvent	BIT	Write this alert to the client computer’s event log
RemoteLogEventList	NTEXT	Write this alert to the event log on one or more specific computers
EmailEventList	NTEXT	Email this alert to specific address
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	Notes about element
ElementEnabled	NVARCHAR(20)	Element Enabled Flag

Column	Data Type	Description
PatchApplicationID	INT	Patch Application Id
ComputerIdentificationID	INT	Computer ID
Product	NVARCHAR(255)	Patch Product
SP	NVARCHAR(255)	Patch Service Pack
FirstDetectedLocal	DATETIME	First detected (Date)
FirstDetectedUTC	DATETIME	First detected Coordinated Universal Time (UTC)
LastDetectedLocal	DATETIME	Last detected (Date)
LastDetectedUTC	DATETIME	Last detected Coordinated Universal Time (UTC)

Column	Data Type	Description
ComputerIdentificationID	INT	Computer ID
PatchItemID	INT	Patch Item ID
PatchApplicationID	INT	Patch Application ID
BulletinID	NVARCHAR(20)	Bulletin ID
BulletinTitle	NVARCHAR(255)	Bulletin Title
SQNumber	NVARCHAR(20)	MS KB article ID number
PatchName	NVARCHAR(255)	Patch Name
Severity	NVARCHAR(20)	Patch Severity
SeverityOrdinal	INT	Severity ID
Status	NVARCHAR(100)	Patch Status
FirstDetectedLocal	DATETIME	First detected (Date)
FirstDetectedUTC	DATETIME	First detected Coordinated Universal Time (UTC)
LastDetectedLocal	DATETIME	Last detected (Date)
LastDetectedUTC	DATETIME	Last detected Coordinated Universal Time (UTC)

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

PatchApplication

PatchApplication

PatchApplication_Item

PatchApplication_Item

PatchManagement_Severities

PatchManagement_Severities

Profile_Alerts

Profile_Alerts