Next Topic

Previous Topic

Book Contents

Database Views

System > 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 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.

  • The SQL server name is always [ComputerName]\KVSAMSDE for Kaseya installations before 4.7. For 4.7 Kaseya installations and later the SQL server name is [ComputerName]\KVSAEXPR05.
  • Always set the authentication using a logon ID and password. This will be KaseyaViews with the password you have defined.