Chat now with support
Chat with Support

KACE Desktop Authority 11.1 - Data Dictionary

Contents 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_WindowsFirewall

The data stored in this table represents the configuration settings from the User Management Windows Firewall profile object.

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.

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.

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)

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.

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)

Related Documents