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
ComputerIdentificationID	INT	Computer ID
ComputerName	NVARCHAR(255)	Computer Name
ComputerOU	NVARCHAR(2000)	Computer OU
Manufacturer	NVARCHAR(255)	Manufacturer
Model	NVARCHAR(64)	Computer Model
ComputerType	NVARCHAR(25)	Computer Type
ComputerClass	NVARCHAR(25)	Computer Class
SerialNumber	NVARCHAR(64)	Serial Number
Motherboard	NVARCHAR(64)	Computer Motherboard
MotherboardManufacturer	NVARCHAR(255)	Computer Motherboard Manufacturer
MotherboardName	NVARCHAR(255)	Computer Motherboard Name
MOtherboardSerialNumber	NVARCHAR(255)	Computer Motherboard Serial Number
Memory	NVARCHAR(20)	Amount of Memory
TotalInstalledRamMD	DECIMAL(20,2)	Installed Memory in MB
BIOS	NVARCHAR(255)	System BIOS
BIOSManufacturer	NVARCHAR(255)	System BIOS Manufacturer
BIOSName	NVARCHAR(255)	System BIOS Name
BIOSSerialNumber	NVARCHAR(255)	System BIOS Serial Number
OperatingSystem	NVARCHAR(64)	Installed Operating System
PatchLevel	NVARCHAR(64)	Installed Patch Level
Platform	NVARCHAR(64)	System platform
IsVirtual	NVARCHAR(64)	Virtual machine flag
VirtualEnvironment	NVARCHAR(255)	Virtual environment flag
LastUser	NVARCHAR(255)	Last user to login
FirstDetectedLocal	DATETIME	First scanned (Date)
FirstDetectedUTC	DATETIME	First Scanned Coordinated Universal Time (UTC)
ScanTimeLocal	DATETIME	Scanned since (Date)
ScanTimeUTC	DATETIME	Scanned Since Coordinated Universal Time (UTC)

ItemIdentification

This table is used internally by the data collection system to generate primary key seed values for the hardware inventory sub-tables. For most reports

Column	Data Type
ItemIdentificationID	INT
ComputerIdentificationID	INT
PID	NVARCHAR(255)
PID2	NVARCHAR(255)

Column	Data Type	Description
USB_ID	INT	USB ID
ComputerIdentificationID	INT	Computer ID
Instance	INT	USB Instance
DeviceType	NVARCHAR(64)	USB Type
DeviceName	NVARCHAR(255)	USB Device
COMPort	NVARCHAR(10)	USB Port
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

Hardware_USB

Hardware_USB

Hardware_VideoCard

Hardware_VideoCard

HardwareInventory

HardwareInventory

ItemIdentification

ItemIdentification