Next Topic

Previous Topic

Book Contents

Database Views

System > Database Views

The system exposes a set of database views allowing clients to directly access data within the Kaseya repository. These views can be used by to bring data into a spreadsheet for analysis or to prepare reports. This document describes the views 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.

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 provide information on the monitoring alarms.

Access to Views

The views are installed whenever the Reapply Schema action is taken.  Once this is accomplished the views are ready to be used.  A single data user id, KaseyaViews will be provided. To give access to these views an administrator needs to go to the system menu. Under the title View Access there is a function to change the password of KaseyaViews. By selecting this option the administrator will be presented with a screen to enter a password. Once this is accomplished, the new views can be accessed using the KaseyaViews user id and the password entered.

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.