Database Views and Functions

System > Database Access > Database Views

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.

• The first group provides information on all the machines being monitored. 
• The second group provides information about the activity and current status of key parts of the system.  
• The third group provides information on the ticketing system.  
• The fourth group provides information on the monitoring alarms.

Accessing the Database Views

The database views are installed or updated whenever the Reapply Schema action is taken. A single database user ID, KaseyaViews is provided to access these views.

1. 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.
2. 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.