The system exposes a set of database views and database functions allowing clients to directly access data within the Kaseya repository. The database functions can be thought of as parameterized views. These views can be used to bring data into a spreadsheet for analysis or to prepare reports. This document describes the views and functions and gives two example applications, Crystal Reporting and Microsoft Excel. Kaseya does not present itself as an expert in how to use Excel or Crystal. These examples are to assist in the basics of getting started. For third party product training or other questions please contact the third party tool vendor. Finally, an appendix is provided with a field-by-field description of the contents of the views and functions.
The views provided can be broken into four groups of database views.
Accessing the Database Views
The database views are installed or updated whenever the Reapply Schema action is taken. A single database user ID,
Note: If you have a problem connecting to SQL Server 2005 using the