Appendix D. ZENworks Inventory Database Schema

ZENworks for Desktops comes with several views to retrieve information from the inventory database. However, those views might not always give you the information you need exactly how you want it. If you are familiar with the Common Information Model (CIM), Desktop Management Interface (DMI), and have a solid understanding of Relational Database Based Managed Systems (RDBMS), you can access the ZENworks inventory database directly by creating your own queries and views.

Accessing the inventory database can be a powerful tool for creating metrics to measure company growth, user and workstation status, product usage, and so on. The tables in this appendix define the schema and associations in the ZENworks inventory database. Also included in this appendix are sample queries that give you a jump start at accessing the database.