Introduction to Database Views
   
Version 9.1.01
wUser’s Guide
Introduction to Database Views
APTARE StorageConsole provides a set of published read-only database views into the Reporting Database and related object model.
The database views provide a native SQL interface into the Reporting Database. APTARE publishes a collection of views that overlay the underlying database tables. Using these read-only views, you can write your own reports or stored procedure handlers to query the Reporting Database. These views provide a simple and fast mechanism to access a read-only view into the raw data maintained within the Reporting Database. Typically, you’ll use the APTARE StorageConsole SQL Template Designer to create queries for custom reports.
There are two sets of database views:
Common Views. Provides read access to the properties for every backup server that the APTARE StorageConsole maintains.
Product-Specific Views. Provides read access to information about a given underlying backup product. If your backup solution is such that it only uses properties that are typical to all backup solutions, APTARE StorageConsole does not need to provide you a product‑specific view because all properties are adequately covered by the common views.
Storage-Specific Views. Provides read access to data specific to a storage vendor, such as NetApp or HDS.
Accessing Database Views
StorageConsole has a separate user account that provides you SELECT access to the database views:
User account: aptare_ro
Password: aptaresoftware123
This user account can only access the published database views and does not have any update or insert privileges.