KACE Desktop Authority 11.3 - Data Diagram

Contents

Contents

Database Schema

For readability and ease of use, the DA Reporting Database Schema shown on the following pages is broken up into logical groupings, User Management Profile Data, Computer Management Profile Data, Hardware/Software Inventory, User/Computer Activity Data, Anti-malware and Anti-spyware.

The grouping of tables that make up the User Management Profile Data consists of all profile and configuration element data for User Management profile objects configured in the Manager.

The grouping of tables that make up the Computer Management Profile Data consists of all profile and configuration element data for Computer Management profile objects configured in the Manager.

The Hardware/Software Inventory grouping consists of data that is collected from and about hardware and software clients that log on to the network.

The grouping of tables that make up the User/Computer Activity Data consists of data collected as users/computers log on and off the network. This set makes up the data needed for User Activity reporting.

The Profile data is periodically updated from the DACONFIGURATION database to the DAREPORTING database. The period in which the database is updated is configured in the ETLProcessor plugin. This is found on the OpsMaster Service tab of Server Manager.

When viewing the following diagrams, zoom in for a more precise view. A full printable version of the diagrams can be downloaded from the Quest web site.

User Management Profile Data

NOTE: When viewing this diagram, zoom in for a more precise view. A full printable version of this diagram can be downloaded from the Quest web site.