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_WindowsFirewall

The data stored in this table represents the configuration settings from the User Management Windows Firewall 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(64)	Enable/Disable Windows Firewall
PortList	NTEXT	Exception List
Notification	NVARCHAR(64)	Display a notification when Windows Firewall blocks a program
FileAndPrintSharing	NVARCHAR(64)	Enable File and Print sharing
NoExceptions	NVARCHAR(64)	Don’t allow exceptions
Outgoing	NVARCHAR(64)	ICMP – Allow outgoing packet redirect
Redirect	NVARCHAR(64)	ICMP – Allow redirect
Time	NVARCHAR(64)	ICMP – Allow outgoing time exceeded
Parameter	NVARCHAR(64)	ICMP – Allow outgoing parameter problem
Quench	NVARCHAR(64)	ICMP – Allow outgoing source quench
Destination	NVARCHAR(64)	ICMP – Allow outgoing destination unreachable
Router	NVARCHAR(64)	ICMP – Allow incoming router request
Mask	NVARCHAR(64)	ICMP – Allow incoming mast request
Timestamp	NVARCHAR(64)	ICMP – Allow incoming timestamp request
Echo	NVARCHAR(64)	ICMP – Allow incoming echo request
PublicOut	NVARCHAR(10)	Allow outbound connections for a public profile that do not match a rule
PublicIn	NVARCHAR(10)	Allow inbound connections for a public profile that do not match a rule
PrivateOut	NVARCHAR(10)	Allow outbound connections for a private profile that do not match a rule
PrivateIn	NVARCHAR(10)	Allow inbound connections for a private profile that do not match a rule
DomainOut	NVARCHAR(10)	Allow outbound connections for a domain profile that do not match a rule
DomainIn	NVARCHAR(10)	Allow inbound connections for a domain profile that do not match a rule
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

Profiles

The data stored in this table represents the configuration settings for each User and Computer Management profile.

Column	Data Type	Description
ProfileID	INT	Unique profile ID.
ProfileName	NVARCHAR(255)	Name of Profile
ParentProfileID	INT	Parent Profile ID
ParentProfileName	NVARCHAR(255)	Parent Profile Name
Priority	INT	Number of Profile in list.
Status	INT	Reserved for future use
Dependencies	NTEXT	Reserved for future use
Category	NVARCHAR(10)	Profile Category
ProfileEnabled	NVARCHAR(20)	Profile Enabled Flag
Enabled	BIT	Enabled/Disabled Profile
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
ElementDefaultEnabled	BIT	Default Validation Logic – Disable Element
ElementDefaultRules	NTEXT	Default Validation Logic – Rules
ElementDefaultClass	NVARCHAR(64)	Default Validation Logic Class
ElementDefaultOS	NVARCHAR(255)	Default Validation Logic OS
ElementDefaultConnectionType	NVARCHAR(64)	Default Validation Logic Connection Type
ElementDefaultTiming	NVARCHAR(255)	Default Validation Logic Timing
ElementDefaultVirtualization	NVARCHAR(500)	Default Virtualization Validation Logic type
ElementDefaultArchitecture	NVARCHAR(20)	Default Validation Logic Platform type
ElementDefaultCycle	NVARCHAR(255)	Default Validation Logic Cycle
Description	NVARCHAR(255)	Profile Description
CreatedBySID	NVARCHAR(100)	Profile Created By (SID)
LastModifiedBySID	NVARCHAR(100)	Profile Modified By (SID)
LastModifiedDate	DATETIME	Profile Modified Date

SoftwareInventory

This table is related to the parent HardwareInventory table, many to 1, for each software title found in Install/Uninstall programs of a machine’s registry. A Computer Management Data Collection element must be configured to capture this.

UserSession

This table holds the data collected for User activity Logon and Log off. A User Management Data Collection element must be configured to capture this data.

Column	Data Type	Description
SoftwareID	INT	Software Application ID
ComputerIdentificationID	INT	Computer ID
Publisher	NVARCHAR(255)	Software Publisher
DisplayName	NVARCHAR(255)	Software Name
DisplayVersion	NVARCHAR(255)	Software Version
InstallDate	NVARCHAR(255)	Install Date
InstallLocation	NVARCHAR(500)	Install Location
InstallSource	NVARCHAR(500)	Install Source
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
SessionID	INT	Unique Session ID
ComputerIdentificationID	INT	Computer ID
ComputerSessionID	INT	Computer Session ID
UserDomain	NVARCHAR(255)	User Domain
UserID	NVARCHAR(255)	User ID
UserSID	NVARCHAR(64)	User SID
ComputerDomain	NVARCHAR(255)	Computer Domain
ComputerName	NVARCHAR(255)	Computer Name
ConnectionType	NVARCHAR(64)	Connection Type
AuthenticatingServer	NVARCHAR(64)	Authenticating Server
LocalPrivilege	NVARCHAR(64)	Local Privileges
DomainPrivilege	NVARCHAR(64)	Domain Privileges
UTCOffset	INT	Coordinated Universal Time (UTC) offset
SessionStartTimeLocal	DATETIME	Session Start Time
SessionStartTimeUTC	DATETIME	Session Start Time Coordinated Universal Time (UTC)

제품을 선택하십시오.

더 나은 서비스 제공을 위해 채팅 목적을 작성해 주십시오.

문제에 대한 권장 솔루션

KACE Desktop Authority 11.3 - Data Dictionary

Profile_WindowsFirewall

Profiles

SoftwareInventory

UserSession