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 whenever the Reapply Schema action is taken. A single database user ID, KaseyaViews is provided to access these views. For security purposes, you must first create or change the password for the KaseyaViews user ID by entering the password in the System > Database Views page. From that point forward, you can use external applications, such as Crystal Reports or Excel, to access the database views directly, using the KaseyaViews user ID and the password you have entered.
Note: If you have a problem connecting to SQL Server 2005 using the KaseyaViews user ID, see the knowledge base article http://kb.kaseya.com/article.asp?p=11855&article=307669.
MSDE/SQL Server Variations
If you are using MSDE/SQL Server rather than the full SQL Server, there are a few minor variations to the steps listed above.